etherfi_v1_hyperevm

Tables

LiquidHypeDepositVault_DepositInstant_event

Instant deposit events from Ether.fi’s Liquid Hype vault on HyperEVM, capturing user deposits of tokens with USD-denominated amounts, minted vault shares, and referrer tracking for analyzing liquidity inflows and referral program effectiveness.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenIn`	`STRING`	Contract address of the token being swapped in or deposited. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountUsd`	`STRING`	USD-denominated value of the deposited token at time of transaction, represented as a wei-like 18-decimal integer. This normalized value enables cross-token deposit comparisons regardless of the input token type.
`in_amountToken`	`STRING`	Token amount deposited by the user, denominated in the input token’s smallest unit (wei-equivalent). May differ from USD value due to token price or conversion mechanics.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
`in_minted`	`STRING`	Amount of tokens minted and issued to the user. String-encoded integer value representing the quantity in the smallest unit of the token.
`in_referrerId`	`STRING`	Referral identifier associated with the deposit transaction, typically used for tracking referral programs or attribution. Hex-encoded 32-byte value, commonly zero address for non-referred deposits.

Sample Data

address	in_user	removed	in_minted	log_index	in_tokenIn	block_number	in_amountUsd	in_referrerId	in_amountToken	block_timestamp	transaction_hash
0xf538675d292d8b372712f44eaf306cc66cf6d8dc	0xcc6915c80d1c56212f88c9c5f1083521d3848603	false	513714822814296548	11	0x5555555555555555555555555555555555555555	17498526	516277535442239720	0x0000000000000000000000000000000000000000000000000000000000000017	516277535442239720	2025-10-26T07:46:15.000Z	0xa6455a755f2c82484f5253289cc0b9b2aa33376c09199af7df2dca217a1dc227
0xf538675d292d8b372712f44eaf306cc66cf6d8dc	0x1ecc0663aa9b7ffdbfa30c35db336d75c959c2ec	false	7102480819563764220	26	0x5555555555555555555555555555555555555555	17527727	7137912184355431819	0x0000000000000000000000000000000000000000000000000000000000000017	7137912184355431819	2025-10-26T15:44:58.000Z	0xafc1aa1f91a29f14696ac93342f3fa300d731c8a59d94fe959e59e12c72d7c01
0xf538675d292d8b372712f44eaf306cc66cf6d8dc	0x41d81daf401a0aa7422a769243fa933f351a0d64	false	2328079254979133897	32	0x5555555555555555555555555555555555555555	17517065	2339693087869730255	0x2a176b24a5fec3af048070ad484d82fe4152c8b8eb2edc993ef5700c58ef3d53	2339693087869730255	2025-10-26T12:50:10.000Z	0x09925d28f6bcfb6840c15a650d2cc3bdd86bde835f3ad747ad6c4fe95f121fb0

Example Query

Query with partition filter

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

LiquidHypeRedemptionVaultWithSwapper_RedeemInstant_event

Instant redemption events from Ether.fi’s Liquid Hype vault on HyperEVM, recording user withdrawals with input amounts, output token amounts, and associated fees. Tracks user exits from the liquid staking position with swap execution details for analyzing redemption patterns and fee structures.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenOut`	`STRING`	Contract address of the token being received from the swap. 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_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_amountTokenOut`	`STRING`	Amount of output tokens received from the redemption or swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_amount	log_index	in_tokenOut	block_number	in_feeAmount	block_timestamp	transaction_hash	in_amountTokenOut
0x558806a80b42cab4ed75c74bfb178edc9087aa32	0xd075d9cb27e42b279c9f81bf8455fe65108d72d7	false	8000000000000000	5	0xd8fc8f0b03eba61f64d08b0bef69d80916e5dda9	14163411	40000000000000	2025-09-18T08:24:28.000Z	0xd8e3cc8579e60f63047cea75997cf646013eebd4a65691153f11ce345c44b564	7973300457293061
0x558806a80b42cab4ed75c74bfb178edc9087aa32	0x821cf17c77661732c0a431bc3e277a3cc02d5ab4	false	999621553276	10	0x5555555555555555555555555555555555555555	10060006	1999243106	2025-08-02T14:55:40.000Z	0x3a5dbea3b7876bf5f04db4eb230280a0ad3cd0359dda1628e289d5f75f78079b	998000000000
0x558806a80b42cab4ed75c74bfb178edc9087aa32	0x50a79ce4ccca1d64c0b2513fb405a19ed40cb851	false	23990917278627484419	2	0xd8fc8f0b03eba61f64d08b0bef69d80916e5dda9	13637986	0	2025-09-12T08:49:44.000Z	0xeb9238841f795d0dee7071fc25ea6eb04423d1945e92dc3509f47d2f2ac3b591	24038106987764302511

Example Query

Query with partition filter

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

LiquidHypeRedemptionVaultWithSwapper_RedeemRequest_event

