stakewise_v3_ethereum

Tables

EthGenesisVault_Deposited_event

ETH deposit events into StakeWise V3 Genesis Vault on Ethereum, recording deposited assets (wei), minted shares, caller/receiver addresses, and optional referrer. Used for tracking vault deposit activity and analyzing the ETH-to-share conversion rate 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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. 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.
`in_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_assets	in_caller	in_shares	log_index	in_receiver	in_referrer	block_number	block_timestamp	transaction_hash
0xac0f906e433d58fa868f936e8a43230473652885	false	3679110000000000000	0xf2cd8a3ce157fd375525226919e1009c527b5b47	3662740609409765313	173	0xf2cd8a3ce157fd375525226919e1009c527b5b47	0x0000000000000000000000000000000000000000	18984719	2024-01-11T15:57:35.000Z	0x2283da24e5d1dd6acdd77bb5f4022dc3ebb96c1dda070098de985c59bb0aa64c
0xac0f906e433d58fa868f936e8a43230473652885	false	4900000000000000000	0xc3166d45c6d48be8a8a05a6653d780ea3e399315	4878424114728960852	104	0xc3166d45c6d48be8a8a05a6653d780ea3e399315	0x0000000000000000000000000000000000000000	18982411	2024-01-11T08:10:35.000Z	0x300cd730aea4c4fd7e4cbbab0555ff2642662f76beb0b3a0d2fbc6ef1a50ff84
0xac0f906e433d58fa868f936e8a43230473652885	false	25000000000000000	0x14d4cf2091cb98570fc32dd95f7097b267e15982	24889918952698780	317	0x14d4cf2091cb98570fc32dd95f7097b267e15982	0x0000000000000000000000000000000000000000	18980949	2024-01-11T03:14:47.000Z	0xb0848a420af07c32c054decd40bf72ac4324d16ee09d49eedf8e8f863c985bef

Example Query

Query with partition filter

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

EthGenesisVault_ExitQueueEntered_event

Exit queue entry events from StakeWise V3 Genesis Vault on Ethereum, recording when stakers request withdrawals with their vault share amounts and assigned position tickets. Used for tracking withdrawal demand and queue positions for unstaking ETH.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_positionTicket`	`STRING`	Unique position identifier assigned to the staker when entering the exit queue. Numeric string representing the queue position ticket for tracking withdrawal order in the StakeWise V3 vault.
`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_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash	in_positionTicket
0xac0f906e433d58fa868f936e8a43230473652885	false	0xe5c193042e4ab4408396317481c08076942aee87	1054787810219747522	306	0xe5c193042e4ab4408396317481c08076942aee87	18783252	2023-12-14T08:40:35.000Z	0xc9f1af1799e58d11d94e56b3b0f1cb78e06af075938d28a112733d39c08f2469	17308717357308860489899
0xac0f906e433d58fa868f936e8a43230473652885	false	0xbbbbbbbd828a167a058ecc1c429fc563c40a7acd	2276478516155051963	289	0xbbbbbbbd828a167a058ecc1c429fc563c40a7acd	18785010	2023-12-14T14:36:23.000Z	0x5a996818956872c81c6ba1a3c009bfc77250c4c36f20213a5d4ca4ac344f46a0	17315862019357102100996
0xac0f906e433d58fa868f936e8a43230473652885	false	0x53d1987434de7ff987121eadeddcbcd53dc15e45	2209389983169441354	138	0x53d1987434de7ff987121eadeddcbcd53dc15e45	18780912	2023-12-14T00:47:59.000Z	0x97451a67530594036c9afff27e836868c098a8163664e124ac0a31d363b2ec47	17306507967325691048545

Example Query

Query with partition filter

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

EthGenesisVault_Migrated_event

Migration events from StakeWise V3’s Genesis Vault on Ethereum, recording transfers of staked ETH positions with asset amounts, vault share allocations, and recipient addresses. Used for tracking vault migration flows and analyzing the conversion between ETH assets and vault shares during StakeWise protocol upgrades.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. 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_assets	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0xac0f906e433d58fa868f936e8a43230473652885	false	2955792996897327068	2954546542716161742	256	0xfa9cd1f30dc8462a930b9f13d47a0c96ef58b6b3	18690090	2023-12-01T07:30:59.000Z	0x94bc61102621c3e7ac68945e6cd4aaead8a7611ee0b10432efc99ce3762021bb
0xac0f906e433d58fa868f936e8a43230473652885	false	5220996423372338985	5218794735761402502	258	0x5772981b6df6c4c8abc1dcfe3d8d0557812f181d	18690678	2023-12-01T09:29:35.000Z	0x13e06fc06202700cc9707da37b8614742a4f59299aa5141477f2e44cf101d59e
0xac0f906e433d58fa868f936e8a43230473652885	false	2009037611145394522	2008190402517063923	268	0x731b7fac1d1d6fac048365876a70e5247cd0c984	18690667	2023-12-01T09:27:23.000Z	0x61d465a21276c413c1abb3eede12e4901a0459650d68b76c5da455b58b2f96d0

Example Query

Query with partition filter

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

EthVault_Deposited_event

ETH deposit events from StakeWise V3 vaults on Ethereum, recording staked ETH amounts and vault shares issued to depositors. Used for tracking vault deposits, share exchange rates, and user staking activity across different vault addresses.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. 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.
`in_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_assets	in_caller	in_shares	log_index	in_receiver	in_referrer	block_number	block_timestamp	transaction_hash
0x302be829c61c287787030888bbcf11115ecd5773	false	6421305078370731	0xbf66ae125f81b3606ccc8fd5334a6fbfef33cf0d	6411263203770549	187	0xbf66ae125f81b3606ccc8fd5334a6fbfef33cf0d	0x0000000000000000000000000000000000000000	18879299	2023-12-27T20:14:23.000Z	0x989c6813739169e55973e7c72b82e12e0cb1c2c8347d7004bda54d5b61d4274c
0x3f2f7424074bac9337ddca38e83e1518436e0ed0	false	3000000000000000000	0xbe5a45757883de0e230c3df1c2ecb0446df2f485	2992248614997500941	270	0xbe5a45757883de0e230c3df1c2ecb0446df2f485	0x0000000000000000000000000000000000000000	18875897	2023-12-27T08:45:35.000Z	0xce123ffb3010623dc88881644b81610ae7a0a2883eae458125d819c4c6974f92
0x3f2f7424074bac9337ddca38e83e1518436e0ed0	false	240000000000000000	0x19bfaac96796139457b474ac085fc841032c93b4	239379889199800076	207	0x19bfaac96796139457b474ac085fc841032c93b4	0x0000000000000000000000000000000000000000	18874154	2023-12-27T02:53:23.000Z	0xb9d7c61ec480a26e1106c1d225aaaa63e95508e08cc40049eff48b88d31f21ee

