stakewise_v1_ethereum

Tables

RewardEthTokenV2_RewardsUpdated_event

StakeWise V1 reward distribution events on Ethereum tracking periodic ETH staking rewards allocated to stakers, protocol, and node operators. Used to analyze reward accrual rates, fee splits, and cumulative earnings from staked ETH 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_periodRewards`	`STRING`	Total staking rewards earned by the pool during this specific reward period, denominated in wei (1e18 = 1 ETH). This value represents the gross rewards before distribution to protocol, distributors, and stakers.
`in_totalRewards`	`STRING`	Total cumulative rewards accrued in the StakeWise V2 RewardEthToken contract since inception, denominated in wei (18 decimals). This monotonically increasing value represents the sum of all protocol, distributor, and period rewards allocated over time.
`in_rewardPerToken`	`STRING`	Accumulated rewards per staked token at the time of the update, denominated in wei (18 decimals). This value increases monotonically with each rewards distribution and represents the cumulative reward rate for calculating individual staker balances.
`in_distributorReward`	`STRING`	Total rewards allocated to distributors for this period, denominated in wei (1e-18 ETH). Typically represents roughly 44-50% of period rewards based on StakeWise V1 protocol fee structure.
`in_protocolReward`	`STRING`	Staking protocol’s fee portion from the reward distribution for this period, denominated in wei (10^-18 ETH). Can be zero in early periods before protocol fees were introduced, typically around 10% of period rewards in later samples.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_totalRewards	in_periodRewards	transaction_hash	in_protocolReward	in_rewardPerToken	in_distributorReward
0x20bc832ca081b91433ff6c17f85701b6e92486c5	false	214	16419599	2023-01-16T13:18:35.000Z	4461455198120758348275	11150422165232672041	0x883ea1751d7d29e37b555654fb2b954b327d69eb7ad3b3098e47863cd417e5f3	1115042216523267204	99708630272418388	4896942907865288015
0x20bc832ca081b91433ff6c17f85701b6e92486c5	false	273	15177316	2022-07-20T04:11:48.000Z	2587028119084000000000	7475123506000000000	0x20c840a46467022d597f29b7a1dc0f49baf314a373a1e0342feb5c7d0db22f87	747512350600000000	74132277803101932	2999825396020068828
0x20bc832ca081b91433ff6c17f85701b6e92486c5	false	163	14019094	2022-01-16T21:53:40.000Z	1376037083677000000000	7411818917000000000	0x4f261b6ba1d8ae626d6e2d8ef2d1991f46544e247e6035edabc7fb8ee5dc19e7	0	52849473507084921	2771993196037997239

Example Query

Query with partition filter

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

Solos_DepositAdded_event

ETH staking deposits into StakeWise v1 solo validator contracts, tracking 32 ETH increments per validator with unique solo IDs and withdrawal credentials. Used for monitoring individual validator activations and staking flow analysis.

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_soloId`	`STRING`	Unique identifier for an individual solo staking deposit within StakeWise V1. Hex-encoded 64-character string that groups multiple deposit transactions for the same solo validator setup.
`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_withdrawalCredentials`	`STRING`	Ethereum 2.0 withdrawal credentials designating where staked ETH and rewards can be withdrawn for this solo validator. Hex-encoded 32-byte hash that remains constant for the validator’s lifecycle.

Sample Data

