etherfi_v1_ethereum

Tables

BTCVault_Enter_event

Deposit events into EtherFi’s Bitcoin vault on Ethereum, tracking users depositing BTC-backed assets in exchange for vault shares. Used to analyze vault inflows, user deposit patterns, and share-to-asset conversion rates.

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_asset`	`STRING`	Contract address of the asset or token. 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

in_to	address	in_from	removed	in_asset	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x396ad8cd527d5c98255865e520b52acc3b2e84ac	0x5f46d540b6ed704c3c8789105f30e075aa900726	0x396ad8cd527d5c98255865e520b52acc3b2e84ac	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	7017332	6922527	491	22895192	2025-07-11T09:58:35.000Z	0x1cfbbbfe0c9bb9ea74a422101c20164e1f881207232eb8639ace07aee4b9fd26
0x8cacad8f692824da5cdb8f49ce190df74c279ccc	0x5f46d540b6ed704c3c8789105f30e075aa900726	0x8cacad8f692824da5cdb8f49ce190df74c279ccc	false	0x8236a87084f8b84306f72007f36f2618a5634494	10000	9864	418	22897322	2025-07-11T17:07:59.000Z	0x98e9669a08786dc729fa24813c03b33c022e024a74d324416e85248bbb665415
0x810792ba1ffda4d3c479de531707ac56f4fe8ed1	0x5f46d540b6ed704c3c8789105f30e075aa900726	0x810792ba1ffda4d3c479de531707ac56f4fe8ed1	false	0x657e8c867d8b37dcc18fa4caead9c45eb088c642	3246359	3202500	578	22896060	2025-07-11T12:53:23.000Z	0x4377d6f2ad5ffec9e2b950f8b88559f39598278e3496927f0020b4cfa909d857

Example Query

Query with partition filter

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

BTCVault_Exit_event

Withdrawal events from Ether.fi’s BTC vault contracts on Ethereum, capturing user exits with asset amounts, vault shares burned, and recipient addresses. Used for tracking BTC-backed token redemptions and vault liquidity flows.

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_asset`	`STRING`	Contract address of the asset or token. 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

in_to	address	in_from	removed	in_asset	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xf8553c8552f906c19286f21711721e206ee4909e	0x5f46d540b6ed704c3c8789105f30e075aa900726	0x989468982b08aefa46e37cd0086142a86fa466d7	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	68356042	67817989	361	21740840	2025-01-31T00:09:35.000Z	0xf9ee9b8a975ad866bd044ebfad5d89a016143c436a1e0948dd3601bc21d26933
0xf8553c8552f906c19286f21711721e206ee4909e	0xc673ef7791724f0dcca38adb47fbb3aef3db6c80	0x989468982b08aefa46e37cd0086142a86fa466d7	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	605967921	605967921	361	21740835	2025-01-31T00:08:35.000Z	0xaa9104de633bfcbcbe10c46df2d62b71055325595ed424dfc543197a82f69cf9
0xf8553c8552f906c19286f21711721e206ee4909e	0xc673ef7791724f0dcca38adb47fbb3aef3db6c80	0x989468982b08aefa46e37cd0086142a86fa466d7	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	190925488	190925488	172	21746224	2025-01-31T18:13:47.000Z	0x5038768ad212d2f747c735fe5e571276ac03bdc4ae983a6b7f5f7f86d60444b6

Example Query

Query with partition filter

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

BTCVaultAccountant_ExchangeRateUpdated_event

Exchange rate update events from EtherFi’s Bitcoin vault accountant contract on Ethereum, tracking yield accrual through rate changes over time. Used for calculating BTC staking vault performance and share valuations.

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_oldRate`	`STRING`	Previous exchange rate before the update. Numeric string representation in ray units (27 decimals).
`in_newRate`	`STRING`	Updated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
`in_currentTime`	`STRING`	Unix timestamp representing the time when the exchange rate was updated. Numeric string in seconds since epoch.

Sample Data

address	removed	log_index	in_newRate	in_oldRate	block_number	in_currentTime	block_timestamp	transaction_hash
0xea23ac6d7d11f6b181d6b98174d334478adae6b0	false	556	101383361	101377979	23227541	1756238483	2025-08-26T20:01:23.000Z	0x4e47c004720df1ceb1d4ef55d401f61deadd95cd4e90492915e2b38563d3f0fb
0xea23ac6d7d11f6b181d6b98174d334478adae6b0	false	265	101413792	101416735	22012435	1741560983	2025-03-09T22:56:23.000Z	0x5d65c1d8bec7a279c0964fd56f4c2397742bc6d616d2c83b5f1c2b45a507f2e4
0xea23ac6d7d11f6b181d6b98174d334478adae6b0	false	406	101419838	101424750	22091391	1742513639	2025-03-20T23:33:59.000Z	0xf12dac4584beeb9b1ffa3b7c8bf73fa4ea0419a72479e5272fd5905555034691

Example Query

Query with partition filter

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

BTCVaultAccountant_FeesClaimed_event

Fee claim events from Ether.fi’s Bitcoin vault accountant contract on Ethereum, tracking Wrapped Bitcoin (WBTC) fee distributions. Used for analyzing protocol fee generation and vault performance metrics.

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_feeAsset`	`STRING`	Contract address of the token in which fees are denominated. 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.

Sample Data

address	removed	in_amount	log_index	in_feeAsset	block_number	block_timestamp	transaction_hash
0xea23ac6d7d11f6b181d6b98174d334478adae6b0	false	266816888	221	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	23233574	2025-08-27T16:13:11.000Z	0x3ab98cab58464e6bad3569f3a805ca8811b5b5d45d840662b87a212de7ee9940
0xea23ac6d7d11f6b181d6b98174d334478adae6b0	false	10010204	786	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	23935075	2025-12-03T19:44:23.000Z	0x4cf2e4925511d6098765dbb66dc481a71515f2fa6e7c065554402e645d73831b