Example Query

Query with partition filter

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

EthVault_ExitQueueEntered_event

StakeWise V3 Ethereum vault exit queue entry events tracking when stakers request to withdraw their shares, recording owner addresses, share amounts, and position tickets. Used for analyzing withdrawal demand patterns and tracking exit queue positions across different vaults.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_positionTicket`	`STRING`	Position ticket identifier assigned to track this exit request in the vault’s exit queue. Large integer value that serves as a unique reference for the withdrawal position.
`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_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash	in_positionTicket
0x8a93a876912c9f03f88bc9114847cf5b63c89f56	false	0x89301133da161e851325e257d1bfdf7dafdc7d15	199763386237607268	247	0x89301133da161e851325e257d1bfdf7dafdc7d15	18771965	2023-12-12T18:43:35.000Z	0xa146995c4f4b7900a041a4d83a1dd7c752b18563728e1f23efd33edd11d5b23e	99999999999999999
0x64f2907f92631619ed7ea510982835f9e1024767	false	0x34aeebd1f93dd050f7bf188e581a7a44414ff47c	3890464326333222916	242	0x34aeebd1f93dd050f7bf188e581a7a44414ff47c	18974711	2024-01-10T06:18:47.000Z	0x0d60be44e7b9350b35b2886d10c9ee3915cd08350a77340d5cb52538b1e688d1	54866528031392703872
0x64f2907f92631619ed7ea510982835f9e1024767	false	0x34aeebd1f93dd050f7bf188e581a7a44414ff47c	4489159524515490967	284	0x34aeebd1f93dd050f7bf188e581a7a44414ff47c	18971064	2024-01-09T18:02:59.000Z	0x6154b9eea366133b8785104ee65167ee9bef73fa23f88c3f1de92e85061d137a	50377368506877212905