Redemption request events from Ether.fi’s liquid staking vault on HyperEVM, capturing user withdrawals of mTokens (liquid staking tokens) to underlying assets. Tracks request IDs, token amounts, and fee data for analyzing vault exit flows and liquidity demands.

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_requestId`	`STRING`	Unique identifier for an asynchronous request or operation. String-encoded integer that tracks requests across submission, fulfillment, cancellation, or claim events.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenOut`	`STRING`	Contract address of the token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountMTokenIn`	`STRING`	Amount of mToken deposited by the user to initiate the redemption request, denominated in the token’s smallest unit (wei). Values are stored as strings to preserve precision for large token amounts.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.

Sample Data

address	in_user	removed	log_index	in_tokenOut	block_number	in_requestId	block_timestamp	transaction_hash	in_amountMTokenIn
0x558806a80b42cab4ed75c74bfb178edc9087aa32	0xebb94dfc47595763ebd990b8109392d42e02d61b	false	2	0x5555555555555555555555555555555555555555	11961701	1216	2025-08-24T06:47:12.000Z	0x7f793ea2cdefbc6b9db3e043dbb995aa343d8b671610b9eed710d0f3d4028bbb	149964791925464534403
0x558806a80b42cab4ed75c74bfb178edc9087aa32	0xebb94dfc47595763ebd990b8109392d42e02d61b	false	2	0x5555555555555555555555555555555555555555	11961411	1214	2025-08-24T06:42:27.000Z	0x4d2d1348c508ee721afef3148526414f9e42274ae6fbd3abec9c0f85088cf7e4	300000000000000000000
0x558806a80b42cab4ed75c74bfb178edc9087aa32	0xea722a08744f35e635dc54345d16c10f12f2da6e	false	2	0x5555555555555555555555555555555555555555	12014000	1230	2025-08-24T21:04:34.000Z	0x2b4e8a522e6ef600a9d019752b49f65fac6f558b29f974ec10976951c49fc24e	257121895326631475342

Example Query

Query with partition filter

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

WithdrawManager_InstantWithdrawal_event

Instant withdrawal events from Ether.fi’s beHYPE staking token on HyperEVM, recording user withdrawals with amounts, fees, and HYPE tokens received. Tracks expedited unstaking activity where users pay a fee (approximately 0.3% based on samples) to bypass standard withdrawal waiting periods.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_beHypeAmountWithdrawn`	`STRING`	Amount of beHYPE tokens withdrawn by the user from the WithdrawManager contract, denominated in wei (18 decimals). This value represents the total beHYPE burned before applying instant withdrawal fees.
`in_hypeAmountReceived`	`STRING`	Amount of HYPE tokens received by the user after deducting the instant withdrawal fee from the beHYPE amount. Denominated in wei (18 decimals), always slightly less than the withdrawn beHYPE amount.
`in_beHypeInstantWithdrawalFee`	`STRING`	Fee charged for the instant withdrawal service, denominated in beHype token base units (wei). Typically represents approximately 0.3% of the withdrawn amount based on sample transactions.

Sample Data

address	in_user	removed	log_index	block_number	block_timestamp	transaction_hash	in_hypeAmountReceived	in_beHypeAmountWithdrawn	in_beHypeInstantWithdrawalFee
0x9d0b0877b9f2204cf414ca7862e4f03506822538	0x12bea9604f0ee6331dd86dff2e6569dff79e0f92	false	4	17288608	2025-10-23T22:23:42.000Z	0x3e47365b445e390180fef2bcd106a6b09b6a97b16f1508fb7bc465e02c171efb	17473346095715258596	17479869950000000000	52439609850000000
0x9d0b0877b9f2204cf414ca7862e4f03506822538	0xac08f6bf754f756691a3a61ddd5ff00fc9488373	false	3	17239973	2025-10-23T09:06:24.000Z	0xb5d8a4cedeac17d27fb9edbe5acdfa83e7834f4e3373607b1a3177d3feed38c8	18505831311528165934	18513700000000000000	55541100000000000
0x9d0b0877b9f2204cf414ca7862e4f03506822538	0xac08f6bf754f756691a3a61ddd5ff00fc9488373	false	3	17240053	2025-10-23T09:07:43.000Z	0x7eeec8f47ea3c516488756e180e0825cba65b7f6e6cec6035b47b90fee9dc0c1	18505831311528165934	18513700000000000000	55541100000000000

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

LiquidHypeDepositVault_DepositInstant_event

LiquidHypeRedemptionVaultWithSwapper_RedeemInstant_event

LiquidHypeRedemptionVaultWithSwapper_RedeemRequest_event

WithdrawManager_InstantWithdrawal_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​LiquidHypeDepositVault_DepositInstant_event

​LiquidHypeRedemptionVaultWithSwapper_RedeemInstant_event

​LiquidHypeRedemptionVaultWithSwapper_RedeemRequest_event

​WithdrawManager_InstantWithdrawal_event

Tables

LiquidHypeDepositVault_DepositInstant_event

LiquidHypeRedemptionVaultWithSwapper_RedeemInstant_event

LiquidHypeRedemptionVaultWithSwapper_RedeemRequest_event

WithdrawManager_InstantWithdrawal_event