Skip to main content

​
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.
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_toSTRINGDestination address receiving tokens or assets in the 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_ethAmountSTRINGAmount of ETH involved in the transaction. Integer value stored as string, denominated in wei.
in_timeSTRINGUnix 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).
in_toaddressin_timeremovedin_amountlog_indexblock_numberin_ethAmountblock_timestamptransaction_hash
0xf7626459234e9249808a06aa08dc6b67c8e0a2fc0x9559aaa82d9649c7a7b220e7c461d2e74c9a35931689146495false473400348879120898249176759675000000000000000002023-07-12T07:21:35.000Z0x412145d2e1a3e79c5be8d6614517bbb11e488cb9c76415f2671d7a31fdbe4778
0x8e7fcc7a17f00f0f5f85f2d5964a581d0813c8a60x9559aaa82d9649c7a7b220e7c461d2e74c9a35931632880162false1978333357739218149640213317847200000000000000000002021-09-29T01:49:22.000Z0x0743240a34c5d3b838f9be6180f2d5a344c28ba8ffbe0cda79559da4bc74c7e0
0xc91fc9dd7f1bb6ec429eddb577b9ace6236b21470x9559aaa82d9649c7a7b220e7c461d2e74c9a35931695976163false966007732550353520214318240188103000000000000000002023-09-29T08:29:23.000Z0x8a4f064a8adc23903cf79e2adc1ba9f19755fa64755cc9e5d8b2e402fc7ca5b7
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.
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_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_rethAmountSTRINGAmount 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_ethAmountSTRINGAmount of ETH involved in the transaction. Integer value stored as string, denominated in wei.
in_withdrawIndexSTRINGSequential identifier assigned to each unstake request in the StaFi protocol withdrawal queue. Increments monotonically with each new withdrawal, starting from index 1.
in_instantlyBOOLFlag 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.
addressin_fromremovedlog_indexblock_numberin_ethAmountin_instantlyin_rethAmountblock_timestampin_withdrawIndextransaction_hash
0x27d64dd9172e4b59a444817d30f7af8228f174cc0xbddeb8b18ef1f4017951cbe9d8682af40b8cdcb0false631734906631999349211848797331false304540000000000000002023-05-27T08:00:11.000Z560xb34745dfda90fd7e1724fd023c1e61a6741212d3e54b6315557676d39aa54903
0x27d64dd9172e4b59a444817d30f7af8228f174cc0x8db498b37b0f6cd8a3edd445e7c3107c18547511false56180547411535742156783394359false14438400000000000002023-09-03T08:20:35.000Z1840x75a60f4ec1ca9df705e3f5a9f440358cdfa27c4488ad7c0056a03328a1062d77
0x27d64dd9172e4b59a444817d30f7af8228f174cc0x3b11267dfc4b9ebe8427e8f557056b4b6ce98112false1001805511397855910920927721276false920000000000000000002023-09-03T09:35:23.000Z1850x396b0dce39558f7cd634696a592211e024fd325df7b3368ae973211003f8c6f4
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