Example Query

Query with partition filter

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

EthVaultFactory_VaultCreated_event

New vault deployment events from StakeWise V3 ETH Vault Factory on Ethereum, capturing vault contract addresses, admin addresses, MEV (Maximal Extractable Value) escrow configurations, and initialization parameters for tracking liquid staking vault creation and governance setup.

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_vault`	`STRING`	Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.
`in_ownMevEscrow`	`STRING`	Contract address of the vault’s dedicated MEV (Maximal Extractable Value) escrow contract, if configured. Zero address (0x000…000) indicates the vault uses a shared MEV escrow instead of its own.
`in_params`	`STRING`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.

Sample Data

address	removed	in_admin	in_vault	in_params	log_index	block_number	block_timestamp	in_ownMevEscrow	transaction_hash
0xdada5a8e3703b1e3ea2bae5ab704627eb2659fcc	false	0x842e9bd5ae00b0cc54173391333049c39e8b5a54	0x256c83c37aa88bc0fd2057ce54743255e8e55ba6	0x0000000000000000000000000000000000000000000000000000000000000020ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000000001f40000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000003b6261666b72656963737563373664693779657672787a7370706964706f62627178787373766a75767a70646d756b74627871687834626d656876650000000000	361	18619466	2023-11-21T10:12:59.000Z	0x0000000000000000000000000000000000000000	0x22f1b4f69fc6bdf8e4448792cef3861ea56a5b3c285bdd52638e7eb2d6403056
0xdada5a8e3703b1e3ea2bae5ab704627eb2659fcc	false	0xb444bd85414fe979cd723423908d303ccaefdb5f	0xe2d8f982708ce1e3814c8986cbab624ca926288a	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000003635c9adc5dea00000000000000000000000000000000000000000000000000000000000000000001900000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000003b6261666b726569653376646c766e6e666367787233336c746c667661326e71373776717834736c6b617864336a756f69326f76776f6b73727634340000000000	67	18619061	2023-11-21T08:51:23.000Z	0x0000000000000000000000000000000000000000	0x27ce3d9de1a3914764406f9c4d87e97617f4a9c3836fa7ea9e70a35884c7ec92
0xdada5a8e3703b1e3ea2bae5ab704627eb2659fcc	false	0xe7db0d2384587956ef9d47304e96236022cce3af	0x8216e50b1dd76faeb1ff4cafaba6790ea71910df	0x0000000000000000000000000000000000000000000000000000000000000020ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000000003e80000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000003b6261666b726569663265736c78757a6d72696470667563616c7077776e79676c72686f686b64367336676777326f636477646d6d733667657833690000000000	89	18616425	2023-11-20T23:58:59.000Z	0xa7f5646b8133a1651ccd453480269e25724d5955	0x0854a39fe249e15d598a8cb5a161c8ad649c6fefd70551e06c8939cc47af2de0

Example Query

Query with partition filter

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

EthVaultTest_Deposited_event

ETH deposit events from StakeWise V3 vaults on Ethereum, capturing when users stake ETH and receive vault shares in return. Tracks deposit amounts, share conversions, caller/receiver addresses, and optional referrers for analyzing staking flows and vault 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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. 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.
`in_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_assets	in_caller	in_shares	log_index	in_receiver	in_referrer	block_number	block_timestamp	transaction_hash
0x089a97a8bc0c0f016f89f9cf42181ff06afb2daf	false	5000000000000000000	0xf506187dc3f5c4c9c91cff1d1ad7eaf9e305242f	5000000000000000000	128	0xf506187dc3f5c4c9c91cff1d1ad7eaf9e305242f	0x0000000000000000000000000000000000000000	18833279	2023-12-21T09:14:23.000Z	0xb643e99ebd24c161fb3dc8af274ea66e61dc859236e0d8b39c799b14f12e4e99
0x3f2f7424074bac9337ddca38e83e1518436e0ed0	false	580000000000000000	0x9c82b53e54a58d60de384761504984d54bfdbdd1	578658346863199665	195	0x9c82b53e54a58d60de384761504984d54bfdbdd1	0x0000000000000000000000000000000000000000	18834011	2023-12-21T11:42:23.000Z	0xaf9e9747a69f10b29cd01133f8d4bbee89fef5e6e92b00d0c38e4a86cdf54dc7
0x3f2f7424074bac9337ddca38e83e1518436e0ed0	false	100000000000000000	0x5eda2dc136986fc88d4df5696bc464f96a20268a	99771970177148868	118	0x5eda2dc136986fc88d4df5696bc464f96a20268a	0x0000000000000000000000000000000000000000	18833128	2023-12-21T08:43:47.000Z	0xdd92ca5d11ac4c280b89510691dcfa2b1968861e161beb4989f835152b8a6af2

