> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# etherfi_v1_ethereum
> Tables in tt-contracts.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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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` | 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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). |
| gas | value | status | gas\_used | signature | in\_\_amount | to\_address | block\_number | from\_address | in\_\_recipient | trace\_address | block\_timestamp | transaction\_hash |
| ------ | ----- | ------ | --------- | ---------- | ------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 101628 | 0 | true | 38396 | 0xf3fef3a3 | 98357156303670418 | 0x308861a430be4cce5502d0a12724771fc6daf216 | 22496884 | 0xdadef1ffbfeaab4f68a9fd181395f68b4e4e7ae0 | 0xdadef1ffbfeaab4f68a9fd181395f68b4e4e7ae0 | 0,11 | 2025-05-16T16:42:47.000Z | 0xab23e31fff2bb8a953bf78084c59afd756ff7f50735c49facb5109c3d1a66948 |
| 109560 | 0 | true | 38396 | 0xf3fef3a3 | 102682357039382448 | 0x308861a430be4cce5502d0a12724771fc6daf216 | 22496416 | 0xdadef1ffbfeaab4f68a9fd181395f68b4e4e7ae0 | 0xdadef1ffbfeaab4f68a9fd181395f68b4e4e7ae0 | 0,11 | 2025-05-16T15:07:11.000Z | 0x31a5293b725d8651243b52a86ebde263a76be08819837bbd4093693745db30cc |
| 191425 | 0 | true | 38396 | 0xf3fef3a3 | 104987353069899072 | 0x308861a430be4cce5502d0a12724771fc6daf216 | 22496871 | 0xdadef1ffbfeaab4f68a9fd181395f68b4e4e7ae0 | 0xdadef1ffbfeaab4f68a9fd181395f68b4e4e7ae0 | 0,11 | 2025-05-16T16:40:11.000Z | 0xf24b724359d4110b464078577198eda85119d7d6871b7c5c29329c7e9c2942a1 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
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.
| 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. |
| 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 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_ethereum.UsualVaultAccountant_FeesClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***