Example Query

Query with partition filter

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

EarlyAdopterPool_DepositERC20_event

ERC20 token deposit events from Ether.fi’s Early Adopter Pool contract on Ethereum, capturing user deposits during the protocol’s initial launch phase. Records sender addresses and deposit amounts (approximately 0.105 ETH in sample data) for tracking early participant contributions.

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.

Sample Data

address	removed	in_amount	in_sender	log_index	block_number	block_timestamp	transaction_hash
0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4	false	105100000000000000	0x247482956882f29231cec80feb2d048ef1d17107	255	17555314	2023-06-25T08:29:23.000Z	0x609e44274e4d452bab992145bc065b8a18a41e7652d393cf532105be9e9f45b5
0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4	false	105100000000000000	0xec8c42cf29ba0e5a72583f8c2c453267fe9cd675	1003	17555277	2023-06-25T08:21:59.000Z	0x6e541cfa1366437e3596196b56683630f9dee7518125f12c5503c2f3582d24ef
0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4	false	105200000000000000	0xde1f83e35f2922a87e4a54dc77e76c6fddc5a34a	165	17555451	2023-06-25T08:56:47.000Z	0x986c675e93b694fe619db4c094bfcb6ca827c378f43ac3912113ecc487914b8d

Example Query

Query with partition filter

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

EarlyAdopterPool_DepositEth_event

ETH deposit events from Ether.fi’s Early Adopter Pool contract on Ethereum, capturing user addresses and deposit amounts in wei. Used for tracking initial protocol adoption and early depositor activity during Ether.fi’s launch phase.

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.

Sample Data

address	removed	in_amount	in_sender	log_index	block_number	block_timestamp	transaction_hash
0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4	false	100000000000000000	0xc1b5bcbc94e6127ac3ee4054d0664e4f6afe45d3	194	17330049	2023-05-24T15:50:59.000Z	0xf6d54c578f1cd535892f2d1179186a3b1a30590b07d32144921bf2f55bde40ad
0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4	false	100000000000000000	0xaeceb942f7147b18c418fa417b3d38faac43d547	673	17330381	2023-05-24T16:57:59.000Z	0xbd658df3bc286c2291245e951bf733d133b59b81434e32b2edc95fed49ad40b6
0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4	false	100000000000000000	0xc4853837514d2c7211f9b9512f12b1103fb64ac4	250	17326806	2023-05-24T04:54:11.000Z	0x6daa0f7bf273371f28559fa121557f11866a202e9cf45d64dd8aa91b79f3665b

Example Query

Query with partition filter

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

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_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_account`	`STRING`	Account address involved in 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.

Sample Data

address	removed	in_index	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x227dd729c7ca1eb91c22dac0c4b1abad75b8365a	false	59	151779100000000000000000	384	0x3113b42b97de26116b2957288ea94120d5c3e84b	20421260	2024-07-30T18:48:59.000Z	0x01486bac58b62051dd627c6f6f32254cc678567506de9d0e38c55f934ae84836
0x64776b0907b839e759f91a5a328ea143067ddcd7	false	26488	14212084280000000000	22	0x668168690c1728881d09e1aa431198d2102413cb	20416298	2024-07-30T02:07:35.000Z	0x44e03d67a27bfe4c359d40d73279eda19cb8e17cdded88f792de2ed42a812a1e
0x64776b0907b839e759f91a5a328ea143067ddcd7	false	77278	22024392555555557376	37	0xfec80d2993970d9c821afc5073d506a9f02cf4db	20417222	2024-07-30T05:13:35.000Z	0x0c75c9b600f8de128257358dd525ada437d7ca9ceb2cac2cccd342e691a56817

Example Query

Query with partition filter

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

ETHVault_Enter_event

Deposit events from EtherFi’s ETH vault contract tracking user entries with asset amounts and vault share issuance. Used for analyzing vault deposit activity, share-to-asset exchange rates, and depositor behavior on Ethereum mainnet.

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_asset`	`STRING`	Contract address of the asset or token. 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

in_to	address	in_from	removed	in_asset	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x872fdc48cc2356f5b7c3932c71d0407337c6279a	0xf0bb20865277abd641a307ece5ee04e79073416c	0x872fdc48cc2356f5b7c3932c71d0407337c6279a	false	0x35fa164735182de50811e8e2e824cfb9b6118ac2	103000000000000000	100131079269794990	252	20352175	2024-07-21T03:18:23.000Z	0x8b6429549d3ebcccc3f81c12acfb5f39b5f421f2aea82f25d3dc13792df4da38
0xd1dce0628255c7c3e1e3004e406d78f30a4e9862	0x917cee801a67f933f2e6b33fc0cd1ed2d5909d88	0xd1dce0628255c7c3e1e3004e406d78f30a4e9862	false	0x35fa164735182de50811e8e2e824cfb9b6118ac2	100500000000000000	100277595427756751	185	20355802	2024-07-21T15:27:23.000Z	0x27466b7f195d151430b270e572af6d607369b2aecfc4c95c62e7b6215d82bac7
0xa5bbb2ca784ccb741e1e0de81acf961f481ba5da	0x917cee801a67f933f2e6b33fc0cd1ed2d5909d88	0xa5bbb2ca784ccb741e1e0de81acf961f481ba5da	false	0x35fa164735182de50811e8e2e824cfb9b6118ac2	100699999999999999	100477152831593082	222	20354820	2024-07-21T12:09:35.000Z	0x0e33cbb228da40e75d788b73f25711126b215cb4c719ed7df06a4e300eb99ce5

Example Query