Example Query

Query with partition filter

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

EthVaultTest_ExitQueueEntered_event

Exit queue entry events from StakeWise V3 Ethereum vaults tracking withdrawal requests with vault shares, owner addresses, and position tickets. Used for analyzing withdrawal demand patterns and liquidity exit flows from liquid staking vaults.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_positionTicket`	`STRING`	Unique identifier for the position in the exit queue, represented as a numeric string. Used to track and reference specific withdrawal requests within the StakeWise V3 vault’s exit queue 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_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash	in_positionTicket
0x5610297eb32542b8f13378fe7d783dcb1ac3b1a1	false	0x0e8ea44d0b2a00c33b94b2bf426fb20a0c8593be	2235865368702748163	364	0x0e8ea44d0b2a00c33b94b2bf426fb20a0c8593be	18872563	2023-12-26T21:32:35.000Z	0x58763b65dade8c9fe393f3823d03a84c24a59af69c0678ea4c2c54962fd4ae57	13389465911455636089
0x5610297eb32542b8f13378fe7d783dcb1ac3b1a1	false	0x1abc03835c3925fb20ca79e7ffbb50f8540564f7	4490017750182411000	120	0x1abc03835c3925fb20ca79e7ffbb50f8540564f7	18785610	2023-12-14T16:36:59.000Z	0x0924668809789fc4bf3ae600fb84ffedc8f7cc788b14e96010449086287403be	1103048882618656158
0x5610297eb32542b8f13378fe7d783dcb1ac3b1a1	false	0x123354e633e563265f0599b4244f9b017c433db8	269293071898075055	290	0x123354e633e563265f0599b4244f9b017c433db8	18800276	2023-12-16T18:02:59.000Z	0x93fbca64ec5a859d7b5f2b0cbd8414bf52928b9d1a985b5cc52799a483126432	5593066632801067158

Example Query

Query with partition filter

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

OsTokenVaultController_StateUpdated_event

StakeWise V3 vault controller state update events on Ethereum tracking accumulated profit, treasury assets, and treasury shares in wei units for analyzing protocol revenue accrual and treasury position changes.

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_profitAccrued`	`STRING`	Accumulated profit denominated in osToken base units (wei) since the vault controller’s last state update. Values represent 18-decimal precision amounts tracking StakeWise V3 vault earnings over time.
`in_treasuryShares`	`STRING`	Number of vault shares held by the StakeWise V3 treasury at the time of the state update, denominated in the vault’s smallest unit (wei-equivalent). This value tracks the treasury’s ownership stake in the vault and typically increases alongside treasury assets.
`in_treasuryAssets`	`STRING`	Total assets held in the vault’s treasury, denominated in the smallest unit of the underlying token (wei for ETH). This value tracks the treasury’s asset balance at the time of each state update event.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_profitAccrued	transaction_hash	in_treasuryAssets	in_treasuryShares
0x2a261e60fb14586b474c208b1b7ac6d0f5000306	false	113	18838403	2023-12-22T02:26:11.000Z	180502977863448114	0xcfdcc059f9cbe01e0b4d0fb00ef407f7e19435a93bb3d2e07e3debb8db026284	9025148893172405	9000420837603714
0x2a261e60fb14586b474c208b1b7ac6d0f5000306	false	613	18840336	2023-12-22T08:56:35.000Z	252815181828687399	0x4c61f93a746e1c95a83fb082e255d4bc6fd2ace696b5027a189a7d985a1f9138	12640759091434369	12605849023126400
0x2a261e60fb14586b474c208b1b7ac6d0f5000306	false	111	18839613	2023-12-22T06:30:23.000Z	422264456776061933	0x0057781b8c560108a778fa2bff1fde8892e8988daadf68f6c3f8b37a46590d00	21113222838803096	21055086683622956