address	removed	in_amount	in_sender	in_soloId	log_index	block_number	block_timestamp	transaction_hash	in_withdrawalCredentials
0xeadcba8bf9aca93f627f31fb05470f5a0686ceca	false	32000000000000000000	0xeb715cac7b8ddfbfa89dc7efff5d7a80b49bf33b	0xf5f832a6326511fc88f7b26bc843ae95118c7b1fa494da8dae89ed99ab8a213b	282	12964934	2021-08-05T12:21:38.000Z	0xac3c8558e74981188942e6aafcfce173430497e5a22fe6505f30c57f205cd6a5	0x00d82aba0c912af4835003f2d4db0f300b2f0a073d4b84eb294163cf8315b13f
0xeadcba8bf9aca93f627f31fb05470f5a0686ceca	false	320000000000000000000	0xeb715cac7b8ddfbfa89dc7efff5d7a80b49bf33b	0xf5f832a6326511fc88f7b26bc843ae95118c7b1fa494da8dae89ed99ab8a213b	511	12967244	2021-08-05T20:58:01.000Z	0xf8566c51069e10a44694b2c77f1e6f9c8148fa7aec355a88e4c574ecc545c9e9	0x00d82aba0c912af4835003f2d4db0f300b2f0a073d4b84eb294163cf8315b13f
0xeadcba8bf9aca93f627f31fb05470f5a0686ceca	false	32000000000000000000	0x49428f4f098f4d34f4b0208f932a4e5c95baf6f9	0x1136f20e98586e0bbc20143562619c1c557a1ce6ddfe825542722c77e3bd3e8c	447	13302271	2021-09-26T15:44:03.000Z	0x3b6e92e5736276ab38b2043b9fcf5b69c0ea9ee93dcf9ef8c48246bdeb5aa7aa	0x001583c22e49a5bbc048c85587ec0bf0cc503185b800341af456758fdf9ea01d

Example Query

Query with partition filter

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

Solos_ValidatorRegistered_event

Ethereum validator registration events from StakeWise V1’s solo staking product, recording validator public keys, operators, unique solo IDs, and registration prices (10 ETH per validator). Used for tracking validator onboarding and operator activity in StakeWise’s non-pooled staking service.

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_soloId`	`STRING`	Unique identifier for the solo staking pool or instance on StakeWise v1. Hex-encoded 32-byte hash value that groups validator registrations belonging to the same solo staking arrangement.
`in_publicKey`	`STRING`	BLS (Boneh-Lynn-Shacham) public key of the registered Ethereum validator. Hex-encoded 96-character string used to identify the validator on the beacon chain.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_operator`	`STRING`	Address authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_price	in_soloId	log_index	in_operator	block_number	in_publicKey	block_timestamp	transaction_hash
0xeadcba8bf9aca93f627f31fb05470f5a0686ceca	false	10000000000000000000	0xe975d84514d216f6672ce34392a02ce1e746fd6fd71a01a12cc1e03dd7dc166e	41	0x5fc60576b92c5ce5c341c43e3b2866eb9e0cddd1	13406130	0x92d5413962a74e93b2ee1ec61c475cfd12408e1984f8a6cb8dbe3eec777dec40ac755d04c71071bed8fc38ade0b91c73	2021-10-12T21:40:40.000Z	0x4c6efc978ab56c8fc14aebefcd4c890d23df7be644d29b0afb402c9b545659f1
0xeadcba8bf9aca93f627f31fb05470f5a0686ceca	false	10000000000000000000	0x43194d571382a0ad44272b857516c47ce2a962b3c8aea89e9b4af81fbf5b6369	224	0x5fc60576b92c5ce5c341c43e3b2866eb9e0cddd1	12686779	0x98c3f74768bee3591fc362a1ad93a204272a6272dc7390f7d791e7c666669d27ce9b80c88dab44f4a830923e517ba6d2	2021-06-22T22:36:08.000Z	0xf20498b2f6c8c0f2b578f2c44599a3c6d6a85c899c1e0698c9103f5d761847f2
0xeadcba8bf9aca93f627f31fb05470f5a0686ceca	false	10000000000000000000	0xf5f832a6326511fc88f7b26bc843ae95118c7b1fa494da8dae89ed99ab8a213b	583	0x5fc60576b92c5ce5c341c43e3b2866eb9e0cddd1	12967495	0xb454669069e96df1036c22633cdf15189cf3cf0a666152318ffa1473fe98bdf80a0a89df8a3181778a4568cf2b4a1786	2021-08-05T21:50:49.000Z	0xf4b884d69505bfafc2e2cb7b7767d0d82bcb495c261b01c939ba19dfa42d68b4

Example Query

Query with partition filter

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

