stader_v1_ethereum

Tables

MaticX_ClaimWithdrawal_event

Withdrawal claim events from Stader’s MaticX liquid staking protocol on Ethereum, tracking when users finalize unstaking requests and receive their underlying MATIC tokens. Records include withdrawal request index, claimant address, and claimed amount for analyzing unstaking flows and liquidity 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__from`	`STRING`	Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__idx`	`STRING`	Index of the withdrawal request being claimed from the user’s withdrawal queue. Identifies the specific unstaking position in sequential order starting from 0.
`in__amountClaimed`	`STRING`	Amount of MATIC tokens claimed by the user in the withdrawal request, denominated in wei (smallest unit, 10^-18 MATIC). Values are typically in the billions to trillions of wei, representing hundreds to millions of MATIC tokens.

Sample Data

address	in__idx	removed	in__from	log_index	block_number	block_timestamp	transaction_hash	in__amountClaimed
0xf03a7eb46d01d9ecaa104558c732cf82f6b6b645	0	false	0x51fbd322f615acb9461973bd382c76d99bab415f	217	17665237	2023-07-10T19:08:23.000Z	0x11177de9e086104e6d4db515fb159bcd2581107516d1cca8f4ceedfd18645d83	2401274338549892982069
0xf03a7eb46d01d9ecaa104558c732cf82f6b6b645	0	false	0xeb0480e62a441268d691ab08a10617ce382d5d55	269	17543247	2023-06-23T15:45:59.000Z	0xe4aa82cb8e1814b44df46747174265f727d89e1c364377a1c14dce58f98711ff	10079526646955766780707
0xf03a7eb46d01d9ecaa104558c732cf82f6b6b645	3	false	0x316bde155acd07609872a56bc32ccfb0b13201fa	291	17541336	2023-06-23T09:20:23.000Z	0x4520243b3ca97e72167630bdd99d603a68aa54321cf47e177199f2607d78719b	1067333579018006938

Example Query

Query with partition filter

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

MaticX_DistributeFees_event