Example Query

Query with partition filter

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

VaultsRegistry_VaultAdded_event

Vault registration events from StakeWise V3 protocol on Ethereum, capturing when new staking vaults are added to the registry with vault addresses and caller information. Used for tracking vault deployment activity and analyzing 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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_vault`	`STRING`	Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_vault	in_caller	log_index	block_number	block_timestamp	transaction_hash
0x3a0008a588772446f6e656133c2d5029cc4fc20e	false	0x05e393ec11d0197a88d84457908edd4ff235f323	0xdada5a8e3703b1e3ea2bae5ab704627eb2659fcc	218	18733446	2023-12-07T09:13:11.000Z	0x3b5db340c90322a6aaabeddfb26a869fae414856589b3d1b7ccc74368b811f23
0x3a0008a588772446f6e656133c2d5029cc4fc20e	false	0x9c29c571847a68a947acec8bacd303e36bc72ec5	0x6ddc10eeeebbbcf00e784ba44fe4b038af26cb53	274	18733380	2023-12-07T08:59:47.000Z	0x88b540deae7c4e44222adc40d8dad6fd3d9b3ae5797d0e89831c157f1fb8bbac
0x3a0008a588772446f6e656133c2d5029cc4fc20e	false	0xe2d8f982708ce1e3814c8986cbab624ca926288a	0xdada5a8e3703b1e3ea2bae5ab704627eb2659fcc	66	18619061	2023-11-21T08:51:23.000Z	0x27ce3d9de1a3914764406f9c4d87e97617f4a9c3836fa7ea9e70a35884c7ec92

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

EthGenesisVault_Deposited_event

EthGenesisVault_ExitQueueEntered_event

EthGenesisVault_Migrated_event

EthVault_Deposited_event

EthVault_ExitQueueEntered_event

EthVaultFactory_VaultCreated_event

EthVaultTest_Deposited_event

EthVaultTest_ExitQueueEntered_event

OsTokenVaultController_StateUpdated_event

VaultsRegistry_VaultAdded_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​EthGenesisVault_Deposited_event

​EthGenesisVault_ExitQueueEntered_event

​EthGenesisVault_Migrated_event

​EthVault_Deposited_event

​EthVault_ExitQueueEntered_event

​EthVaultFactory_VaultCreated_event

​EthVaultTest_Deposited_event

​EthVaultTest_ExitQueueEntered_event

​OsTokenVaultController_StateUpdated_event

​VaultsRegistry_VaultAdded_event

Tables

EthGenesisVault_Deposited_event

EthGenesisVault_ExitQueueEntered_event

EthGenesisVault_Migrated_event

EthVault_Deposited_event

EthVault_ExitQueueEntered_event

EthVaultFactory_VaultCreated_event

EthVaultTest_Deposited_event

EthVaultTest_ExitQueueEntered_event

OsTokenVaultController_StateUpdated_event

VaultsRegistry_VaultAdded_event