VestingEscrowFactory_VestingEscrowCreated_event

Vesting escrow creation events from StakeWise V1 on Ethereum, recording token vesting schedules with beneficiary addresses, total amounts, cliff periods, and start/end timestamps. Used to track SWISE token distribution and team/investor unlock schedules.

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_admin`	`STRING`	Address of the administrator or privileged account that initiated or authorized the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_escrow`	`STRING`	Contract address of the newly deployed vesting escrow contract created by the factory. This contract will hold and manage the vesting schedule for the specified token and beneficiary.
`in_totalAmount`	`STRING`	Total amount involved in the transaction or operation. String-encoded integer representing the amount in the token’s smallest unit.
`in_startTime`	`STRING`	Start timestamp for the listing, auction, program, or vesting period. Unix timestamp in seconds.
`in_endTime`	`STRING`	End timestamp for the listing, auction, program, or vesting period. Unix timestamp in seconds.
`in_cliffLength`	`STRING`	Duration of the cliff period in seconds before vesting begins for the escrow contract. Typically zero in StakeWise vesting schedules, meaning tokens start vesting immediately at the start time.

Sample Data

address	removed	in_admin	in_token	in_escrow	log_index	in_endTime	block_number	in_recipient	in_startTime	in_beneficiary	in_totalAmount	block_timestamp	transaction_hash
0x7b910cc3d4b42feff056218bd56d7700e4ea7dd5	false	0xf91aa4a655b6f43243ed4c2853f3508314daa2ab	0x48c3399719b582dd63eb5aadf12a40b4c3f52fa2	0xfc1c2379e7f6d708dd3ee66bc18d3e53faf0fdbd	146	3376598400	17136350	0x7ef716f6a58a0e53994ab09afd749b89b93b7fb7	1672531200	0x7ef716f6a58a0e53994ab09afd749b89b93b7fb7	1000000000000000000000000	2023-04-27T08:31:35.000Z	0x199c76a264c9d2e1b9c5f5dcbd6c67aa8b90739f1d27971b945fbb9c8a98f5ec
0x7b910cc3d4b42feff056218bd56d7700e4ea7dd5	false	0xf91aa4a655b6f43243ed4c2853f3508314daa2ab	0x48c3399719b582dd63eb5aadf12a40b4c3f52fa2	0x6effd72ac6d50651a610a289ee2f92d9ce88517a	84	1735689600	17136430	0x7ef716f6a58a0e53994ab09afd749b89b93b7fb7	1672531200	0x7ef716f6a58a0e53994ab09afd749b89b93b7fb7	1000000000000000000000000	2023-04-27T08:48:11.000Z	0xa105c6b1d6f5cdd89bdff23ea683ee4dc64c43bd74c6703767dc9220299cc1e1
0x7b910cc3d4b42feff056218bd56d7700e4ea7dd5	false	0x144a98cb1cdbb23610501fe6108858d9b7d24934	0x48c3399719b582dd63eb5aadf12a40b4c3f52fa2	0x8c3463d3cfd159ef960c09c7e19c1981be4df60d	45	1743465600	12297632	0xb0f43ab7a9c1bb461be8242d2c7de0a21daf8377	1633046400	0xb0f43ab7a9c1bb461be8242d2c7de0a21daf8377	43000000000000000000000000	2021-04-23T16:44:12.000Z	0xf5f123dee2ddc78f5bcc4d1fe333776dd2855bc39db4aa03faf64d98f496d3b8

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

RewardEthTokenV2_RewardsUpdated_event

Solos_DepositAdded_event

Solos_ValidatorRegistered_event

VestingEscrowFactory_VestingEscrowCreated_event

​Tables

​RewardEthTokenV2_RewardsUpdated_event

​Solos_DepositAdded_event

​Solos_ValidatorRegistered_event

​VestingEscrowFactory_VestingEscrowCreated_event

Tables

RewardEthTokenV2_RewardsUpdated_event

Solos_DepositAdded_event

Solos_ValidatorRegistered_event

VestingEscrowFactory_VestingEscrowCreated_event