Query with partition filter

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

ETHVault_Exit_event

Withdrawal events from Etherfi ETH vault contracts on Ethereum, recording when users redeem vault shares for underlying liquid staking tokens (weETH, eETH). Tracks sender and receiver addresses, share amounts burned, and asset amounts received for analyzing vault exit flows and liquidity 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

in_to	address	in_from	removed	in_asset	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xf8553c8552f906c19286f21711721e206ee4909e	0xf0bb20865277abd641a307ece5ee04e79073416c	0x566bfa809b88967c994d77ed924bebffe80bd00c	false	0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee	1631270261770902441	1652160779249333283	369	21998470	2025-03-08T00:06:23.000Z	0x6a9d16c795e9ce5ccfb7c45c9598f239e0bff89027dd0598a94ae536a6f84f9b
0xf8553c8552f906c19286f21711721e206ee4909e	0xf0bb20865277abd641a307ece5ee04e79073416c	0x566bfa809b88967c994d77ed924bebffe80bd00c	false	0x35fa164735182de50811e8e2e824cfb9b6118ac2	160693293035652709455	153266721437350580043	417	21998469	2025-03-08T00:06:11.000Z	0x353bb4006eef737225c9be18aee24a5a027c82e067a90b7cd4a7067f3b6bbc27
0xf8553c8552f906c19286f21711721e206ee4909e	0x7223442cad8e9ca474fc40109ab981608f8c4273	0x989468982b08aefa46e37cd0086142a86fa466d7	false	0x35fa164735182de50811e8e2e824cfb9b6118ac2	11448778684776291345	11234253600747210293	47	21998561	2025-03-08T00:24:47.000Z	0xa4d936aaa249395f93ec5f9b794c2724b40882c16dca79e8d1ccf09c13bc3f2e

Example Query

Query with partition filter

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

ETHVaultAccountant_ExchangeRateUpdated_event

Exchange rate update events from EtherFi vault accountant contracts on Ethereum, tracking changes in vault share prices over time. Used for monitoring yield accrual and vault performance across multiple EtherFi 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_oldRate`	`STRING`	Previous exchange rate before the update. Numeric string representation in ray units (27 decimals).
`in_newRate`	`STRING`	Updated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
`in_currentTime`	`STRING`	Unix timestamp representing the time when the exchange rate was updated. Numeric string in seconds since epoch.

Sample Data

address	removed	log_index	in_newRate	in_oldRate	block_number	in_currentTime	block_timestamp	transaction_hash
0x126af21dc55c300b7d0bbfc4f3898f558ae8156b	false	146	1004438946194305420	1004368661349455760	20646336	1725080567	2024-08-31T05:02:47.000Z	0x0c54bdca09ba348fd3b361f3093be14c42406808a27ed34fb6a7d6f773db9815
0xbe16605b22a7facef247363312121670dfe5afbe	false	97	1005159245719668037	1005081807310952014	20646044	1725077051	2024-08-31T04:04:11.000Z	0x6cc8b5c46faebce015ff4e04e1fa5ce12b86257a13e329435edaf1524f60a02a
0x0d05d94a5f1e76c18fbeb7a13d17c8a314088198	false	531	1032514572883966886	1032474252914097345	20646261	1725079667	2024-08-31T04:47:47.000Z	0xb299046f0d547a8b4560a5ed78b55e588992ecc7d7f8e4cedb3dee519cf6dbb7

Example Query

Query with partition filter

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

ETHVaultAccountant_FeesClaimed_event

Fee claim events from EtherFi’s ETH vault accountant contract on Ethereum, recording protocol fee collections in WETH (Wrapped Ether). Used for analyzing EtherFi’s revenue generation and fee distribution 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_feeAsset`	`STRING`	Contract address of the token in which fees are denominated. 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.

Sample Data

address	removed	in_amount	log_index	in_feeAsset	block_number	block_timestamp	transaction_hash
0x0d05d94a5f1e76c18fbeb7a13d17c8a314088198	false	180809658798256128227	607	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	21949523	2025-03-01T04:07:23.000Z	0x0b7e29897eb7e8bb006660a65053a127608cc4a72c478e0644573f1f6e587ad5
0x0d05d94a5f1e76c18fbeb7a13d17c8a314088198	false	194988936741173097480	206	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	23033040	2025-07-30T16:09:35.000Z	0xced6b8b4e8dae9d1ccb00601d36eaf196b65d385cb17c2f190495c8cdbb45990
0x0d05d94a5f1e76c18fbeb7a13d17c8a314088198	false	73138916613585133816	207	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	20579982	2024-08-21T22:29:59.000Z	0xf1f17d593917dffa29e061d935d3b3d1bf5b3ba2a1ea8e7dbda18c71fc072d0b

Example Query

Query with partition filter

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

LiquidityPool_Deposit_event

Deposit events from EtherFi v1 liquidity pool on Ethereum, recording ETH deposits with sender addresses and amounts in wei. Used for tracking liquidity provider contributions and analyzing deposit 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_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.

Sample Data

address	removed	in_amount	in_sender	log_index	block_number	block_timestamp	transaction_hash
0x308861a430be4cce5502d0a12724771fc6daf216	false	1100000000000000000	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	156	18277493	2023-10-04T13:36:11.000Z	0x8ea61abe8c199467f430eedb2bd277d576b614e7b1cfa736088f6fb20d1695b3
0x308861a430be4cce5502d0a12724771fc6daf216	false	26000000000000000	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	13	18275163	2023-10-04T05:47:11.000Z	0x6e6c05feac754d68f8b5e8dede874b5c04b95d048909d1b6664572016befadd3
0x308861a430be4cce5502d0a12724771fc6daf216	false	100000000000000000	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	337	18277886	2023-10-04T14:55:23.000Z	0xf08fa83a2b20c66776734622522935bcdf39f3f668c4994d6292ed9be9367810