Fee distribution events from Stader’s MaticX liquid staking token contract on Ethereum. Records protocol fee allocations with recipient addresses and amounts, useful for analyzing revenue distribution and treasury operations.

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__address`	`STRING`	Address of the account or contract involved in the operation. 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).

Sample Data

address	removed	log_index	in__amount	in__address	block_number	block_timestamp	transaction_hash
0xf03a7eb46d01d9ecaa104558c732cf82f6b6b645	false	223	4470049324043058645292	0x80a43dd35382c4919991c5bca7f46dd24fde4c67	17769082	2023-07-25T09:00:35.000Z	0x02ae9d0257d2894f04ff1813a9eb28a4963ae3c88aabb62f3f20777029fbb14a
0xf03a7eb46d01d9ecaa104558c732cf82f6b6b645	false	25	1926591257419393409140	0x80a43dd35382c4919991c5bca7f46dd24fde4c67	15846422	2022-10-28T12:00:59.000Z	0x833ad1342d2848167b29a0f971ec22ac7c20080d756a0fd380a3a257e6baaa15
0xf03a7eb46d01d9ecaa104558c732cf82f6b6b645	false	761	1700018245609401196299	0x80a43dd35382c4919991c5bca7f46dd24fde4c67	16196229	2022-12-16T09:01:35.000Z	0x2755bc16ee5e18e1634400eb801e97b380ac41e698652ae76d89913238630a8f

Example Query

Query with partition filter

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

MaticX_Submit_event

MaticX deposit events on Ethereum from Stader’s liquid staking protocol where users submit MATIC tokens to receive MaticX. Tracks user addresses and deposit amounts for analyzing staking flows and protocol growth.

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).

Sample Data

address	removed	in__from	log_index	in__amount	block_number	block_timestamp	transaction_hash
0xf03a7eb46d01d9ecaa104558c732cf82f6b6b645	false	0x9b7a79ba95d06aad64d0941c850f6472acb0ca8c	114	560763154130000000000	17552180	2023-06-24T21:55:47.000Z	0x2ab821de911fa038e9d0b93d208e87f58cb8ab68909b2af99b0f459c05c65ccd
0xf03a7eb46d01d9ecaa104558c732cf82f6b6b645	false	0x0d29767c95196b791cdb1a6057b3c3f3348f3958	1070	10000000000000000000000000	17180568	2023-05-03T13:43:35.000Z	0x6ca1853db7e0447f77a597c04720a628ef09a6e951d57b011646eb5c5174dd9a
0xf03a7eb46d01d9ecaa104558c732cf82f6b6b645	false	0x14f197dc353a96d0ba149a9446498ec3698de6b0	47	625000000000000000000	18447544	2023-10-28T08:35:59.000Z	0x180c1acde32257407659940f4258adadaa1939ef49643734c0ccd87eae27f514

Example Query

Query with partition filter

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

StaderStakePoolsManager_Deposited_event

ETH deposit events from Stader liquid staking protocol showing user stakes converted to shares. Tracks deposit amounts, share issuance ratios, and account activity for analyzing Stader’s ETH staking pool participation and share pricing 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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_caller	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xcf5ea1b38380f6af39068375516daf40ed70d299	false	0x3cb673783b7f383afc87d9e39e9b44f86cfd1b08	10000000000000000	0x3cb673783b7f383afc87d9e39e9b44f86cfd1b08	9932367518210166	46	18127024	2023-09-13T11:14:59.000Z	0xe61b7020c4375fb0cb9f742465351fa0bbdc432d2e85e12780a04ed7eb204b5b
0xcf5ea1b38380f6af39068375516daf40ed70d299	false	0x0b78d32283d18b1fef3580faa771cd38f78ae9fb	100000000000000	0x0b78d32283d18b1fef3580faa771cd38f78ae9fb	99323675182101	184	18127006	2023-09-13T11:11:23.000Z	0x25b998fd0117e6a27dc926df11982b536ad787f3078cc86a662e3bb0e99bd4ac
0xcf5ea1b38380f6af39068375516daf40ed70d299	false	0x0b793681625182a90e8df072215d5dafb8b29fb3	1000000000000000	0x0b793681625182a90e8df072215d5dafb8b29fb3	999994386291698	18	17628193	2023-07-05T14:11:35.000Z	0xfa8f41366c17a2f52566ec98005628cc0df1115f456c1cdc92daac092a6d8c22

Example Query

Query with partition filter

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

UserWithdrawalManager_finalizeUserWithdrawalRequest_function

Function call records for finalizing user withdrawal requests on Stader liquid staking protocol (Ethereum), tracking ETH unstaking completions from the UserWithdrawalManager contract. Used to analyze withdrawal processing patterns, gas costs, and operator behavior in the unstaking queue.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
625495	true	552443	0xad8a16dc	0x9f0491b32dbce587c50c4c43ab303b06478193a7	20216162	0x8f30ddc8dfb07055afa02d44a8a4e25c0542737e	2024-07-02T03:30:59.000Z	0x01a423600ae88952ea2df4b37a5b27854f5e97b6e7bd67bcb9ba24c87b8a0851
477400	true	419319	0xad8a16dc	0x9f0491b32dbce587c50c4c43ab303b06478193a7	22828873	0x8f30ddc8dfb07055afa02d44a8a4e25c0542737e	2025-07-02T03:31:23.000Z	0x1e87cd579b4171d7a6da45680ee2b36fcf29b9643cd03890f79c1fd040f1e677
590392	true	564263	0xad8a16dc	0x9f0491b32dbce587c50c4c43ab303b06478193a7	18324540	0x8f30ddc8dfb07055afa02d44a8a4e25c0542737e	2023-10-11T03:30:59.000Z	0x06336585d0d7675c5d13a111a272d0dc61b246eefbaed677ac959099103b1e69

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

MaticX_ClaimWithdrawal_event

MaticX_DistributeFees_event

MaticX_Submit_event

StaderStakePoolsManager_Deposited_event

UserWithdrawalManager_finalizeUserWithdrawalRequest_function

​Tables

​MaticX_ClaimWithdrawal_event

​MaticX_DistributeFees_event

​MaticX_Submit_event

​StaderStakePoolsManager_Deposited_event

​UserWithdrawalManager_finalizeUserWithdrawalRequest_function

Tables

MaticX_ClaimWithdrawal_event

MaticX_DistributeFees_event

MaticX_Submit_event

StaderStakePoolsManager_Deposited_event

UserWithdrawalManager_finalizeUserWithdrawalRequest_function