> ## 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_v2_ethereum
> Tables in tt-contracts.etherfi_v2_ethereum
## Tables
### ETHFIRewards\_Claimed\_event
ETHFI token reward claim events from the Ether.fi protocol. Records user reward withdrawals with account addresses, claimed amounts, and liquidity index snapshots at time of claim.
| Column | Type | Description |
| ------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_rootHash` | `STRING` | Merkle root hash used to verify the validity of the claimed reward in the EtherFi rewards distribution. This cryptographic proof ensures the claim matches the protocol's authorized reward allocation. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_balance` | `STRING` | Token balance amount involved in the operation. Numeric string representation in smallest denomination of the token. |
| address | in\_user | removed | in\_token | log\_index | in\_balance | in\_rootHash | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | -------------------- | ------------------------------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xf0164d48b308c42ae028e3379b2fb620e70f8780 | 0x65e51317b375126aa5ef46487952468a74bf792c | false | 0xfe0c30065b384f05761f15d0cc899d4f9f9cc0eb | 514 | 423691735269265264 | 0x11b66de50b9ce7b6ce8fa78d07c703067b2f2374c661b330c189cacc3b9cec87 | 19925749 | 2024-05-22T13:34:35.000Z | 0x38c9d322a9877460bc9e4e33898468021ab2c18c8334c4d2ad7987ee08e08e82 |
| 0xf0164d48b308c42ae028e3379b2fb620e70f8780 | 0x9feb65fd0d0c99948d2431af32f35a49e3d32366 | false | 0xfe0c30065b384f05761f15d0cc899d4f9f9cc0eb | 286 | 47406127274588456326 | 0x11b66de50b9ce7b6ce8fa78d07c703067b2f2374c661b330c189cacc3b9cec87 | 19928301 | 2024-05-22T22:07:35.000Z | 0x71d916b8d4ecf788e8565a97cb2a9063b8a0eafa2bde34411791b5957c9956ea |
| 0xf0164d48b308c42ae028e3379b2fb620e70f8780 | 0xeffa4f8eb89dbc672b4a0808777a0523b8e7b9cd | false | 0xfe0c30065b384f05761f15d0cc899d4f9f9cc0eb | 566 | 44733087598453095 | 0x11b66de50b9ce7b6ce8fa78d07c703067b2f2374c661b330c189cacc3b9cec87 | 19923978 | 2024-05-22T07:37:23.000Z | 0x00e5a5b505b00064d6beb227285215194c0fd799457cce59a75dd2461c8f8224 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v2_ethereum.ETHFIRewards_Claimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityPool\_Deposit\_event
Deposit events from Ether.fi v2 liquidity pool on Ethereum, capturing ETH deposits with depositor addresses, amounts in wei, referral codes, and source identifiers. Used for analyzing user acquisition, referral program effectiveness, and liquidity pool growth patterns.
| 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 | 10000000000000000 | 0x741da2bc4a54544f7a404e5f3ae7d3d7091b0300 | 1 | 275 | 0xb91279c54007f16f1ce04237daf6f14f1253fba1 | 19543075 | 2024-03-30T00:00:23.000Z | 0x3e52d8a96be5f715571c2864b5371b256988448709f557b0a47720ef33c96787 |
| 0x308861a430be4cce5502d0a12724771fc6daf216 | false | 10000000000000000 | 0x03c3ed52343aa71ad25c31964f624920fe5a7cde | 1 | 545 | 0x1c0393442c311dda007d0ef0e839c4d000cf5241 | 19543780 | 2024-03-30T02:22:59.000Z | 0x61439fc736656366c5658c723953f3ca0cacfd1f371bf158521e48d25fb8cb6d |
| 0x308861a430be4cce5502d0a12724771fc6daf216 | false | 10000000000000000 | 0x4dc5fadd25b80981f59a45c32b14fa0e55173a4e | 1 | 342 | 0x118ca9bf0168ac506c1ae3b62e6d954c8b99a424 | 19546884 | 2024-03-30T12:51:35.000Z | 0x2ead99ebf4e524bf26cafcb7bd067f5b41ff3404f1cc0974323c3674a2dbff8a |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v2_ethereum.LiquidityPool_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityPool\_deposit2\_function
ETH deposit transactions into EtherFi's LiquidityPool contract on Ethereum, tracking deposited amounts, receipt token shares, and referral addresses. Used for analyzing staking inflows, share pricing, and referral program activity.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__referral` | `STRING` | Address of the referrer who directed this deposit to the EtherFi liquidity pool. May be the depositor's own address if self-referred, as seen in some sample transactions. |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | value | status | gas\_used | out\_anon0 | signature | to\_address | block\_number | from\_address | in\_\_referral | trace\_address | block\_timestamp | transaction\_hash |
| ----- | ------------------ | ------ | --------- | ------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 79599 | 50000000000000000 | true | 70635 | 47937464845957767 | 0xf340fa01 | 0x308861a430be4cce5502d0a12724771fc6daf216 | 20313885 | 0x47587d8476cd8fa357c1b096d7d328f2d1af365a | 0xcabe7ddb088e47bf4291b42affb8fa261b75500a | | 2024-07-15T19:05:23.000Z | 0x44b7569697eda86606d9a4c0aa1b272da47ef70847fac8fc15b8ba61521836c2 |
| 90531 | 1000000000000000 | true | 87735 | 958786932987426 | 0xf340fa01 | 0x308861a430be4cce5502d0a12724771fc6daf216 | 20310885 | 0xded7a36d8752804219af1f4cb642e9593caf9e50 | 0xf8e17a0d41df702d9f9c9e906083c7e97236e5e2 | | 2024-07-15T09:01:35.000Z | 0x18a31e103ea330bbb103b0ee3f09cc2724a5cfd429a9bf38192feb327bc0abdb |
| 99584 | 653000000000000000 | true | 87735 | 626087867240789585 | 0xf340fa01 | 0x308861a430be4cce5502d0a12724771fc6daf216 | 20312387 | 0x84dc638c5e9b7ebb22572919f95237032dd69b52 | 0xf83434a19f67fcb65bc712e47642a76e3aae01ca | | 2024-07-15T14:03:47.000Z | 0x67e5cac37ccd37e0d453a99857dbd550fee8008e314bc705c8116d8372b6dc89 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v2_ethereum.LiquidityPool_deposit2_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityPool\_ProtocolFeePaid\_event
Protocol fee payment events from Etherfi v2 liquidity pools on Ethereum, recording fee amounts in wei collected by the protocol. Useful for tracking protocol revenue and fee accrual patterns over time.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_protocolFees` | `STRING` | Protocol fees collected by the platform from the transaction. Numeric string representation of the fee amount in the token's smallest unit. |
| address | removed | log\_index | block\_number | block\_timestamp | in\_protocolFees | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | -------------------- | ------------------------------------------------------------------ |
| 0x308861a430be4cce5502d0a12724771fc6daf216 | false | 346 | 21205041 | 2024-11-17T04:28:35.000Z | 4908184466997336737 | 0xd192b5fef8bfa7fd476b8a128cb9f53a960684f532e1d7b5611b2edd3aebb18d |
| 0x308861a430be4cce5502d0a12724771fc6daf216 | false | 230 | 22643937 | 2025-06-06T07:02:11.000Z | 12463289315882302510 | 0x4978ac7752f956b6f12dccac6c08cce713de99a332bcfba4bd6255b3b17e4eb8 |
| 0x308861a430be4cce5502d0a12724771fc6daf216 | false | 197 | 22646457 | 2025-06-06T15:31:35.000Z | 6145040701524539178 | 0x7afe45df8e2fc25c035685554cb86ae2cd53ccf60d36543645f4b1d813f3c7e7 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v2_ethereum.LiquidityPool_ProtocolFeePaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityPool\_Rebase\_event
Rebase events from EtherFi's Ethereum liquid staking pool tracking total ETH locked and eETH shares outstanding. Used to calculate the eETH/ETH exchange rate over time and analyze staking yield accrual.
| Column | Type | Description |
| -------------------- | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_totalEthLocked` | `STRING` | Total amount of ETH locked in the EtherFi liquidity pool at the time of rebase, denominated in wei (1e18 per ETH). Values typically range in the trillions of wei, representing billions of ETH in protocol reserves. |
| `in_totalEEthShares` | `STRING` | Total shares of eETH (ether.fi's liquid staking token) in the liquidity pool at the time of rebase. Denominated in wei (1e18 = 1 eETH share), this value tracks proportional ownership of the underlying staked ETH. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_totalEthLocked | in\_totalEEthShares |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------- | ------------------------- |
| 0x308861a430be4cce5502d0a12724771fc6daf216 | false | 140 | 21770497 | 2025-02-04T03:35:35.000Z | 0x043d9ae9877f31cffdaa285fc1bd15753fe3089a16674acaf23dbec65b5f7a70 | 2276559382256456385031348 | 2149143804062918443968233 |
| 0x308861a430be4cce5502d0a12724771fc6daf216 | false | 16 | 21769858 | 2025-02-04T01:27:35.000Z | 0xeafd9192425bf1a8602251a8f30a31204a84e35c151f5502d2fd9cc7ec887542 | 2276819435489926728820632 | 2149414056435881120255076 |
| 0x308861a430be4cce5502d0a12724771fc6daf216 | false | 259 | 21776201 | 2025-02-04T22:45:11.000Z | 0x9d3e52f58c40c684a2e6e9e0815b583ae5050ce5e06927f98c7e8fc2804c0643 | 2265032963604219892902746 | 2138040303005205435717958 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v2_ethereum.LiquidityPool_Rebase_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityPool\_Withdraw\_event
Withdrawal events from Ether.fi v2 liquidity pool on Ethereum, recording amount, sender, recipient, and source type for each withdrawal transaction. Useful for tracking liquidity exits and user withdrawal patterns from the Ether.fi staking protocol.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_source` | `INT64` | Source chain identifier for the cross-chain operation. String format following the pattern "CHAINTYPE-CHAINID" (e.g., "EVM-1" for Ethereum, "EVM-56" for BSC). |
| address | removed | in\_amount | in\_sender | in\_source | log\_index | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------ | ------------------------------------------ | ---------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x308861a430be4cce5502d0a12724771fc6daf216 | false | 204106807586726632 | 0xa9a3ef65279ed3fde306b1d0a96617951b0d4ee4 | 1 | 215 | 18647496 | 0xa9a3ef65279ed3fde306b1d0a96617951b0d4ee4 | 2023-11-25T08:23:35.000Z | 0xda5af466e72f168b1850964c848561f5f3c1181706d588727f6ecc77244f0bb8 |
| 0x308861a430be4cce5502d0a12724771fc6daf216 | false | 100016963480869484 | 0x83037d633813d101299a84e5b131e19305fdfd1d | 1 | 209 | 18647818 | 0x83037d633813d101299a84e5b131e19305fdfd1d | 2023-11-25T09:28:35.000Z | 0x0b15e79ecd5c0e9083684445c710528d600123b458123eb370f83731a24b5016 |
| 0x308861a430be4cce5502d0a12724771fc6daf216 | false | 110018659828956433 | 0xc13456a34305e9265e907f70f76b1ba6e2055c8b | 1 | 210 | 18647721 | 0xc13456a34305e9265e907f70f76b1ba6e2055c8b | 2023-11-25T09:08:59.000Z | 0xc6fba36f118d8f4ae71bab34451a359e016c4fe4c61958b8c70dbe1bdd0286ea |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v2_ethereum.LiquidityPool_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### LiquidityPool\_withdraw\_function
Withdraw function call records from Ether.fi v2 LiquidityPool contract on Ethereum, tracking liquidity removals with withdrawal amounts and recipient addresses. Useful for analyzing user withdrawal patterns and liquidity pool outflows.
| Column | Type | Description |
| ------------------ | ----------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `trace_address` | `STRING` | Hierarchical position of the internal call within a transaction's execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls. |
| `status` | `BOOL` | Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution. |
| `from_address` | `STRING` | Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `to_address` | `STRING` | Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string. |
| `value` | `FLOAT64` | Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC). |
| `gas_used` | `INT64` | Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used. |
| `gas` | `INT64` | Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed. |
| `signature` | `STRING` | Function selector identifying which contract function was called. 10-character hex string including 0x prefix. |
| `in__recipient` | `STRING` | Address designated to receive the assets or proceeds from the transaction. Hex-encoded, 0x-prefixed, 42-character string. |
| `in__amount` | `STRING` | Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens). |
| `out_anon0` | `STRING` | Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination. |
| gas | value | status | gas\_used | out\_anon0 | signature | in\_\_amount | to\_address | block\_number | from\_address | in\_\_recipient | trace\_address | block\_timestamp | transaction\_hash |
| ----- | ----- | ------ | --------- | ---------- | ---------- | ------------------ | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------------------------ | -------------- | ------------------------ | ------------------------------------------------------------------ |
| 35962 | 0 | true | 32616 | | 0xf3fef3a3 | 500142290808855981 | 0x308861a430be4cce5502d0a12724771fc6daf216 | 18326648 | 0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000 | 0x173863cf3befe457cf248857b673402beb82fcdf | 0,16 | 2023-10-11T10:37:11.000Z | 0x3b1ed43ccc1b4eaa5ba685a670065b881d83b14a76967908a21f37a02ff7355c |
| 35962 | 0 | true | 32616 | | 0xf3fef3a3 | 49580953520771913 | 0x308861a430be4cce5502d0a12724771fc6daf216 | 18329640 | 0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000 | 0xdc11ca422d5b30726a0e0b88df060dcdd2524f09 | 0,16 | 2023-10-11T20:41:47.000Z | 0x054f5b12c8cdbec5e5e2866922c33f01ed794d0eb0563345529820fbe9d1c0ab |
| 35962 | 0 | true | 32616 | | 0xf3fef3a3 | 501447200181156725 | 0x308861a430be4cce5502d0a12724771fc6daf216 | 18326635 | 0x3d320286e014c3e1ce99af6d6b00f0c1d63e3000 | 0x2fa4e80b8d39f29f5ea746bad3c1840fb56cf47b | 0,16 | 2023-10-11T10:34:35.000Z | 0x81af4b7ebac9cfc139f48ccbff459861818624bc93f9d695341c2b8e92b1f09e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v2_ethereum.LiquidityPool_withdraw_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***