Example Query

Query with partition filter

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

LiquidityPool_deposit2_function

ETH deposit transactions into the Ether.fi v1 liquidity pool contract on Ethereum, capturing user deposits with recipient addresses and optional merkle proof verification for allowlist functionality. Used for analyzing deposit flow, user participation, and TVL (Total Value Locked) growth in the liquid 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.
`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__user`	`STRING`	Address of the user account involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__recipient`	`STRING`	Address designated to receive the assets or proceeds from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in__merkleProof`	`ARRAY<STRING>`	Cryptographic proof array used to verify user eligibility or allocation for the deposit2 function. Typically contains zero hashes or remains empty for non-allowlisted deposits.

Sample Data

gas	value	status	gas_used	in__user	signature	to_address	block_number	from_address	in__recipient	trace_address	block_timestamp	in__merkleProof	transaction_hash
53637	2000000000000000000	true	50540	0x9f5f5c57d1fa188e767a86a601fe4c3e18c50176	0x816069d5	0x308861a430be4cce5502d0a12724771fc6daf216	17777812	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	0,10	2023-07-26T14:20:59.000Z	[“0x0000000000000000000000000000000000000000000000000000000000000000”]	0xa2aca6845fea8cad95632ad49b92f801fc3e0dcf1de0d0ed5c8936e7128bee2a
53637	100000000000000000	true	50540	0xf9539b8dc06ffa2555b53a2619741da79530a4da	0x816069d5	0x308861a430be4cce5502d0a12724771fc6daf216	17777750	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	0,9	2023-07-26T14:08:23.000Z	[“0x0000000000000000000000000000000000000000000000000000000000000000”]	0x0ab5f4ff1c5e011411142263ca0efda6e50fdb67871e319c0974a7b8616ed80d
53637	500000000000000	true	50540	0xf3b9a0782794cc701f72c7499fcb4c606bdd0bc4	0x816069d5	0x308861a430be4cce5502d0a12724771fc6daf216	17779600	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	0,9	2023-07-26T20:19:59.000Z	[“0x0000000000000000000000000000000000000000000000000000000000000000”]	0x25f655049754826603a5c1661783a4cc9e048381122cf401f2132e78ebe66dad

Example Query

Query with partition filter

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

LiquidityPool_Withdraw_event

Withdrawal events from EtherFi v1 liquidity pool contract on Ethereum, capturing amount withdrawn, sender, and recipient addresses for each transaction. Used for tracking liquidity removal patterns and user withdrawal behavior from the EtherFi 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.

Sample Data

address	removed	in_amount	in_sender	log_index	block_number	in_recipient	block_timestamp	transaction_hash
0x308861a430be4cce5502d0a12724771fc6daf216	false	251810275808347022	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	385	17933553	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	2023-08-17T09:10:11.000Z	0xa1a6fe5163188ded7f641383713b50685009f31f80d452d9420822399f062f50
0x308861a430be4cce5502d0a12724771fc6daf216	false	301745083083873729	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	378	17935136	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	2023-08-17T14:28:35.000Z	0xb11d7f6dcb091b6832e0ec58e7279638e48ab4b7fbad7d62936a133815401ffa
0x308861a430be4cce5502d0a12724771fc6daf216	false	100741023283216354	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	287	17936855	0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000	2023-08-17T20:16:11.000Z	0x2726e0b224b38330564295b0d081b754de96997edb1b555af4788bd0d228a842

Example Query

Query with partition filter

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

LiquidityPool_withdraw_function

Withdrawal transaction records from EtherFi v1 liquidity pool contracts on Ethereum, capturing user withdrawals with amounts and recipient addresses. Used for analyzing liquidity exit patterns and pool redemption 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__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).

Sample Data

gas	status	gas_used	signature	in__amount	to_address	block_number	from_address	in__recipient	trace_address	block_timestamp	transaction_hash
101628	true	38396	0xf3fef3a3	98357156303670418	0x308861a430be4cce5502d0a12724771fc6daf216	22496884	0xdadef1ffbfeaab4f68a9fd181395f68b4e4e7ae0	0xdadef1ffbfeaab4f68a9fd181395f68b4e4e7ae0	0,11	2025-05-16T16:42:47.000Z	0xab23e31fff2bb8a953bf78084c59afd756ff7f50735c49facb5109c3d1a66948
109560	true	38396	0xf3fef3a3	102682357039382448	0x308861a430be4cce5502d0a12724771fc6daf216	22496416	0xdadef1ffbfeaab4f68a9fd181395f68b4e4e7ae0	0xdadef1ffbfeaab4f68a9fd181395f68b4e4e7ae0	0,11	2025-05-16T15:07:11.000Z	0x31a5293b725d8651243b52a86ebde263a76be08819837bbd4093693745db30cc
191425	true	38396	0xf3fef3a3	104987353069899072	0x308861a430be4cce5502d0a12724771fc6daf216	22496871	0xdadef1ffbfeaab4f68a9fd181395f68b4e4e7ae0	0xdadef1ffbfeaab4f68a9fd181395f68b4e4e7ae0	0,11	2025-05-16T16:40:11.000Z	0xf24b724359d4110b464078577198eda85119d7d6871b7c5c29329c7e9c2942a1

Example Query

Query with partition filter

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

LiquidityPoolImplementation_Deposit_event

