stakestone_v1_ethereum

Tables

AssetVault_withdraw_function

Withdrawal function calls from StakeStone’s AssetVault contract on Ethereum, capturing user withdrawals with recipient addresses and token amounts in wei. Used for tracking vault outflows and user redemption 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.
`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.
`in__to`	`STRING`	Destination address for 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

gas	in__to	status	gas_used	signature	in__amount	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
495629	0x22a956c4755d8c4294b358dc346e74250e175622	true	7738	0xf3fef3a3	66014746701318206456	0x9485711f11b17f73f2ccc8561bcae05bdc7e9ad9	20963906	0xa62f9c5af106feee069f38de51098d9d81b90572	0,2,0,8	2024-10-14T12:48:59.000Z	0xebe0a6d5fbf96a5fec7717c83a24196d6cc8321be73b78e4f7eadf54d37c814c
371654	0xe86142af1321eaac4270422081c1eda31eecff0c	true	9738	0xf3fef3a3	3559476385389825439	0x9485711f11b17f73f2ccc8561bcae05bdc7e9ad9	20963593	0xa62f9c5af106feee069f38de51098d9d81b90572	2,4	2024-10-14T11:45:35.000Z	0xfa1578afffe3e86a48af934cf7d43516dd3771a8ed0639f19faeb16780343c15
11884	0x8ac1651162983b6369cdbd86ed345eb3aff18a98	true	9683	0xf3fef3a3	150601374962748819	0x9485711f11b17f73f2ccc8561bcae05bdc7e9ad9	20966273	0xa62f9c5af106feee069f38de51098d9d81b90572	4	2024-10-14T20:44:47.000Z	0xcc6a1ec2d765e2a0882b47ac7eddb232dd94b15e1dc92f7e77ed44e3990fdfc3

Example Query

Query with partition filter

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

StoneVault_Deposit_event

Deposit events from StakeStone’s liquid staking vault on Ethereum, tracking user stakes with deposit amounts, minted receipt tokens, and round identifiers. Used for analyzing vault inflows, user participation patterns, and stake distribution across deposit rounds.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_mint`	`STRING`	Address of the token mint or contract being created, deposited, or transferred. Base58-encoded Solana public key or hex-encoded EVM address.
`in_round`	`STRING`	Sequential identifier for vault or auction rounds. Numeric string representing the round number in the protocol’s lifecycle.

Sample Data

address	in_mint	removed	in_round	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0xa62f9c5af106feee069f38de51098d9d81b90572	2000000000000000000	false	1	2000000000000000000	417	0xc061594b5e90220fb65b644774ec7a7d73fd7a7d	18212566	2023-09-25T11:41:11.000Z	0xe1e99e34438d0e4202f6b6d3f65bf6ae9e29c4f56d4e29b02103d71994d069f9
0xa62f9c5af106feee069f38de51098d9d81b90572	150000000000000000	false	1	150000000000000000	362	0xd46ae63ee79f409397f6cdf7eaf6145e63690e08	18214613	2023-09-25T18:33:59.000Z	0xb776bb7dabb6b89394caf2bb70e843aa726d72cfb45e3aa996ceed5b5fd5ea99
0xa62f9c5af106feee069f38de51098d9d81b90572	100000000000000000	false	1	100000000000000000	248	0xc1364ad857462e1b60609d9e56b5e24c5c21a312	18211511	2023-09-25T08:08:23.000Z	0x2be84b946751128f8e28fba1c61c23e76b19d3005c853473d25a5ac915cbdc12

Example Query

Query with partition filter

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

StoneVault_RollToNextRound_event

StakeStone vault round transition events on Ethereum recording when the StoneVault contract advances to a new operational round with updated share prices and vault balances. Tracks sequential round progressions with incoming vault amounts and corresponding share price valuations for analyzing StakeStone’s liquid staking vault performance 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_round`	`STRING`	Sequential identifier for vault or auction rounds. Numeric string representing the round number in the protocol’s lifecycle.
`in_vaultIn`	`STRING`	Amount of tokens deposited into the vault during this round transition, denominated in the smallest unit (wei). This value represents incoming deposits being rolled forward into the new round period.
`in_vaultOut`	`STRING`	Amount of vault tokens withdrawn or moved out during the round transition, denominated in wei. Typically zero in StakeStone vault rounds, indicating no outflows during rollover events.
`in_sharePrice`	`STRING`	Price per vault share denominated in wei (18 decimals) at the time of the round transition. Values typically hover around 1e18 (1.0) with small variations indicating accrued yield or losses.

Sample Data

address	removed	in_round	log_index	in_vaultIn	block_number	in_sharePrice	block_timestamp	transaction_hash
0xa62f9c5af106feee069f38de51098d9d81b90572	false	9	18	61573163747722275300729	18897115	1003002257182023487	2023-12-30T08:20:59.000Z	0x171fba9e69f7c1a5d07aadcf47191ba329ef89cc669519beb02b701a4aa0b92f
0xa62f9c5af106feee069f38de51098d9d81b90572	false	1	278	1000000000000000	18204459	1000000000000000000	2023-09-24T08:27:11.000Z	0xaa51e38dd3614aa1218e550472497108f044b53435c5077cdf1bdea5b8b6b738
0xa62f9c5af106feee069f38de51098d9d81b90572	false	6	14	30878385532305773359493	18819317	1002113862671915492	2023-12-19T10:09:59.000Z	0xdd791fcf7240ec1fba1ca36712e5103386cc7411cfdfa4c2d4b8951ba5eacbc2

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AssetVault_withdraw_function

StoneVault_Deposit_event

StoneVault_RollToNextRound_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AssetVault_withdraw_function

​StoneVault_Deposit_event

​StoneVault_RollToNextRound_event

Tables

AssetVault_withdraw_function

StoneVault_Deposit_event

StoneVault_RollToNextRound_event