etherfi_v2_ethereum

Tables

ETHFIRewards_Claimed_event

ETHFI token reward claim events from the Ether.fi protocol. Records user reward withdrawals with account addresses, claimed amounts, and liquidity index snapshots at time of claim.

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_rootHash`	`STRING`	Merkle root hash used to verify the validity of the claimed reward in the EtherFi rewards distribution. This cryptographic proof ensures the claim matches the protocol’s authorized reward allocation.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_balance`	`STRING`	Token balance amount involved in the operation. Numeric string representation in smallest denomination of the token.

Sample Data

address	in_user	removed	in_token	log_index	in_balance	in_rootHash	block_number	block_timestamp	transaction_hash
0xf0164d48b308c42ae028e3379b2fb620e70f8780	0x65e51317b375126aa5ef46487952468a74bf792c	false	0xfe0c30065b384f05761f15d0cc899d4f9f9cc0eb	514	423691735269265264	0x11b66de50b9ce7b6ce8fa78d07c703067b2f2374c661b330c189cacc3b9cec87	19925749	2024-05-22T13:34:35.000Z	0x38c9d322a9877460bc9e4e33898468021ab2c18c8334c4d2ad7987ee08e08e82
0xf0164d48b308c42ae028e3379b2fb620e70f8780	0x9feb65fd0d0c99948d2431af32f35a49e3d32366	false	0xfe0c30065b384f05761f15d0cc899d4f9f9cc0eb	286	47406127274588456326	0x11b66de50b9ce7b6ce8fa78d07c703067b2f2374c661b330c189cacc3b9cec87	19928301	2024-05-22T22:07:35.000Z	0x71d916b8d4ecf788e8565a97cb2a9063b8a0eafa2bde34411791b5957c9956ea
0xf0164d48b308c42ae028e3379b2fb620e70f8780	0xeffa4f8eb89dbc672b4a0808777a0523b8e7b9cd	false	0xfe0c30065b384f05761f15d0cc899d4f9f9cc0eb	566	44733087598453095	0x11b66de50b9ce7b6ce8fa78d07c703067b2f2374c661b330c189cacc3b9cec87	19923978	2024-05-22T07:37:23.000Z	0x00e5a5b505b00064d6beb227285215194c0fd799457cce59a75dd2461c8f8224

Example Query

Query with partition filter

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

LiquidityPool_Deposit_event