Deposit events from Ether.fi’s liquidity pool contract on Ethereum, capturing ETH staking deposits with sender addresses, amounts in wei, source identifiers, and optional referral codes. Used for tracking user deposits into Ether.fi’s liquid staking protocol and analyzing 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_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	80000000000000000000	0x01129dad41cbe90f1fb18650ed9c0db3b43f4013	1	183	0x0000000000000000000000000000000000000000	20453189	2024-08-04T05:46:59.000Z	0x2107c256b652bc6261c62037c35fae90176e2b41dbfd8f29981b573d8edcd451
0x308861a430be4cce5502d0a12724771fc6daf216	false	34000000000000000	0x019f4db09258dcea360ed5927c53e1066d7db3f1	1	280	0x0000000000000000000000000000000000000000	20457832	2024-08-04T21:18:35.000Z	0xc746de7c82e3296a4897c431fd94dea6ae159e8770fabc55ccf1d6ff132a082e
0x308861a430be4cce5502d0a12724771fc6daf216	false	34200000000000000	0x03f50259a9f5b2a57f17be8af888c87867e2328f	1	277	0x0000000000000000000000000000000000000000	20457832	2024-08-04T21:18:35.000Z	0x20ee052394b9fa3d433e7720be50edf78deab01d8199e578a9f8441214b45f3a

Example Query

Query with partition filter

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

UltraUSDVault_Enter_event

Deposit events from Ether.fi’s UltraUSD vault on Ethereum, capturing stablecoin deposits (USDC, USDT, DAI) with corresponding vault share issuance. Used for tracking user deposits and vault share minting 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.
`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_asset`	`STRING`	Contract address of the asset or token. 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

in_to	address	in_from	removed	in_asset	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x2c8a1ff3849b3b10673f778433f76105ede396c3	0xbc0f3b23930fff9f4894914bd745ababa9588265	0x2c8a1ff3849b3b10673f778433f76105ede396c3	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	8848001475	8843500133	239	21690508	2025-01-23T23:33:47.000Z	0xc2d3770e94e166e78af98abba255276b711f251c6738e12b6255c9b9bd8187de
0x46db0650645f7c9a29783c89171a62240ccc35cf	0xbc0f3b23930fff9f4894914bd745ababa9588265	0x46db0650645f7c9a29783c89171a62240ccc35cf	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	100000000	99949125	344	21689614	2025-01-23T20:34:23.000Z	0x0b497ac21c766f9cf6bd2048ca3cad8dd11aad96b97e3d99cfb8ef710250dc39
0x46db0650645f7c9a29783c89171a62240ccc35cf	0xbc0f3b23930fff9f4894914bd745ababa9588265	0x46db0650645f7c9a29783c89171a62240ccc35cf	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	2999900106974	2998373934641	266	21689629	2025-01-23T20:37:23.000Z	0x56252ece287636aa09611aa342e8e970aa66781850e8af237e5db26675427b53

Example Query

Query with partition filter

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

UltraUSDVault_Exit_event

Withdrawal events from Ether.fi’s UltraUSD vault on Ethereum, tracking user exits where vault shares are burned in exchange for underlying stablecoin assets (USDC, USDT). Records share-to-asset redemption ratios for analyzing vault liquidity and user withdrawal 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

in_to	address	in_from	removed	in_asset	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xf8553c8552f906c19286f21711721e206ee4909e	0xbc0f3b23930fff9f4894914bd745ababa9588265	0x989468982b08aefa46e37cd0086142a86fa466d7	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	574017822	548558666	538	22455572	2025-05-10T21:11:59.000Z	0x8ce35936be916034eaa2fc3d6cbf0ea71e96fe5227586d8037e70a939c20fed7
0xf8553c8552f906c19286f21711721e206ee4909e	0xbc0f3b23930fff9f4894914bd745ababa9588265	0x989468982b08aefa46e37cd0086142a86fa466d7	false	0xdac17f958d2ee523a2206206994597c13d831ec7	30081325663	28747142054	572	22455573	2025-05-10T21:12:11.000Z	0x496767ec7a1ab5d8f1e18cb028f36e901aab73a39a34f1732c3acdd0f43df782
0xf8553c8552f906c19286f21711721e206ee4909e	0xbc0f3b23930fff9f4894914bd745ababa9588265	0x989468982b08aefa46e37cd0086142a86fa466d7	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	312890453	300022201	387	22329656	2025-04-23T05:36:23.000Z	0x6a2aadf30f125b971329206cd722496235e87748f682469a5bc2a903ee23f211

Example Query

Query with partition filter

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

UltraUSDVaultAccountant_ExchangeRateUpdated_event

Exchange rate changes for Ether.fi’s UltraUSD vault on Ethereum, tracking rate updates with old and new values. Used for monitoring vault performance, yield accrual, and share price movements 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_oldRate`	`STRING`	Previous exchange rate before the update. Numeric string representation in ray units (27 decimals).
`in_newRate`	`STRING`	Updated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
`in_currentTime`	`STRING`	Unix timestamp representing the time when the exchange rate was updated. Numeric string in seconds since epoch.

Sample Data

address	removed	log_index	in_newRate	in_oldRate	block_number	in_currentTime	block_timestamp	transaction_hash
0x95fe19b324be69250138fe8ee50356e9f6d17cfe	false	208	1056123	1056143	22756004	1750547195	2025-06-21T23:06:35.000Z	0x4eb07bda5e03abfd9bc998997b992c6c9440ad10482c3399e39ebdd5f2263471
0x95fe19b324be69250138fe8ee50356e9f6d17cfe	false	196	1039417	1039279	22034202	1741823735	2025-03-12T23:55:35.000Z	0x1a4cba38761a4c19312f7875d384b4c962e37f8311fb7b1d0c08dd5b7fedcf9a
0x95fe19b324be69250138fe8ee50356e9f6d17cfe	false	89	1058834	1058787	22841880	1751584151	2025-07-03T23:09:11.000Z	0xbab0e591ab8bf48932a228bc2775c59cbe4a552d45a71b8e7efa2936e0261f29

Example Query

Query with partition filter

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

UltraUSDVaultAccountant_FeesClaimed_event

Fee collection events from EtherFi’s UltraUSD vault accountant contract on Ethereum, tracking when protocol fees are claimed with asset address and amount. Used for analyzing protocol revenue and fee distribution 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_feeAsset`	`STRING`	Contract address of the token in which fees are denominated. 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.

