> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# stakestone_v1_ethereum
> Tables in tt-contracts.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.
| 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). |
| gas | value | in\_\_to | status | gas\_used | signature | in\_\_amount | to\_address | block\_number | from\_address | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------------------------------------------ | ------ | --------- | ---------- | -------------------- | ------------------------------------------ | ------------- | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 495629 | 0 | 0x22a956c4755d8c4294b358dc346e74250e175622 | true | 7738 | 0xf3fef3a3 | 66014746701318206456 | 0x9485711f11b17f73f2ccc8561bcae05bdc7e9ad9 | 20963906 | 0xa62f9c5af106feee069f38de51098d9d81b90572 | 0,2,0,8 | 2024-10-14T12:48:59.000Z | 0xebe0a6d5fbf96a5fec7717c83a24196d6cc8321be73b78e4f7eadf54d37c814c |
| 371654 | 0 | 0xe86142af1321eaac4270422081c1eda31eecff0c | true | 9738 | 0xf3fef3a3 | 3559476385389825439 | 0x9485711f11b17f73f2ccc8561bcae05bdc7e9ad9 | 20963593 | 0xa62f9c5af106feee069f38de51098d9d81b90572 | 2,4 | 2024-10-14T11:45:35.000Z | 0xfa1578afffe3e86a48af934cf7d43516dd3771a8ed0639f19faeb16780343c15 |
| 11884 | 0 | 0x8ac1651162983b6369cdbd86ed345eb3aff18a98 | true | 9683 | 0xf3fef3a3 | 150601374962748819 | 0x9485711f11b17f73f2ccc8561bcae05bdc7e9ad9 | 20966273 | 0xa62f9c5af106feee069f38de51098d9d81b90572 | 4 | 2024-10-14T20:44:47.000Z | 0xcc6a1ec2d765e2a0882b47ac7eddb232dd94b15e1dc92f7e77ed44e3990fdfc3 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| address | removed | in\_round | log\_index | in\_vaultIn | in\_vaultOut | block\_number | in\_sharePrice | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | --------- | ---------- | ----------------------- | ------------ | ------------- | ------------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xa62f9c5af106feee069f38de51098d9d81b90572 | false | 9 | 18 | 61573163747722275300729 | 0 | 18897115 | 1003002257182023487 | 2023-12-30T08:20:59.000Z | 0x171fba9e69f7c1a5d07aadcf47191ba329ef89cc669519beb02b701a4aa0b92f |
| 0xa62f9c5af106feee069f38de51098d9d81b90572 | false | 1 | 278 | 1000000000000000 | 0 | 18204459 | 1000000000000000000 | 2023-09-24T08:27:11.000Z | 0xaa51e38dd3614aa1218e550472497108f044b53435c5077cdf1bdea5b8b6b738 |
| 0xa62f9c5af106feee069f38de51098d9d81b90572 | false | 6 | 14 | 30878385532305773359493 | 0 | 18819317 | 1002113862671915492 | 2023-12-19T10:09:59.000Z | 0xdd791fcf7240ec1fba1ca36712e5103386cc7411cfdfa4c2d4b8951ba5eacbc2 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.stakestone_v1_ethereum.StoneVault_RollToNextRound_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***