stafi_v1_ethereum

Tables

RETHToken_TokensMinted_event

rETH token minting events from StaFi liquid staking protocol on Ethereum, recording when users stake ETH and receive rETH in return. Captures depositor address, ETH amount staked, and rETH tokens minted for analyzing staking activity and exchange rate dynamics.

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_to`	`STRING`	Destination address receiving tokens or assets in the 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_ethAmount`	`STRING`	Amount of ETH involved in the transaction. Integer value stored as string, denominated in wei.
`in_time`	`STRING`	Unix timestamp representing the time of the event or operation. Integer value stored as string, representing seconds since epoch (January 1, 1970 00:00:00 UTC).

Sample Data

in_to	address	in_time	removed	in_amount	log_index	block_number	in_ethAmount	block_timestamp	transaction_hash
0xf7626459234e9249808a06aa08dc6b67c8e0a2fc	0x9559aaa82d9649c7a7b220e7c461d2e74c9a3593	1689146495	false	473400348879120898	249	17675967	500000000000000000	2023-07-12T07:21:35.000Z	0x412145d2e1a3e79c5be8d6614517bbb11e488cb9c76415f2671d7a31fdbe4778
0x8e7fcc7a17f00f0f5f85f2d5964a581d0813c8a6	0x9559aaa82d9649c7a7b220e7c461d2e74c9a3593	1632880162	false	19783333577392181496	402	13317847	20000000000000000000	2021-09-29T01:49:22.000Z	0x0743240a34c5d3b838f9be6180f2d5a344c28ba8ffbe0cda79559da4bc74c7e0
0xc91fc9dd7f1bb6ec429eddb577b9ace6236b2147	0x9559aaa82d9649c7a7b220e7c461d2e74c9a3593	1695976163	false	9660077325503535202	143	18240188	10300000000000000000	2023-09-29T08:29:23.000Z	0x8a4f064a8adc23903cf79e2adc1ba9f19755fa64755cc9e5d8b2e402fc7ca5b7

Example Query

Query with partition filter

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

StafiWithdraw_Unstake_event

Unstake event records from StaFi liquid staking protocol on Ethereum, capturing user withdrawals of rETH (StaFi ETH) back to native ETH with redemption amounts and sequential withdrawal indexes. Used for tracking unstaking flows, redemption rates between rETH and ETH, and withdrawal queue 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rethAmount`	`STRING`	Amount of rETH (Stafi’s liquid staking token) being unstaked by the user, denominated in wei (smallest unit, 18 decimals). This value represents the liquid staking derivative being burned in exchange for the underlying ETH.
`in_ethAmount`	`STRING`	Amount of ETH involved in the transaction. Integer value stored as string, denominated in wei.
`in_withdrawIndex`	`STRING`	Sequential identifier assigned to each unstake request in the StaFi protocol withdrawal queue. Increments monotonically with each new withdrawal, starting from index 1.
`in_instantly`	`BOOL`	Flag indicating whether the unstake withdrawal is processed immediately versus queued for delayed processing. Sample data shows all values as false, suggesting most withdrawals follow the standard delayed unstaking mechanism.

Sample Data

address	in_from	removed	log_index	block_number	in_ethAmount	in_instantly	in_rethAmount	block_timestamp	in_withdrawIndex	transaction_hash
0x27d64dd9172e4b59a444817d30f7af8228f174cc	0xbddeb8b18ef1f4017951cbe9d8682af40b8cdcb0	false	63	17349066	31999349211848797331	false	30454000000000000000	2023-05-27T08:00:11.000Z	56	0xb34745dfda90fd7e1724fd023c1e61a6741212d3e54b6315557676d39aa54903
0x27d64dd9172e4b59a444817d30f7af8228f174cc	0x8db498b37b0f6cd8a3edd445e7c3107c18547511	false	56	18054741	1535742156783394359	false	1443840000000000000	2023-09-03T08:20:35.000Z	184	0x75a60f4ec1ca9df705e3f5a9f440358cdfa27c4488ad7c0056a03328a1062d77
0x27d64dd9172e4b59a444817d30f7af8228f174cc	0x3b11267dfc4b9ebe8427e8f557056b4b6ce98112	false	100	18055113	97855910920927721276	false	92000000000000000000	2023-09-03T09:35:23.000Z	185	0x396b0dce39558f7cd634696a592211e024fd325df7b3368ae973211003f8c6f4

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

RETHToken_TokensMinted_event

StafiWithdraw_Unstake_event

​Tables

​RETHToken_TokensMinted_event

​StafiWithdraw_Unstake_event

Tables

RETHToken_TokensMinted_event

StafiWithdraw_Unstake_event