Sample Data

address	removed	in_amount	log_index	in_feeAsset	block_number	block_timestamp	transaction_hash
0x95fe19b324be69250138fe8ee50356e9f6d17cfe	false	159476674523	96	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	22822330	2025-07-01T05:33:47.000Z	0x7dcdf20c4b882ec57afaeb82e013916468ac0337867a9715f91e2af84749406d

Example Query

Query with partition filter

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

USDVault_Enter_event

Deposit events for EtherFi USD vault contracts on Ethereum, recording when users enter vaults by depositing assets (USDC, USDT, USDe) and receiving proportional vault shares. Used for tracking vault deposit activity, share issuance, and user positions.

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_asset`	`STRING`	Contract address of the asset or token. 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

in_to	address	in_from	removed	in_asset	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x30a6ad56f1141741c44f3dd874487d2af5e901d8	0x08c6f91e2b681faf5e17227f2a44c307b3c1364c	0x30a6ad56f1141741c44f3dd874487d2af5e901d8	false	0x4c9edd5852cd905f086c759e8383e09bff1e68b3	207274200756288357048	201518235	200	20765427	2024-09-16T20:01:23.000Z	0xd6b9b8570c09ff20584328f58c2041e2eb786f8f324e1aa87795b6d1bca5fb5c
0x3c173e3d1e6eaf8f697daea05a39ff0c067743a4	0x08c6f91e2b681faf5e17227f2a44c307b3c1364c	0x3c173e3d1e6eaf8f697daea05a39ff0c067743a4	false	0x4c9edd5852cd905f086c759e8383e09bff1e68b3	82544755252436419131	80280757	178	20759726	2024-09-16T00:52:35.000Z	0xe9dbaadcf343ea6d2addf5a54ef15224a50d5fd1851178dee5398a2bc85a92d8
0x88371de995ec7f8a84bffe56e51d10ef578919a7	0x08c6f91e2b681faf5e17227f2a44c307b3c1364c	0x88371de995ec7f8a84bffe56e51d10ef578919a7	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	309582551	300985502	490	20765274	2024-09-16T19:30:47.000Z	0xda4ea5b3c3161b9729e94e81bb6db539287bccfb5f7163c97d4ec1753997fbf1

Example Query

Query with partition filter

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

USDVault_Exit_event

Withdrawal events from Ether.fi’s USD-denominated vaults on Ethereum, capturing share redemptions for underlying stablecoin assets like USDC and USDT. Used for tracking vault exit activity, redemption rates, and liquidity flows 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

in_to	address	in_from	removed	in_asset	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xf8553c8552f906c19286f21711721e206ee4909e	0x08c6f91e2b681faf5e17227f2a44c307b3c1364c	0x989468982b08aefa46e37cd0086142a86fa466d7	false	0xdac17f958d2ee523a2206206994597c13d831ec7	10471537519	10139568061	604	20924916	2024-10-09T02:02:47.000Z	0xb2eeda526a76931bb57b89e69cc2ddddad3324c6caf2e00f84a7291a75265625
0xf8553c8552f906c19286f21711721e206ee4909e	0x08c6f91e2b681faf5e17227f2a44c307b3c1364c	0x989468982b08aefa46e37cd0086142a86fa466d7	false	0x4c9edd5852cd905f086c759e8383e09bff1e68b3	1398572256295100000000	1354234615	377	20924917	2024-10-09T02:02:59.000Z	0x49b5dcce54c09a32cbd85aaa209f72913995da96f325a0e1dbd9dc76cbc945e0
0xf8553c8552f906c19286f21711721e206ee4909e	0x08c6f91e2b681faf5e17227f2a44c307b3c1364c	0x989468982b08aefa46e37cd0086142a86fa466d7	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	14172341709	13723049083	415	20924904	2024-10-09T02:00:23.000Z	0x8c40984c75dcee2836413d250097c36e4bb398e86afdc0106700a87ef8d4152a

Example Query

Query with partition filter

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

USDVaultAccountant_ExchangeRateUpdated_event

Exchange rate update events from Ether.fi USD vault accounting contracts on Ethereum, capturing old and new rate values with precision timestamps. Used for tracking vault share price changes and yield accrual across multiple 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_oldRate`	`STRING`	Previous exchange rate before the update. Numeric string representation in ray units (27 decimals).
`in_newRate`	`STRING`	Updated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
`in_currentTime`	`STRING`	Unix timestamp representing the time when the exchange rate was updated. Numeric string in seconds since epoch.

Sample Data

address	removed	log_index	in_newRate	in_oldRate	block_number	in_currentTime	block_timestamp	transaction_hash
0x95fe19b324be69250138fe8ee50356e9f6d17cfe	false	143	1041848	1041745	22277701	1744760111	2025-04-15T23:35:11.000Z	0x339a775bcf77771914bfa7e3cb2cb11a439caf891065ac6b5753d01ed0cdc1bd
0xbae19b38bf727be64af0b578c34985c3d612e2ba	false	142	1019212261350570690	1019211263242673480	22277701	1744760111	2025-04-15T23:35:11.000Z	0x339a775bcf77771914bfa7e3cb2cb11a439caf891065ac6b5753d01ed0cdc1bd
0xc315d6e14ddcdc7407784e2caf815d131bc1d3e7	false	136	1089257	1089125	22277755	1744760759	2025-04-15T23:45:59.000Z	0xd72de518fbd905263866d75dc768fcec21f20a7c450ad69edc7d937f4e1b7dcc

