Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_periodRewardsSTRINGTotal 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_totalRewardsSTRINGTotal 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_rewardPerTokenSTRINGAccumulated 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_distributorRewardSTRINGTotal 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_protocolRewardSTRINGStaking 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.
addressremovedlog_indexblock_numberblock_timestampin_totalRewardsin_periodRewardstransaction_hashin_protocolRewardin_rewardPerTokenin_distributorReward
0x20bc832ca081b91433ff6c17f85701b6e92486c5false214164195992023-01-16T13:18:35.000Z4461455198120758348275111504221652326720410x883ea1751d7d29e37b555654fb2b954b327d69eb7ad3b3098e47863cd417e5f31115042216523267204997086302724183884896942907865288015
0x20bc832ca081b91433ff6c17f85701b6e92486c5false273151773162022-07-20T04:11:48.000Z258702811908400000000074751235060000000000x20c840a46467022d597f29b7a1dc0f49baf314a373a1e0342feb5c7d0db22f87747512350600000000741322778031019322999825396020068828
0x20bc832ca081b91433ff6c17f85701b6e92486c5false163140190942022-01-16T21:53:40.000Z137603708367700000000074118189170000000000x4f261b6ba1d8ae626d6e2d8ef2d1991f46544e247e6035edabc7fb8ee5dc19e70528494735070849212771993196037997239
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_soloIdSTRINGUnique 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_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_withdrawalCredentialsSTRINGEthereum 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.
addressremovedin_amountin_senderin_soloIdlog_indexblock_numberblock_timestamptransaction_hashin_withdrawalCredentials
0xeadcba8bf9aca93f627f31fb05470f5a0686cecafalse320000000000000000000xeb715cac7b8ddfbfa89dc7efff5d7a80b49bf33b0xf5f832a6326511fc88f7b26bc843ae95118c7b1fa494da8dae89ed99ab8a213b282129649342021-08-05T12:21:38.000Z0xac3c8558e74981188942e6aafcfce173430497e5a22fe6505f30c57f205cd6a50x00d82aba0c912af4835003f2d4db0f300b2f0a073d4b84eb294163cf8315b13f
0xeadcba8bf9aca93f627f31fb05470f5a0686cecafalse3200000000000000000000xeb715cac7b8ddfbfa89dc7efff5d7a80b49bf33b0xf5f832a6326511fc88f7b26bc843ae95118c7b1fa494da8dae89ed99ab8a213b511129672442021-08-05T20:58:01.000Z0xf8566c51069e10a44694b2c77f1e6f9c8148fa7aec355a88e4c574ecc545c9e90x00d82aba0c912af4835003f2d4db0f300b2f0a073d4b84eb294163cf8315b13f
0xeadcba8bf9aca93f627f31fb05470f5a0686cecafalse320000000000000000000x49428f4f098f4d34f4b0208f932a4e5c95baf6f90x1136f20e98586e0bbc20143562619c1c557a1ce6ddfe825542722c77e3bd3e8c447133022712021-09-26T15:44:03.000Z0x3b6e92e5736276ab38b2043b9fcf5b69c0ea9ee93dcf9ef8c48246bdeb5aa7aa0x001583c22e49a5bbc048c85587ec0bf0cc503185b800341af456758fdf9ea01d
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_soloIdSTRINGUnique 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_publicKeySTRINGBLS (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_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
in_operatorSTRINGAddress authorized to execute the operation on behalf of the token owner. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_pricein_soloIdlog_indexin_operatorblock_numberin_publicKeyblock_timestamptransaction_hash
0xeadcba8bf9aca93f627f31fb05470f5a0686cecafalse100000000000000000000xe975d84514d216f6672ce34392a02ce1e746fd6fd71a01a12cc1e03dd7dc166e410x5fc60576b92c5ce5c341c43e3b2866eb9e0cddd1134061300x92d5413962a74e93b2ee1ec61c475cfd12408e1984f8a6cb8dbe3eec777dec40ac755d04c71071bed8fc38ade0b91c732021-10-12T21:40:40.000Z0x4c6efc978ab56c8fc14aebefcd4c890d23df7be644d29b0afb402c9b545659f1
0xeadcba8bf9aca93f627f31fb05470f5a0686cecafalse100000000000000000000x43194d571382a0ad44272b857516c47ce2a962b3c8aea89e9b4af81fbf5b63692240x5fc60576b92c5ce5c341c43e3b2866eb9e0cddd1126867790x98c3f74768bee3591fc362a1ad93a204272a6272dc7390f7d791e7c666669d27ce9b80c88dab44f4a830923e517ba6d22021-06-22T22:36:08.000Z0xf20498b2f6c8c0f2b578f2c44599a3c6d6a85c899c1e0698c9103f5d761847f2
0xeadcba8bf9aca93f627f31fb05470f5a0686cecafalse100000000000000000000xf5f832a6326511fc88f7b26bc843ae95118c7b1fa494da8dae89ed99ab8a213b5830x5fc60576b92c5ce5c341c43e3b2866eb9e0cddd1129674950xb454669069e96df1036c22633cdf15189cf3cf0a666152318ffa1473fe98bdf80a0a89df8a3181778a4568cf2b4a17862021-08-05T21:50:49.000Z0xf4b884d69505bfafc2e2cb7b7767d0d82bcb495c261b01c939ba19dfa42d68b4
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_adminSTRINGAddress of the administrator or privileged account that initiated or authorized the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_beneficiarySTRINGAddress that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_escrowSTRINGContract 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_totalAmountSTRINGTotal amount involved in the transaction or operation. String-encoded integer representing the amount in the token’s smallest unit.
in_startTimeSTRINGStart timestamp for the listing, auction, program, or vesting period. Unix timestamp in seconds.
in_endTimeSTRINGEnd timestamp for the listing, auction, program, or vesting period. Unix timestamp in seconds.
in_cliffLengthSTRINGDuration 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.
addressremovedin_adminin_tokenin_escrowlog_indexin_endTimeblock_numberin_recipientin_startTimein_beneficiaryin_cliffLengthin_totalAmountblock_timestamptransaction_hash
0x7b910cc3d4b42feff056218bd56d7700e4ea7dd5false0xf91aa4a655b6f43243ed4c2853f3508314daa2ab0x48c3399719b582dd63eb5aadf12a40b4c3f52fa20xfc1c2379e7f6d708dd3ee66bc18d3e53faf0fdbd1463376598400171363500x7ef716f6a58a0e53994ab09afd749b89b93b7fb716725312000x7ef716f6a58a0e53994ab09afd749b89b93b7fb7010000000000000000000000002023-04-27T08:31:35.000Z0x199c76a264c9d2e1b9c5f5dcbd6c67aa8b90739f1d27971b945fbb9c8a98f5ec
0x7b910cc3d4b42feff056218bd56d7700e4ea7dd5false0xf91aa4a655b6f43243ed4c2853f3508314daa2ab0x48c3399719b582dd63eb5aadf12a40b4c3f52fa20x6effd72ac6d50651a610a289ee2f92d9ce88517a841735689600171364300x7ef716f6a58a0e53994ab09afd749b89b93b7fb716725312000x7ef716f6a58a0e53994ab09afd749b89b93b7fb7010000000000000000000000002023-04-27T08:48:11.000Z0xa105c6b1d6f5cdd89bdff23ea683ee4dc64c43bd74c6703767dc9220299cc1e1
0x7b910cc3d4b42feff056218bd56d7700e4ea7dd5false0x144a98cb1cdbb23610501fe6108858d9b7d249340x48c3399719b582dd63eb5aadf12a40b4c3f52fa20x8c3463d3cfd159ef960c09c7e19c1981be4df60d451743465600122976320xb0f43ab7a9c1bb461be8242d2c7de0a21daf837716330464000xb0f43ab7a9c1bb461be8242d2c7de0a21daf83770430000000000000000000000002021-04-23T16:44:12.000Z0xf5f123dee2ddc78f5bcc4d1fe333776dd2855bc39db4aa03faf64d98f496d3b8
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