Deposit events from Ether.fi v2 liquidity pool on Ethereum, capturing ETH deposits with depositor addresses, amounts in wei, referral codes, and source identifiers. Used for analyzing user acquisition, referral program effectiveness, and liquidity pool growth patterns.

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_sender`	`STRING`	Address that initiated 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_source`	`INT64`	Source chain identifier for the cross-chain operation. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-1” for Ethereum, “EVM-56” for BSC).
`in_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.

Sample Data

address	removed	in_amount	in_sender	in_source	log_index	in_referral	block_number	block_timestamp	transaction_hash
0x308861a430be4cce5502d0a12724771fc6daf216	false	10000000000000000	0x741da2bc4a54544f7a404e5f3ae7d3d7091b0300	1	275	0xb91279c54007f16f1ce04237daf6f14f1253fba1	19543075	2024-03-30T00:00:23.000Z	0x3e52d8a96be5f715571c2864b5371b256988448709f557b0a47720ef33c96787
0x308861a430be4cce5502d0a12724771fc6daf216	false	10000000000000000	0x03c3ed52343aa71ad25c31964f624920fe5a7cde	1	545	0x1c0393442c311dda007d0ef0e839c4d000cf5241	19543780	2024-03-30T02:22:59.000Z	0x61439fc736656366c5658c723953f3ca0cacfd1f371bf158521e48d25fb8cb6d
0x308861a430be4cce5502d0a12724771fc6daf216	false	10000000000000000	0x4dc5fadd25b80981f59a45c32b14fa0e55173a4e	1	342	0x118ca9bf0168ac506c1ae3b62e6d954c8b99a424	19546884	2024-03-30T12:51:35.000Z	0x2ead99ebf4e524bf26cafcb7bd067f5b41ff3404f1cc0974323c3674a2dbff8a

Example Query

Query with partition filter

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

LiquidityPool_deposit2_function

ETH deposit transactions into EtherFi’s LiquidityPool contract on Ethereum, tracking deposited amounts, receipt token shares, and referral addresses. Used for analyzing staking inflows, share pricing, and referral program activity.

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.
`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__referral`	`STRING`	Address of the referrer who directed this deposit to the EtherFi liquidity pool. May be the depositor’s own address if self-referred, as seen in some sample transactions.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	value	status	gas_used	out_anon0	signature	to_address	block_number	from_address	in__referral	block_timestamp	transaction_hash
79599	50000000000000000	true	70635	47937464845957767	0xf340fa01	0x308861a430be4cce5502d0a12724771fc6daf216	20313885	0x47587d8476cd8fa357c1b096d7d328f2d1af365a	0xcabe7ddb088e47bf4291b42affb8fa261b75500a	2024-07-15T19:05:23.000Z	0x44b7569697eda86606d9a4c0aa1b272da47ef70847fac8fc15b8ba61521836c2
90531	1000000000000000	true	87735	958786932987426	0xf340fa01	0x308861a430be4cce5502d0a12724771fc6daf216	20310885	0xded7a36d8752804219af1f4cb642e9593caf9e50	0xf8e17a0d41df702d9f9c9e906083c7e97236e5e2	2024-07-15T09:01:35.000Z	0x18a31e103ea330bbb103b0ee3f09cc2724a5cfd429a9bf38192feb327bc0abdb
99584	653000000000000000	true	87735	626087867240789585	0xf340fa01	0x308861a430be4cce5502d0a12724771fc6daf216	20312387	0x84dc638c5e9b7ebb22572919f95237032dd69b52	0xf83434a19f67fcb65bc712e47642a76e3aae01ca	2024-07-15T14:03:47.000Z	0x67e5cac37ccd37e0d453a99857dbd550fee8008e314bc705c8116d8372b6dc89

Example Query

Query with partition filter

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

LiquidityPool_ProtocolFeePaid_event

Protocol fee payment events from Etherfi v2 liquidity pools on Ethereum, recording fee amounts in wei collected by the protocol. Useful for tracking protocol revenue and fee accrual patterns 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_protocolFees`	`STRING`	Protocol fees collected by the platform from the transaction. Numeric string representation of the fee amount in the token’s smallest unit.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_protocolFees	transaction_hash
0x308861a430be4cce5502d0a12724771fc6daf216	false	346	21205041	2024-11-17T04:28:35.000Z	4908184466997336737	0xd192b5fef8bfa7fd476b8a128cb9f53a960684f532e1d7b5611b2edd3aebb18d
0x308861a430be4cce5502d0a12724771fc6daf216	false	230	22643937	2025-06-06T07:02:11.000Z	12463289315882302510	0x4978ac7752f956b6f12dccac6c08cce713de99a332bcfba4bd6255b3b17e4eb8
0x308861a430be4cce5502d0a12724771fc6daf216	false	197	22646457	2025-06-06T15:31:35.000Z	6145040701524539178	0x7afe45df8e2fc25c035685554cb86ae2cd53ccf60d36543645f4b1d813f3c7e7

Example Query

Query with partition filter

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

LiquidityPool_Rebase_event

Rebase events from EtherFi’s Ethereum liquid staking pool tracking total ETH locked and eETH shares outstanding. Used to calculate the eETH/ETH exchange rate over time and analyze staking yield accrual.

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_totalEthLocked`	`STRING`	Total amount of ETH locked in the EtherFi liquidity pool at the time of rebase, denominated in wei (1e18 per ETH). Values typically range in the trillions of wei, representing billions of ETH in protocol reserves.
`in_totalEEthShares`	`STRING`	Total shares of eETH (ether.fi’s liquid staking token) in the liquidity pool at the time of rebase. Denominated in wei (1e18 = 1 eETH share), this value tracks proportional ownership of the underlying staked ETH.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_totalEthLocked	in_totalEEthShares
0x308861a430be4cce5502d0a12724771fc6daf216	false	140	21770497	2025-02-04T03:35:35.000Z	0x043d9ae9877f31cffdaa285fc1bd15753fe3089a16674acaf23dbec65b5f7a70	2276559382256456385031348	2149143804062918443968233
0x308861a430be4cce5502d0a12724771fc6daf216	false	16	21769858	2025-02-04T01:27:35.000Z	0xeafd9192425bf1a8602251a8f30a31204a84e35c151f5502d2fd9cc7ec887542	2276819435489926728820632	2149414056435881120255076
0x308861a430be4cce5502d0a12724771fc6daf216	false	259	21776201	2025-02-04T22:45:11.000Z	0x9d3e52f58c40c684a2e6e9e0815b583ae5050ce5e06927f98c7e8fc2804c0643	2265032963604219892902746	2138040303005205435717958

Example Query

Query with partition filter

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

LiquidityPool_Withdraw_event

Withdrawal events from Ether.fi v2 liquidity pool on Ethereum, recording amount, sender, recipient, and source type for each withdrawal transaction. Useful for tracking liquidity exits and user withdrawal patterns from the Ether.fi staking protocol.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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_source`	`INT64`	Source chain identifier for the cross-chain operation. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-1” for Ethereum, “EVM-56” for BSC).