Example Query

Query with partition filter

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

USDVaultAccountant_FeesClaimed_event

Fee claim events from EtherFi’s USD vault accountant contract on Ethereum, recording amounts and asset addresses (primarily USDC) when protocol fees are collected. Used to track revenue generation and fee distribution patterns across the EtherFi 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_feeAsset`	`STRING`	Contract address of the token in which fees are denominated. 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.

Sample Data

address	removed	in_amount	log_index	in_feeAsset	block_number	block_timestamp	transaction_hash
0xc315d6e14ddcdc7407784e2caf815d131bc1d3e7	false	62223430270	87	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	23233590	2025-08-27T16:16:23.000Z	0x04fd317d7882dca4361bc3b990a6be0b5d9fde503688f325c5d9ca5f3326388a
0xc315d6e14ddcdc7407784e2caf815d131bc1d3e7	false	45630791693	238	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	21949493	2025-03-01T04:01:23.000Z	0xc97324ab4db729b6e3f6734d664d74956473394a1115a7983d0633f12774fa19
0xc315d6e14ddcdc7407784e2caf815d131bc1d3e7	false	66083777208	170	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	23033075	2025-07-30T16:16:35.000Z	0xf261e9d9b882c7f4a770709fe5edd563d04495fa370b830b3f81d1350461ab01

Example Query

Query with partition filter

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

UsualVault_Enter_event

Deposit events into the Ether.fi UsualVault on Ethereum, recording asset amounts and vault shares minted to user accounts. Tracks inflows across multiple accepted assets including stablecoins (USDC) and yield-bearing tokens for analyzing vault TVL growth and user deposit 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. 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_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

in_to	address	in_from	removed	in_asset	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x007164ebbd0e29788307bb57398cca932c8c4c32	0xeda663610638e6557c27e2f4e973d3393e844e70	0x007164ebbd0e29788307bb57398cca932c8c4c32	false	0x35d8949372d46b7a3d5a56006ae77b215fc69bc0	425760412233386526501	423878367981903800329	176	20852790	2024-09-29T00:43:47.000Z	0x88de8214ada03a89a22e77b818529b89e568cf87bb6d9dd3fd43b72047fa2620
0x1a4b438447edc37ba37d8a6eb10cb4b772ad8e79	0xeda663610638e6557c27e2f4e973d3393e844e70	0x1a4b438447edc37ba37d8a6eb10cb4b772ad8e79	false	0x35d8949372d46b7a3d5a56006ae77b215fc69bc0	1999362079263537256065	1990524038431671912608	325	20852993	2024-09-29T01:24:23.000Z	0x5fa4399de8212628382f544417b6a73cf3bb941a4e26842eabb8cefdae234009
0x3c112e6f387a4d8e336c73ef74c9be51b01644a1	0xeda663610638e6557c27e2f4e973d3393e844e70	0x3c112e6f387a4d8e336c73ef74c9be51b01644a1	false	0x35d8949372d46b7a3d5a56006ae77b215fc69bc0	982861870683273271064	978517198232357320151	211	20857703	2024-09-29T17:10:47.000Z	0x18ed8bbecfbe7d63e0d7b6d44073e1a2608f15b9a3938726740aadcb04b23cec

Example Query

Query with partition filter

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

UsualVault_Exit_event

Withdrawal events from Ether.fi’s Usual Protocol vault on Ethereum, recording asset redemptions with share-to-asset conversion rates. Used for analyzing vault exit activity, redemption patterns, and tracking liquidity withdrawals across different underlying assets.

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_asset`	`STRING`	Contract address of the asset or token. 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`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

in_to	address	in_from	removed	in_asset	in_amount	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xf8553c8552f906c19286f21711721e206ee4909e	0xeda663610638e6557c27e2f4e973d3393e844e70	0x989468982b08aefa46e37cd0086142a86fa466d7	false	0x73a15fed60bf67631dc6cd7bc5b6e8da8190acf5	4244257334986874662900	3866857186680742157523	1595	22120597	2025-03-25T01:20:11.000Z	0xde7a702c2662eea981906d8b064db3ca206893080d03b057388a029f680b3b6a
0xf8553c8552f906c19286f21711721e206ee4909e	0xeda663610638e6557c27e2f4e973d3393e844e70	0x989468982b08aefa46e37cd0086142a86fa466d7	false	0x35d8949372d46b7a3d5a56006ae77b215fc69bc0	1786179211797656254568	1769469435115335942776	357	21038620	2024-10-24T23:02:59.000Z	0x81f7677e407ba5885041abcc4193f903db5b1b4c912a33419f6df06240b31dee
0xf8553c8552f906c19286f21711721e206ee4909e	0xeda663610638e6557c27e2f4e973d3393e844e70	0x989468982b08aefa46e37cd0086142a86fa466d7	false	0x35d8949372d46b7a3d5a56006ae77b215fc69bc0	16527862384796866429042	16323566921966185047430	445	21167724	2024-11-11T23:28:11.000Z	0x9390d0af84384ddf25b609b30f3a803f32c7c285bb2f44a9752ac7167b6102f7

Example Query

Query with partition filter

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

UsualVaultAccountant_ExchangeRateUpdated_event

Exchange rate update events from the Ether.fi Usual Vault accountant contract on Ethereum, tracking changes in the vault’s share-to-asset conversion rate over time. Used for calculating yield accrual and historical vault performance metrics.

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_oldRate`	`STRING`	Previous exchange rate before the update. Numeric string representation in ray units (27 decimals).
`in_newRate`	`STRING`	Updated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
`in_currentTime`	`STRING`	Unix timestamp representing the time when the exchange rate was updated. Numeric string in seconds since epoch.

Sample Data

address	removed	log_index	in_newRate	in_oldRate	block_number	in_currentTime	block_timestamp	transaction_hash
0x1d4f0f05e50312d3e7b65659ef7d06aa74651e0c	false	502	1001220292013216724	1000922991796502790	20687561	1725577547	2024-09-05T23:05:47.000Z	0xac52740441222ec2fcae060b81476123b02f55380fc59655b1f3ac4fae46ba73
0x1d4f0f05e50312d3e7b65659ef7d06aa74651e0c	false	628	1012762172032449057	1012526955922745537	21245999	1732311419	2024-11-22T21:36:59.000Z	0x622d56930430c44cf0b20e3c281804bd77bae69572f4c4f734fa2da8abcb02d5
0x1d4f0f05e50312d3e7b65659ef7d06aa74651e0c	false	264	1007461572423021723	1007108031357974863	20944715	1728677951	2024-10-11T20:19:11.000Z	0xcb2012d1df7112a39ea0359137f224192f644f33a82addc7e196c2ed5813d420

Example Query

Query with partition filter

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

UsualVaultAccountant_FeesClaimed_event

Fee claim events from the Usual Vault Accountant contract on Ether.fi’s Ethereum deployment. Tracks when fees are claimed from the vault, including the fee asset address and claimed amounts for protocol revenue 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_feeAsset`	`STRING`	Contract address of the token in which fees are denominated. 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.

Sample Data

address	removed	in_amount	log_index	in_feeAsset	block_number	block_timestamp	transaction_hash
0x1d4f0f05e50312d3e7b65659ef7d06aa74651e0c	false	57907089828994998865386	32	0x73a15fed60bf67631dc6cd7bc5b6e8da8190acf5	21676923	2025-01-22T02:04:23.000Z	0xae564a5a7844097acc780d19ac3668e9c7e672b85c5e7313ecbf0b66999f4beb

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BTCVault_Enter_event

BTCVault_Exit_event

BTCVaultAccountant_ExchangeRateUpdated_event

BTCVaultAccountant_FeesClaimed_event

EarlyAdopterPool_DepositERC20_event

EarlyAdopterPool_DepositEth_event

ETHFIRewards_Claimed_event

ETHVault_Enter_event

ETHVault_Exit_event

ETHVaultAccountant_ExchangeRateUpdated_event

ETHVaultAccountant_FeesClaimed_event

LiquidityPool_Deposit_event

LiquidityPool_deposit2_function

LiquidityPool_Withdraw_event

LiquidityPool_withdraw_function

LiquidityPoolImplementation_Deposit_event

UltraUSDVault_Enter_event

UltraUSDVault_Exit_event

UltraUSDVaultAccountant_ExchangeRateUpdated_event

UltraUSDVaultAccountant_FeesClaimed_event

USDVault_Enter_event

USDVault_Exit_event

USDVaultAccountant_ExchangeRateUpdated_event

USDVaultAccountant_FeesClaimed_event

UsualVault_Enter_event

UsualVault_Exit_event

UsualVaultAccountant_ExchangeRateUpdated_event

UsualVaultAccountant_FeesClaimed_event

​Tables

​BTCVault_Enter_event

​BTCVault_Exit_event

​BTCVaultAccountant_ExchangeRateUpdated_event

​BTCVaultAccountant_FeesClaimed_event

​EarlyAdopterPool_DepositERC20_event

​EarlyAdopterPool_DepositEth_event

​ETHFIRewards_Claimed_event

​ETHVault_Enter_event

​ETHVault_Exit_event

​ETHVaultAccountant_ExchangeRateUpdated_event

​ETHVaultAccountant_FeesClaimed_event

​LiquidityPool_Deposit_event

​LiquidityPool_deposit2_function

​LiquidityPool_Withdraw_event

​LiquidityPool_withdraw_function

​LiquidityPoolImplementation_Deposit_event

​UltraUSDVault_Enter_event

​UltraUSDVault_Exit_event

​UltraUSDVaultAccountant_ExchangeRateUpdated_event

​UltraUSDVaultAccountant_FeesClaimed_event

​USDVault_Enter_event

​USDVault_Exit_event

​USDVaultAccountant_ExchangeRateUpdated_event

​USDVaultAccountant_FeesClaimed_event

​UsualVault_Enter_event

​UsualVault_Exit_event

​UsualVaultAccountant_ExchangeRateUpdated_event

​UsualVaultAccountant_FeesClaimed_event

Tables

BTCVault_Enter_event

BTCVault_Exit_event

BTCVaultAccountant_ExchangeRateUpdated_event

BTCVaultAccountant_FeesClaimed_event

EarlyAdopterPool_DepositERC20_event

EarlyAdopterPool_DepositEth_event

ETHFIRewards_Claimed_event

ETHVault_Enter_event

ETHVault_Exit_event

ETHVaultAccountant_ExchangeRateUpdated_event

ETHVaultAccountant_FeesClaimed_event

LiquidityPool_Deposit_event

LiquidityPool_deposit2_function

LiquidityPool_Withdraw_event

LiquidityPool_withdraw_function

LiquidityPoolImplementation_Deposit_event

UltraUSDVault_Enter_event

UltraUSDVault_Exit_event

UltraUSDVaultAccountant_ExchangeRateUpdated_event

UltraUSDVaultAccountant_FeesClaimed_event

USDVault_Enter_event

USDVault_Exit_event

USDVaultAccountant_ExchangeRateUpdated_event

USDVaultAccountant_FeesClaimed_event

UsualVault_Enter_event

UsualVault_Exit_event

UsualVaultAccountant_ExchangeRateUpdated_event

UsualVaultAccountant_FeesClaimed_event