Sample Data

address	removed	in_amount	in_sender	in_source	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0x308861a430be4cce5502d0a12724771fc6daf216	false	204106807586726632	0xa9a3ef65279ed3fde306b1d0a96617951b0d4ee4	1	215	18647496	0xa9a3ef65279ed3fde306b1d0a96617951b0d4ee4	2023-11-25T08:23:35.000Z	0xda5af466e72f168b1850964c848561f5f3c1181706d588727f6ecc77244f0bb8
0x308861a430be4cce5502d0a12724771fc6daf216	false	100016963480869484	0x83037d633813d101299a84e5b131e19305fdfd1d	1	209	18647818	0x83037d633813d101299a84e5b131e19305fdfd1d	2023-11-25T09:28:35.000Z	0x0b15e79ecd5c0e9083684445c710528d600123b458123eb370f83731a24b5016
0x308861a430be4cce5502d0a12724771fc6daf216	false	110018659828956433	0xc13456a34305e9265e907f70f76b1ba6e2055c8b	1	210	18647721	0xc13456a34305e9265e907f70f76b1ba6e2055c8b	2023-11-25T09:08:59.000Z	0xc6fba36f118d8f4ae71bab34451a359e016c4fe4c61958b8c70dbe1bdd0286ea

Example Query

Query with partition filter

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

LiquidityPool_withdraw_function

Withdraw function call records from Ether.fi v2 LiquidityPool contract on Ethereum, tracking liquidity removals with withdrawal amounts and recipient addresses. Useful for analyzing user withdrawal patterns and liquidity pool outflows.

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.
`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__recipient`	`STRING`	Address designated to receive the assets or proceeds from the transaction. 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).
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	signature	in__amount	to_address	block_number	from_address	in__recipient	trace_address	block_timestamp	transaction_hash
35962	true	32616	0xf3fef3a3	500142290808855981	0x308861a430be4cce5502d0a12724771fc6daf216	18326648	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	0x173863cf3befe457cf248857b673402beb82fcdf	0,16	2023-10-11T10:37:11.000Z	0x3b1ed43ccc1b4eaa5ba685a670065b881d83b14a76967908a21f37a02ff7355c
35962	true	32616	0xf3fef3a3	49580953520771913	0x308861a430be4cce5502d0a12724771fc6daf216	18329640	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	0xdc11ca422d5b30726a0e0b88df060dcdd2524f09	0,16	2023-10-11T20:41:47.000Z	0x054f5b12c8cdbec5e5e2866922c33f01ed794d0eb0563345529820fbe9d1c0ab
35962	true	32616	0xf3fef3a3	501447200181156725	0x308861a430be4cce5502d0a12724771fc6daf216	18326635	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	0x2fa4e80b8d39f29f5ea746bad3c1840fb56cf47b	0,16	2023-10-11T10:34:35.000Z	0x81af4b7ebac9cfc139f48ccbff459861818624bc93f9d695341c2b8e92b1f09e

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ETHFIRewards_Claimed_event

LiquidityPool_Deposit_event

LiquidityPool_deposit2_function

LiquidityPool_ProtocolFeePaid_event

LiquidityPool_Rebase_event

LiquidityPool_Withdraw_event

LiquidityPool_withdraw_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​ETHFIRewards_Claimed_event

​LiquidityPool_Deposit_event

​LiquidityPool_deposit2_function

​LiquidityPool_ProtocolFeePaid_event

​LiquidityPool_Rebase_event

​LiquidityPool_Withdraw_event

​LiquidityPool_withdraw_function

Tables

ETHFIRewards_Claimed_event

LiquidityPool_Deposit_event

LiquidityPool_deposit2_function

LiquidityPool_ProtocolFeePaid_event

LiquidityPool_Rebase_event

LiquidityPool_Withdraw_event

LiquidityPool_withdraw_function