> ## 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_scroll
> Tables in tt-contracts.etherfi_v1_scroll
## Tables
### BeaconProxy\_BeaconUpgraded\_event
Beacon proxy upgrade events from Ether.fi protocol on Scroll, recording when proxy contracts update their implementation beacon address. Used for tracking contract upgrades and implementation changes across the protocol's proxy infrastructure.
| 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_beacon` | `STRING` | Contract address of the beacon proxy implementation contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_beacon | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x22f2666bceafbd1b8f984d842b01c6182db3dceb | false | 0x48e1630278d8310c86650405ebfbc110cdf3d1ec | 0 | 14809125 | 2025-04-17T16:31:41.000Z | 0xaa4555ac8de2d6e31b4305dd26c3f0df4d3b769e44b40f77939bcec9a51b84f6 |
| 0xf6a7ecb90516be197ee040f4ab17007b9defcf44 | false | 0x48e1630278d8310c86650405ebfbc110cdf3d1ec | 0 | 14813251 | 2025-04-17T20:55:47.000Z | 0x91fe521a4ab83694ad6b502a35a8a015fa08205584f308600a9dea726de6733b |
| 0x4b64bc16d9bf09f2e25f14203538b6da86288022 | false | 0x48e1630278d8310c86650405ebfbc110cdf3d1ec | 0 | 14796835 | 2025-04-17T04:06:51.000Z | 0xf785b9adf21d26da6601c08afda3fcbc13df1bbbf2a265ff44701edfebab5aa0 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.BeaconProxy_BeaconUpgraded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_BorrowApySet\_event
Event log tracking borrow Annual Percentage Yield (APY) updates for specific tokens in Ether.fi's CashDebitCore contract on Scroll. Captures APY rate changes with old and new values for analyzing lending rate dynamics and protocol parameter adjustments.
| 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_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldApy` | `STRING` | Annual Percentage Yield (APY) for borrowing the specified token before this update event, expressed in basis points with high precision. The value represents the previous borrow rate that was replaced by the new APY in this transaction. |
| `in_newApy` | `STRING` | Annual percentage yield (APY) for borrowing the specified token after the update event. Expressed as a scaled integer where the actual APY percentage requires dividing by a protocol-specific scaling factor (typically 1e10 or 1e12). |
| address | removed | in\_token | in\_newApy | in\_oldApy | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------ | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 126839167935 | 1 | 2 | 16696599 | 2025-06-24T00:47:25.000Z | 0xdd46340f8e1eb134d35efb4c2d9e751b3768a7fa01bdbc8e9ed9ba62058e5ae5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_BorrowApySet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_Borrowed\_event
Borrow event logs from Etherfi's CashDebitCore contract on Scroll, capturing user addresses, token addresses, and borrowed amounts for each transaction. Useful for tracking lending activity and debt positions within Etherfi's credit 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_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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_user | removed | in\_token | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | 0x0293716e015090cbc55099987ce5d8c030717b60 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 5990000 | 2 | 16509449 | 2025-06-16T10:53:54.000Z | 0x49ec6f3ed3b9154e0a823fffbc452f0411e440f2addf7b9bf8817bf615620094 |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | 0x0293716e015090cbc55099987ce5d8c030717b60 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 4410000 | 2 | 16508548 | 2025-06-16T10:07:20.000Z | 0x175ec4a9419101af89112a8f578f9cd91144d38d6032019dcbfee68f419259b5 |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | 0x0293716e015090cbc55099987ce5d8c030717b60 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 4000000 | 2 | 16503507 | 2025-06-16T04:42:00.000Z | 0x05536b0a18ad5853ae4dac3de7ebb83055abb8301a0ab2611b3150895a6e0da3 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_Borrowed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_BorrowTokenAdded\_event
Event logs tracking tokens added to the borrow whitelist in Ether.fi's CashDebitCore contract on Scroll. Used for monitoring which tokens become available for borrowing and protocol configuration changes 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_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_token | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 0xf55bec9cafdbe8730f096aa55dad6d22d44099df | 12 | 18013455 | 2025-07-31T23:43:36.000Z | 0xc8ae2cde33d86e12185859c82630e99ff42bb3a8d44898d82b6f8444c8fed74a |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 2 | 14207005 | 2025-03-24T18:20:31.000Z | 0xa1d522ed85b378bfcbdb590f7fe1141152caa83dad32e5565f722dfc29cb0bbc |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 0x08c6f91e2b681faf5e17227f2a44c307b3c1364c | 10 | 14536675 | 2025-04-07T23:20:23.000Z | 0xa5dbd9940718c36dc820b438837d1e9aace4cdca8164905e4b2551c7f3b76fa1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_BorrowTokenAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_BorrowTokenConfigSet\_event
Configuration update events for borrowable tokens in Ether.fi's Cash Debit lending protocol on Scroll. Tracks parameter changes including borrow APY (annual percentage yield), minimum shares, interest rate snapshots, and total borrowed amounts for each token address.
| 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_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_config` | `STRUCT` | Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address. |
| address | removed | in\_token | in\_config | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | \{"borrowApy":"1","minShares":"10000000","lastUpdateTimestamp":"1742840431","interestIndexSnapshot":"1000000000000000000","totalSharesOfBorrowTokens":"0","totalNormalizedBorrowingAmount":"0"} | 3 | 14207005 | 2025-03-24T18:20:31.000Z | 0xa1d522ed85b378bfcbdb590f7fe1141152caa83dad32e5565f722dfc29cb0bbc |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 0xf55bec9cafdbe8730f096aa55dad6d22d44099df | \{"borrowApy":"1","minShares":"340282366920938463463374607431768211455","lastUpdateTimestamp":"1754005416","interestIndexSnapshot":"1000000000000000000","totalSharesOfBorrowTokens":"0","totalNormalizedBorrowingAmount":"0"} | 13 | 18013455 | 2025-07-31T23:43:36.000Z | 0xc8ae2cde33d86e12185859c82630e99ff42bb3a8d44898d82b6f8444c8fed74a |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 0x08c6f91e2b681faf5e17227f2a44c307b3c1364c | \{"borrowApy":"1585489599188","minShares":"340282366920938463463374607431768211455","lastUpdateTimestamp":"1744068023","interestIndexSnapshot":"1000000000000000000","totalSharesOfBorrowTokens":"0","totalNormalizedBorrowingAmount":"0"} | 11 | 14536675 | 2025-04-07T23:20:23.000Z | 0xa5dbd9940718c36dc820b438837d1e9aace4cdca8164905e4b2551c7f3b76fa1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_BorrowTokenConfigSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_BorrowTokenRemoved\_event
*No description available.*
| 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_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_BorrowTokenRemoved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_CollateralTokenAdded\_event
Event log tracking collateral token additions and removals in Etherfi's Cash Debit Core contract on Scroll. Records token addresses whitelisted for collateral use, enabling analysis of accepted asset types 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_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_token | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 0x657e8c867d8b37dcc18fa4caead9c45eb088c642 | 2 | 14620798 | 2025-04-10T21:26:37.000Z | 0x1dbb711095d6efd98192f9fee8fc8c8ff806e2d1835f51d673812013c0d17744 |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 0x5300000000000000000000000000000000000004 | 8 | 14772923 | 2025-04-16T04:12:56.000Z | 0x9c50dec78bcc0d91a8d9475b8dfe0b385c99ba410c6f551d6fb9bbd3d4f9db0e |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 0xf0bb20865277abd641a307ece5ee04e79073416c | 18 | 14316414 | 2025-03-30T16:53:51.000Z | 0xff9ec652e7e7399cadfbfa5c193a18a69c819f46da8ee2ed42ef113a0b6a87ec |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_CollateralTokenAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_CollateralTokenConfigSet\_event
Configuration change events for collateral tokens in Ether.fi's CashDebit protocol on Scroll, tracking loan-to-value (LTV), liquidation threshold, and liquidation bonus parameter updates. Useful for monitoring risk parameter adjustments and governance decisions affecting lending markets.
| 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_collateralToken` | `STRING` | Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldConfig` | `STRUCT` | Nested record containing the previous collateral risk parameters (LTV, liquidation threshold, liquidation bonus) before the configuration update. Values are typically zero when a collateral token is first added to the protocol. |
| `in_newConfig` | `STRUCT` | New configuration parameters applied after the update. Struct containing protocol-specific settings such as risk parameters, fees, or contract roles. |
| address | removed | log\_index | block\_number | in\_newConfig | in\_oldConfig | block\_timestamp | transaction\_hash | in\_collateralToken |
| ------------------------------------------ | ------- | ---------- | ------------- | ---------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 1 | 14207003 | \{"ltv":"50000000000000000000","liquidationBonus":"1000000000000000000","liquidationThreshold":"80000000000000000000"} | \{"ltv":"0","liquidationBonus":"0","liquidationThreshold":"0"} | 2025-03-24T18:20:14.000Z | 0x4a6c3e1c3c8b438b074932417e7bc5cb4782401b9db3a68d1bb824e91867918e | 0x01f0a31698c4d065659b9bdc21b3610292a1c506 |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 1 | 14207005 | \{"ltv":"50000000000000000000","liquidationBonus":"1000000000000000000","liquidationThreshold":"80000000000000000000"} | \{"ltv":"0","liquidationBonus":"0","liquidationThreshold":"0"} | 2025-03-24T18:20:31.000Z | 0x66e3bbcbb1b7e1ecdded891019fafc3935f50e95813f9cc370b51be84e2f81fc | 0xd29687c813d741e2f938f4ac377128810e217b1b |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 6 | 14207002 | \{"ltv":"90000000000000000000","liquidationBonus":"1000000000000000000","liquidationThreshold":"95000000000000000000"} | \{"ltv":"0","liquidationBonus":"0","liquidationThreshold":"0"} | 2025-03-24T18:20:11.000Z | 0xaac4eab6c2ef9c8efb319bcb1929ed47775ac21bc10468ab94722072fa82f68b | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_CollateralTokenConfigSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_CollateralTokenRemoved\_event
*No description available.*
| 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_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_CollateralTokenRemoved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_InterestIndexUpdated\_event
Interest rate index updates from EtherFi's lending protocol on Scroll, tracking accrued interest changes for borrowed tokens. Enables calculation of interest accumulation rates and borrowing costs 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_borrowToken` | `STRING` | Contract address of the token being borrowed. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldIndex` | `STRING` | Previous interest rate index value for the borrow token before the update. Stored as a high-precision integer with 18 decimal places (e.g., 1000000000000048826 represents 1.000000000000048826). |
| `in_newIndex` | `STRING` | Updated accrued interest index for the borrow token, represented as an 18-decimal fixed-point number. Values typically increase over time as interest accumulates on outstanding debt positions. |
| address | removed | log\_index | in\_newIndex | in\_oldIndex | block\_number | in\_borrowToken | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------- | ------------------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 1 | 1000000000000006731 | 1000000000000006214 | 14351942 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 2025-04-01T13:23:40.000Z | 0xbad0f7794e8b6ef99f92c7c9db8fe853147dc382b5a9d4a158b275e906565f0b |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 0 | 1000000000000048831 | 1000000000000048826 | 15760457 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 2025-05-22T00:08:02.000Z | 0xc76e029bdc46c084a01cb20b9db59b53c702bb1fe57e32276f6b528106f5aa44 |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 0 | 1000000000000048834 | 1000000000000048831 | 15760605 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 2025-05-22T00:13:39.000Z | 0xbf4b8e034962d3989ed890e50701cdae84493557809b9d1d001340f3d9629af1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_InterestIndexUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_Liquidated\_event
Liquidation events from Ether.fi's CashDebitCore lending protocol on Scroll, recording debt positions closed by liquidators when users fall below collateralization thresholds. Tracks debt amounts liquidated, collateral seized, and liquidation bonuses paid across multiple token types for analyzing protocol risk and liquidator profitability.
| 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_liquidator` | `STRING` | Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_debtTokenToLiquidate` | `STRING` | Contract address of the debt token being liquidated in this event. Hex-encoded, 0x-prefixed 40-character string representing the EVM token on Scroll that the liquidator is repaying on behalf of the under-collateralized user. |
| `in_userCollateralLiquidated` | `ARRAY>` | Array of collateral tokens seized from the user during liquidation, with each entry containing the token address, amount liquidated, and liquidation bonus awarded to the liquidator. Typically includes multiple token entries, where most have zero values and one or two contain the actual seized amounts. |
| `in_beforeDebtAmount` | `STRING` | User's total debt amount in the specified debt token before the liquidation event occurred. Denominated in the smallest unit of the debt token (e.g., wei for ETH-based tokens). |
| `in_debtAmountLiquidated` | `STRING` | Amount of debt liquidated in this transaction, denominated in the smallest unit of the debt token. Represents up to 50% of the user's total debt based on sample values showing liquidations typically at or near half of beforeDebtAmount. |
| address | in\_user | removed | log\_index | block\_number | in\_liquidator | block\_timestamp | transaction\_hash | in\_beforeDebtAmount | in\_debtAmountLiquidated | in\_debtTokenToLiquidate | in\_userCollateralLiquidated |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | -------------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | 0xddf5b664827331097b0ba8c84c29a60bee396da8 | false | 4 | 25445639 | 0xa14e9044dd9010b4677f77d41d8a3a4492789103 | 2025-11-25T19:39:03.000Z | 0x77eceaef42714c4afeef2a913b77c5bea8a1c9b291b1d436c696a86cedd2c050 | 29874954 | 14937477 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | \[\{"token":"0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4","amount":"0","liquidationBonus":"0"},\{"token":"0xf55bec9cafdbe8730f096aa55dad6d22d44099df","amount":"0","liquidationBonus":"0"},\{"token":"0x08c6f91e2b681faf5e17227f2a44c307b3c1364c","amount":"0","liquidationBonus":"0"},\{"token":"0x939778d83b46b456224a33fb59630b11dec56663","amount":"0","liquidationBonus":"0"},\{"token":"0x01f0a31698c4d065659b9bdc21b3610292a1c506","amount":"0","liquidationBonus":"0"},\{"token":"0x5300000000000000000000000000000000000004","amount":"0","liquidationBonus":"0"},\{"token":"0x657e8c867d8b37dcc18fa4caead9c45eb088c642","amount":"0","liquidationBonus":"0"},\{"token":"0x5f46d540b6ed704c3c8789105f30e075aa900726","amount":"0","liquidationBonus":"0"},\{"token":"0xf0bb20865277abd641a307ece5ee04e79073416c","amount":"0","liquidationBonus":"0"},\{"token":"0xd83e3d560ba6f05094d9d8b3eb8aaea571d1864e","amount":"0","liquidationBonus":"0"},\{"token":"0xa519afbc91986c0e7501d7e34968fee51cd901ac","amount":"0","liquidationBonus":"0"},\{"token":"0x056a5fa5da84ceb7f93d36e545c5905607d8bd81","amount":"0","liquidationBonus":"0"},\{"token":"0xd29687c813d741e2f938f4ac377128810e217b1b","amount":"161017070979796320630","liquidationBonus":"7667479570466491458"}] |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | 0xc0f4aab8ba7bedf9f672908482e1d1cd8acfc3a7 | false | 7 | 26844361 | 0xea3bdf1c8f5fd165653b2773960f10e26865cd34 | 2025-12-19T14:34:55.000Z | 0x4c9b81527221ecec21d3e0409d11166b53a2b5384e9e10644589aa0c80185920 | 8567666 | 4283833 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | \[\{"token":"0xd29687c813d741e2f938f4ac377128810e217b1b","amount":"2150554845312923698","liquidationBonus":"102407373586329700"},\{"token":"0x5300000000000000000000000000000000000004","amount":"1443298438671448","liquidationBonus":"48807193578261"}] |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | 0xd76a3b1a67cc3374ec5070b6c5fda8834982850d | false | 6 | 26844364 | 0xea3bdf1c8f5fd165653b2773960f10e26865cd34 | 2025-12-19T14:35:01.000Z | 0xa0043bee2f4f09bd9075bf2a824cb0a27f45b75cc1a6ae6ed089f6bbb687fc2d | 101871083 | 50935541 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | \[\{"token":"0x01f0a31698c4d065659b9bdc21b3610292a1c506","amount":"16382177069839540","liquidationBonus":"553986664197472"}] |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_Liquidated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_Repaid\_event
Debt repayment events from Ether.fi's Cash system on Scroll, tracking when users repay borrowed tokens. Records payer addresses, token contracts, and repayment amounts for analyzing borrowing behavior and protocol utilization.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_payer` | `STRING` | Address of the account that provided the funds for the repayment or payment transaction. 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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_user | removed | in\_payer | in\_token | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | 0x010a4123b698d53ebcbecca06498bab1eae4f4f1 | false | 0x010a4123b698d53ebcbecca06498bab1eae4f4f1 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 48306000 | 3 | 18558478 | 2025-08-07T07:07:54.000Z | 0x94a3dbc9f380d35e82cf93d97a5b9c32bd2647ef2636f8ecbaaa5483a101c06d |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | 0x044e6fea53cfa7ef2bb949b65c383690226c0d0a | false | 0x044e6fea53cfa7ef2bb949b65c383690226c0d0a | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 9055372 | 3 | 18607609 | 2025-08-07T20:46:46.000Z | 0x74658c09c526f8d2cfbc7b4f5c1b9951fc368522f92846ee31569231afe41df8 |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | 0x1168702c0cc40bcfbd6ed81414a25a38b1810d26 | false | 0x1168702c0cc40bcfbd6ed81414a25a38b1810d26 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 225173262 | 3 | 18585052 | 2025-08-07T14:30:49.000Z | 0x921fcc229842e139351821baf8f098446fa812677e02e49f5c25082f5ddb4dc8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_Repaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_Supplied\_event
Token supply events from Ether.fi's CashDebitCore contract on Scroll, capturing when users deposit tokens into the protocol. Records user addresses, token contracts, supplied amounts, and sender information for tracking liquidity provision and user participation.
| 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_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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_user | removed | in\_token | in\_amount | in\_sender | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | 0x86fbaeb3d6b5247f420590d303a6ffc9cd523790 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 300000000000 | 0x86fbaeb3d6b5247f420590d303a6ffc9cd523790 | 3 | 17590034 | 2025-07-25T03:32:12.000Z | 0x576136edeaa8a91336bde238fe37cc2207c46489fe151a27f474e512c15bf670 |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | 0x86fbaeb3d6b5247f420590d303a6ffc9cd523790 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 150000000000 | 0x86fbaeb3d6b5247f420590d303a6ffc9cd523790 | 3 | 16228584 | 2025-06-04T20:57:32.000Z | 0x70d6f9ad17d657dc4cec8ab03ae21e7fae304dcbb0698432799e112e792a176e |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | 0x86fbaeb3d6b5247f420590d303a6ffc9cd523790 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 300000000000 | 0x86fbaeb3d6b5247f420590d303a6ffc9cd523790 | 3 | 18102711 | 2025-08-02T00:31:12.000Z | 0x5a12a617b0b76107e1d2de6f7c4df2c663f93c0347b84768801d9221f3b6792c |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_Supplied_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_TotalBorrowingUpdated\_event
*No description available.*
| 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_borrowToken` | `STRING` | Contract address of the token being borrowed. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_totalBorrowingAmtBeforeInterest` | `STRING` | - |
| `in_totalBorrowingAmtAfterInterest` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_TotalBorrowingUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_Unpaused\_event
*No description available.*
| 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_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_Unpaused_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_Upgraded\_event
Contract upgrade events for Ether.fi's CashDebitCore protocol on Scroll, tracking implementation address changes from proxy upgrades. Useful for monitoring protocol version deployments and identifying active contract implementations across different time periods.
| 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_implementation` | `STRING` | Contract address of the implementation contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_implementation |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 2 | 14772923 | 2025-04-16T04:12:56.000Z | 0x9c50dec78bcc0d91a8d9475b8dfe0b385c99ba410c6f551d6fb9bbd3d4f9db0e | 0x87f2304320b7ca0926071297c2f85932daad2234 |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 4 | 16722063 | 2025-06-25T04:20:09.000Z | 0xe37ede21dbb5d0e7ba38d3a3b55b0cb674f00872935567a0fe0af6ccc28e3e17 | 0x1f17d9530447fab071a8b3dadde1e0604483ca1b |
| 0x0078c5a459132e279056b2371fe8a8ec973a9553 | false | 1 | 15342380 | 2025-05-10T17:27:09.000Z | 0x3728450130c4b47d3137b670b8150e4d3811a334dc619a86a9831b187a1b3442 | 0x5c6d50ce0b8c401f9718c8c98272235e1c2bfadc |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_Upgraded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_UserInterestAdded\_event
*No description available.*
| Column | Type | Description |
| ------------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_borrowingAmtBeforeInterest` | `STRING` | - |
| `in_borrowingAmtAfterInterest` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_UserInterestAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashDebitCore\_WithdrawBorrowToken\_event
*No description available.*
| 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_withdrawer` | `STRING` | Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_borrowToken` | `STRING` | Contract address of the token being borrowed. 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashDebitCore_WithdrawBorrowToken_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashEventEmitter\_RepayDebtManager\_event
Debt repayment events from EtherFi's Cash protocol on Scroll, tracking when users repay borrowed positions through their safe contracts. Contains repayment amounts in both token and USD values for analyzing lending activity and user debt management behavior.
| 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_userSafe` | `STRING` | User-owned safe contract address. 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_debtAmount` | `STRING` | Amount of debt denominated in the smallest unit of the token. Represented as a numeric string without decimal formatting. |
| `in_debtAmountInUsd` | `STRING` | USD-denominated value of the debt being repaid in this transaction. Stored as a string representing the amount in smallest unit (likely scaled by token decimals). |
| address | removed | in\_token | log\_index | in\_userSafe | block\_number | in\_debtAmount | block\_timestamp | transaction\_hash | in\_debtAmountInUsd |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x380b2e96799405be6e3d965f4044099891881acb | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 6 | 0x058848fe28834a3e0f9b131db4222c6045d9fe76 | 17519017 | 55971060 | 2025-07-23T10:36:22.000Z | 0x4471432c4730521ca3f5a7a01cb8345b900cb6a5a3ba55d52f9874abde8d81b4 | 55971060 |
| 0x380b2e96799405be6e3d965f4044099891881acb | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 6 | 0x07f5a94845eba8a31cd5846a84c3aa17fe066f00 | 17519261 | 536150574 | 2025-07-23T10:47:25.000Z | 0x27f4549dda61fab65900496456480d704b4211d879e35ec9246f5e3f168aa3d6 | 536150574 |
| 0x380b2e96799405be6e3d965f4044099891881acb | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 6 | 0x0a600d5952fec815a34c7afb190d5c9f7b2de213 | 17542170 | 2127830623 | 2025-07-23T23:09:21.000Z | 0xba90920b670efcbb14bb89bb6172dc8b370da9bb4c1b9632351988ea4e9ffb20 | 2127830623 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashEventEmitter_RepayDebtManager_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashEventEmitter\_Spend\_event
Token spending events emitted by the CashEventEmitter contract, recording outflows from user safe addresses with token amounts and USD valuations. Tracks operational mode, transaction identifiers, and sponsor flags for spend transaction 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_userSafe` | `STRING` | User-owned safe contract address. 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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amountInUsd` | `STRING` | USD-denominated value of the input amount. Numeric string representation in smallest unit (e.g., cents or basis points). |
| `in_mode` | `INT64` | Operational mode identifier for the transaction or instruction. Integer or string value specifying the configuration, action type, or execution variant being performed. |
| address | in\_mode | removed | in\_token | in\_amount | log\_index | in\_userSafe | block\_number | in\_amountInUsd | block\_timestamp | transaction\_hash |
| ------------------------------------------ | -------- | ------- | ------------------------------------------ | ---------- | ---------- | ------------------------------------------ | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x380b2e96799405be6e3d965f4044099891881acb | 1 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 10810000 | 7 | 0x4ecf024b92f36c27f487dcb88cf109a6704ed643 | 14287858 | 10810000 | 2025-03-29T00:31:55.000Z | 0xf7b5f16b8f3424817a44646f3bf5db6761481c07dcd468aefc8fb2359ba20fe1 |
| 0x380b2e96799405be6e3d965f4044099891881acb | 1 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 1000000 | 4 | 0x4ecf024b92f36c27f487dcb88cf109a6704ed643 | 14210190 | 1000000 | 2025-03-24T22:21:03.000Z | 0x98d4eb5e9c0e1611028402ab9535435def3a583ea0741a014d4e42bf15228f7b |
| 0x380b2e96799405be6e3d965f4044099891881acb | 1 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 1000000 | 4 | 0x4ecf024b92f36c27f487dcb88cf109a6704ed643 | 14211164 | 1000000 | 2025-03-24T23:17:25.000Z | 0xae190ab74e1c7e25f5ab464f5b01a03066f7432271f089405eadd4073dc8d6b5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashEventEmitter_Spend_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### CashFactory\_BeaconProxyDeployed\_event
Beacon proxy deployment events from Ether.fi's Cash product factory contract on Scroll, recording each new proxy instance created with its deployed address and unique salt identifier. Used for tracking Cash account creation and analyzing protocol 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_salt` | `STRING` | Cryptographic salt value used for deterministic address generation in contract deployment. 66-character hex string including 0x prefix. |
| `in_deployed` | `STRING` | Contract address of the newly deployed beacon proxy instance created by the EtherFi CashFactory contract. Hex-encoded, 0x-prefixed 40-character string representing the deployed proxy contract on Scroll. |
| address | in\_salt | removed | log\_index | in\_deployed | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0xf4e147db314947fc1275a8cbb6cde48c510cd8cf | 0x771f653208559b920ba8ebc173268cbd33d0f2caccf230028f9c7f52cbaf43d3 | false | 7 | 0x700af8c9684bdf712329e06439ec6ed643217356 | 16902042 | 2025-07-02T01:45:18.000Z | 0x3703ba43a35d22041bc43e86064b4de443e1b9983d371b82bfcee344d00eec7a |
| 0xf4e147db314947fc1275a8cbb6cde48c510cd8cf | 0xe9608867839e814786d3ad22a955fc23826cf50405cfd38d921e4d86e2a461e6 | false | 7 | 0x46f43bd15c13bc23b4c19562b860948a1fd3735e | 16915871 | 2025-07-02T14:39:53.000Z | 0x503ba2b6837fa0ad5e3dca7f16a96ba752563341a689f060120afabc2484fe40 |
| 0xf4e147db314947fc1275a8cbb6cde48c510cd8cf | 0x66ce8701b5a2e0d4d5ead6197ceeef28f1d47df954d178303504cc8f9892b3d7 | false | 7 | 0xc2087b546fdf5859dbc9f9a2a9410a74643ef8b0 | 16907981 | 2025-07-02T07:43:19.000Z | 0x639642583a0cdb0cf3cbcc66eae85632f244f10880034db134797c9401343ce1 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.CashFactory_BeaconProxyDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_AddCollateralToDebtManager\_event
*No description available.*
| 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_userSafe` | `STRING` | User-owned safe contract address. 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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_AddCollateralToDebtManager_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_BorrowFromDebtManager\_event
*No description available.*
| 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_userSafe` | `STRING` | User-owned safe contract address. 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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_BorrowFromDebtManager_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_Cashback\_event
Cashback reward events from Etherfi's DebtManager contract on Scroll, tracking user spending amounts and corresponding cashback tokens earned but not yet paid. Used for analyzing reward program participation and pending cashback distributions across user safes.
| 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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_spendingInUsd` | `STRING` | USD value of the user's spending that qualified for cashback. Represented as a string-encoded integer in smallest unit (e.g., cents). |
| `in_cashbackToken` | `STRING` | Contract address of the token used for cashback payment. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_cashbackAmount` | `STRING` | Token amount of cashback earned by the user, denominated in the smallest unit of the cashback token (wei-equivalent). Always paired with in\_cashbackToken address and in\_cashbackInUsd for USD-denominated value. |
| `in_cashbackInUsd` | `STRING` | USD value of the cashback reward. Represented as a string-encoded integer in smallest unit (e.g., cents). |
| `in_paid` | `BOOL` | Boolean flag indicating whether the cashback payment has been processed and distributed to the recipient. |
| address | in\_paid | removed | log\_index | in\_userSafe | block\_number | block\_timestamp | in\_cashbackInUsd | in\_cashbackToken | in\_spendingInUsd | transaction\_hash | in\_cashbackAmount |
| ------------------------------------------ | -------- | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ----------------- | ------------------------------------------ | ----------------- | ------------------------------------------------------------------ | ------------------- |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | false | 1 | 0x2ab5c1cfc458561c808b9ddfa0b9ca890e54eec7 | 11532865 | 2024-11-30T15:42:17.000Z | 2725500 | 0xd29687c813d741e2f938f4ac377128810e217b1b | 90850000 | 0x51cdb5947c9a979259d11d0f4d6223c0ba5349fc1a7a5aae5e0b4eb4e46c9d66 | 3180929594724710413 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | false | 10 | 0x3139c094db4717ce385e8468d58313a73d48189f | 11532612 | 2024-11-30T15:28:30.000Z | 1952400 | 0xd29687c813d741e2f938f4ac377128810e217b1b | 48810000 | 0xea1a538ae6742cda790fca33b264b30c51c851632d176457b67c7142e88f9356 | 2278644997519913634 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | false | 3 | 0x3502670c632317f58f297fc9e47243942eba79f0 | 11537184 | 2024-11-30T19:30:23.000Z | 683800 | 0xd29687c813d741e2f938f4ac377128810e217b1b | 34190000 | 0x12aa089e4fec612c16f2b8acd43aa5cea0f13f333e562402df54d83cd6ccf216 | 777078127148527835 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_Cashback_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_CloseAccountWithDebtManager\_event
*No description available.*
| 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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_CloseAccountWithDebtManager_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_DefaultAdminDelayChangeCanceled\_event
*No description available.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_DefaultAdminDelayChangeCanceled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_DefaultAdminDelayChangeScheduled\_event
*No description available.*
| 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_newDelay` | `STRING` | - |
| `in_effectSchedule` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_DefaultAdminDelayChangeScheduled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_DefaultAdminTransferCanceled\_event
*No description available.*
| 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_DefaultAdminTransferCanceled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_DefaultAdminTransferScheduled\_event
*No description available.*
| 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_newAdmin` | `STRING` | Address of the newly assigned administrator. Hex-encoded, 0x-prefixed, 42-character string representing the Ethereum address that will receive admin privileges. |
| `in_acceptSchedule` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_DefaultAdminTransferScheduled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_IncomingOwnerSet\_event
Ownership transfer events from the EtherFi DebtManager contract on Scroll, recording when new owners are proposed for user safe wallets with cryptographic public key coordinates and activation timestamps. Used to track pending ownership changes and multi-party custody transitions in the EtherFi 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. |
| `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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_incomingOwner` | `STRUCT` | Record containing cryptographic coordinates (x, y) and Ethereum address representing the new owner being set for a user's Safe wallet. The ethAddr field appears consistently as the zero address, suggesting ownership verification relies on the coordinate values rather than direct Ethereum addresses. |
| `in_incomingOwnerStartTime` | `STRING` | Unix timestamp indicating when the incoming owner's access period begins for the user safe. Stored as string representation of seconds since epoch, typically a few seconds before the block timestamp. |
| address | removed | log\_index | in\_userSafe | block\_number | block\_timestamp | in\_incomingOwner | transaction\_hash | in\_incomingOwnerStartTime |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------ | -------------------------- |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 0 | 0x2412292985aac0f6696bd473fd845fc04e2c8dad | 12899708 | 2025-01-23T02:14:34.000Z | \{"x":"31713242778175050376157551963424503798812577193379658928870560812877953596618","y":"6826675760431073000075185292516336957837144169694797893790106028081785192525","ethAddr":"0x0000000000000000000000000000000000000000"} | 0xc137118fa2c887f3e6dd9b2647a06dc70a8122113136daa82b1ea7041a613ada | 1737598475 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 0 | 0x5bba1d1b2820c56c798a831ccf7ad39b70b13a01 | 12899663 | 2025-01-23T02:11:07.000Z | \{"x":"43864998669041949201221173348634024681223674489451257520751812415856223433030","y":"53970933790319422473742031252327526387669193498794856854176228339154651659786","ethAddr":"0x0000000000000000000000000000000000000000"} | 0x32dc5b24b0b7a7b47566832719b66198ac731fd2dc235754ab57abd623f676f9 | 1737598268 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 0 | 0x5bba1d1b2820c56c798a831ccf7ad39b70b13a01 | 12899365 | 2025-01-23T01:52:57.000Z | \{"x":"15082030015389049676592162196006690376673174421447289033970482783909831438996","y":"52329193565704708158421732112824785088650014244338840655016082750551971565099","ethAddr":"0x0000000000000000000000000000000000000000"} | 0x4126539605a72842032e221f26ded02db47c81c1f880687992a5c27958b61dd4 | 1737597178 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_IncomingOwnerSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_Initialized\_event
Initialization events for the Ether.fi DebtManager contract on Scroll, recording when the contract was deployed and configured with version tracking.
| 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_version` | `STRING` | Version identifier for the contract or event schema. String or integer value indicating the initialization or state version. |
| address | removed | log\_index | in\_version | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 7 | 1 | 11386827 | 2024-11-25T09:04:18.000Z | 0xdcd559fadad40dcef5c161a079a8f5acde3f6935fa270a38494e349ae5c2639e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_IsRecoveryActiveSet\_event
*No description available.*
| 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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_isActive` | `BOOL` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_IsRecoveryActiveSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_ModeSet\_event
Mode transitions for EtherFi user safes on Scroll, tracking when accounts switch between debt management states (0 and 1) with transition timestamps. Used for analyzing user borrowing behavior patterns and debt position lifecycle in the EtherFi V1 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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_prevMode` | `INT64` | The mode state before the transition occurred in the DebtManager contract for the specified user safe. Numeric identifier where 0 and 1 represent different operational modes in the debt management system. |
| `in_newMode` | `INT64` | Integer representing the debt mode being activated for the user safe. Mode transitions are tracked between 0 and 1, where 0 appears to be an exit/withdrawal state and 1 an active debt state. |
| `in_incomingModeStartTime` | `STRING` | Unix timestamp indicating when the incoming mode transition began for the user's Safe contract. Value is '0' when no mode transition is pending or when entering a new mode, and contains a timestamp when exiting a mode. |
| address | removed | log\_index | in\_newMode | in\_prevMode | in\_userSafe | block\_number | block\_timestamp | transaction\_hash | in\_incomingModeStartTime |
| ------------------------------------------ | ------- | ---------- | ----------- | ------------ | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------- |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 12 | 1 | 0 | 0x7f718503d2098688e8c355762929efe0f8d366bf | 12193689 | 2024-12-25T10:32:26.000Z | 0x06d89dc4cb42b6f63e3a1a05a360f86054d9ff595140298787a8b96efa8831a3 | 0 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 2 | 1 | 0 | 0x95aa375506dd5a4f6be7581410b65079a0b53b2f | 12188193 | 2024-12-25T05:22:04.000Z | 0x3b6d4ae952760b883fc4df9860a2dbc05e0e8e8817f27d25f870c527d0d109db | 0 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 0 | 0 | 1 | 0x95aa375506dd5a4f6be7581410b65079a0b53b2f | 12188179 | 2024-12-25T05:21:15.000Z | 0xde73ff084da72bbafb1a6ea11cc1e61ce50b735fc2a2d9202e6e2046521d9d70 | 1735104075 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_ModeSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_OwnerSet\_event
Owner assignment events from Etherfi's DebtManager contract on Scroll, tracking changes in safe ownership using elliptic curve public keys (x,y coordinates). Used to analyze account control transfers and passkey-based authentication setup for user safes.
| 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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldOwner` | `STRUCT` | Address of the previous owner before an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_newOwner` | `STRUCT` | Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | in\_newOwner | in\_oldOwner | in\_userSafe | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 3 | \{"x":"2945715828234231416640747217206596204102874721325341764643733649156344296533","y":"37793463252014862991961764130866395187869986721671697376689060628036788143143","ethAddr":"0x0000000000000000000000000000000000000000"} | \{"x":"0","y":"0","ethAddr":"0x0000000000000000000000000000000000000000"} | 0x9ab93d440955c4c8af16323d0c34fb34387e04a9 | 12701963 | 2025-01-14T21:06:58.000Z | 0xde8cb14855b5355a755f3c1ac59d6e2339632db858c1a572524d228d2866af41 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 3 | \{"x":"49756644409329620193940836945052747956010772777156834153859919093383185708641","y":"3917226848398504686479014173195784762238383147503222913605688056132007883845","ethAddr":"0x0000000000000000000000000000000000000000"} | \{"x":"0","y":"0","ethAddr":"0x0000000000000000000000000000000000000000"} | 0x87a5caa88c9d26f0a931bbe85000b531a14886dd | 12701960 | 2025-01-14T21:06:49.000Z | 0x624209ac54a683f2b3128d5d7dfe48aab41e867760dcf519ccb35ac368b7dd06 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 5 | \{"x":"84994737485724048162935172906623158289289481920093903317229500390295969359294","y":"53916753976905446387964683116321052950808314646097023722193809402415211169850","ethAddr":"0x0000000000000000000000000000000000000000"} | \{"x":"0","y":"0","ethAddr":"0x0000000000000000000000000000000000000000"} | 0x85fc2c2577635a4b3aefcaa581fac988e3e0726d | 12702045 | 2025-01-14T21:11:43.000Z | 0x6d1c9cc04857a263791597b4d90e026809bec4b47635b9bc20511284b5264ca5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_OwnerSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_PendingCashbackCleared\_event
Cashback clearance events from Etherfi's DebtManager contract on Scroll, recording when pending rewards are processed for user safes with token amounts and USD values. Useful for tracking user reward distributions and analyzing Etherfi's cashback program mechanics.
| 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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_cashbackToken` | `STRING` | Contract address of the token used for cashback payment. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_cashbackAmount` | `STRING` | Amount of cashback tokens distributed to the user, denominated in the smallest unit of the cashback token (wei-equivalent). Values are typically in the range of 10^17 to 10^19, representing fractional token amounts when divided by 10^18. |
| `in_cashbackInUsd` | `STRING` | USD value of the cashback reward. Represented as a string-encoded integer in smallest unit (e.g., cents). |
| address | removed | log\_index | in\_userSafe | block\_number | block\_timestamp | in\_cashbackInUsd | in\_cashbackToken | transaction\_hash | in\_cashbackAmount |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ----------------- | ------------------------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 9 | 0x3502670c632317f58f297fc9e47243942eba79f0 | 11589966 | 2024-12-02T17:37:40.000Z | 683800 | 0xd29687c813d741e2f938f4ac377128810e217b1b | 0x986777d298dd02b86990068695adcd9512c511f63c7f5b6044921fb3e06be0d2 | 765879282730194997 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 3 | 0x7f718503d2098688e8c355762929efe0f8d366bf | 11584547 | 2024-12-02T13:06:31.000Z | 3507999 | 0xd29687c813d741e2f938f4ac377128810e217b1b | 0x2650aa62a444936f0d69f902f5b85536d863ad6c03bbd45d25cbcdfbc79af7dc | 3825516902944383860 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 6 | 0x3139c094db4717ce385e8468d58313a73d48189f | 11589844 | 2024-12-02T17:31:25.000Z | 1952400 | 0xd29687c813d741e2f938f4ac377128810e217b1b | 0xe11ed0cb63d2a1f3e2b6bb1879dd6f4a75a64b51d89d519aba0242fe58424d2e | 2186754477336111017 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_PendingCashbackCleared_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_RepayDebtManager\_event
Debt repayment events from EtherFi's DebtManager contract on Scroll, recording when users repay borrowed positions through their Safe wallets. Contains repayment amounts in both token units and USD value for tracking deleveraging activity and debt management behavior.
| 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_userSafe` | `STRING` | User-owned safe contract address. 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_debtAmount` | `STRING` | Amount of debt denominated in the smallest unit of the token. Represented as a numeric string without decimal formatting. |
| `in_debtAmountInUsd` | `STRING` | USD value of the debt being repaid at the time of the transaction. Denominated in USD with precision maintained as a string to preserve exact decimal values. |
| address | removed | in\_token | log\_index | in\_userSafe | block\_number | in\_debtAmount | block\_timestamp | transaction\_hash | in\_debtAmountInUsd |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------- |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 3 | 0x779a5636f4f89ad9d95b04f55f22169cdaf121e1 | 13316445 | 2079060000 | 2025-02-09T21:12:02.000Z | 0xe21b04b3cca55423fae8768548bba3078c07d09a6d12f6a576e678e21a03e9b9 | 2079060000 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 9 | 0xdaaa7031ecd9813ae68834f9e528ba1ce0a2b720 | 11603258 | 50201241 | 2024-12-03T05:31:09.000Z | 0xc01e5476a03f054ec3d9dc357516ea6e72bad255e63e573c4e7eb43a726da7d4 | 50201241 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 3 | 0x92060ffd59f4cf842ee995323537ca5feb7a67a3 | 14911736 | 34276767 | 2025-04-22T11:28:24.000Z | 0x5a52fc94ec7abe0c88b97891c08366e3699070decbc895305badd4c12ec984c4 | 34276767 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_RepayDebtManager_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_RoleAdminChanged\_event
*No description available.*
| 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_role` | `STRING` | Role identifier for access control. 66-character keccak256 hash including 0x prefix. |
| `in_previousAdminRole` | `STRING` | Previous admin role identifier before the role change. 66-character keccak256 hash including 0x prefix. |
| `in_newAdminRole` | `STRING` | New admin role identifier for the specified role. 66-character keccak256 hash including 0x prefix. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_RoleAdminChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_RoleGranted\_event
Access control role assignment events from Ether.fi's DebtManager contract on Scroll. Tracks role grants with account addresses and role identifiers for monitoring permission changes in the protocol's debt management system.
| 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_role` | `STRING` | Role identifier for access control. 66-character keccak256 hash including 0x prefix. |
| `in_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_role | removed | in\_sender | log\_index | in\_account | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | 0x0000000000000000000000000000000000000000000000000000000000000000 | false | 0x4e59b44847b379578588920ca78fbf26c0b4956c | 6 | 0xa6cf33124cb342d1c604cac87986b965f428aac4 | 11386827 | 2024-11-25T09:04:18.000Z | 0xdcd559fadad40dcef5c161a079a8f5acde3f6935fa270a38494e349ae5c2639e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_RoleGranted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_RoleRevoked\_event
*No description available.*
| 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_role` | `STRING` | Role identifier for access control. 66-character keccak256 hash including 0x prefix. |
| `in_account` | `STRING` | Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_sender` | `STRING` | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_RoleRevoked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_Spend\_event
Spending events from Etherfi's DebtManager contract on Scroll, tracking token withdrawals from user safes with USD-denominated amounts. Used for analyzing debt position management and user withdrawal patterns across Etherfi's lending 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_userSafe` | `STRING` | User-owned safe contract address. 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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| `in_amountInUsd` | `STRING` | USD-denominated value of the input amount. Numeric string representation in smallest unit (e.g., cents or basis points). |
| `in_mode` | `INT64` | Operational mode identifier for the transaction or instruction. Integer or string value specifying the configuration, action type, or execution variant being performed. |
| address | in\_mode | removed | in\_token | in\_amount | log\_index | in\_userSafe | block\_number | in\_amountInUsd | block\_timestamp | transaction\_hash |
| ------------------------------------------ | -------- | ------- | ------------------------------------------ | ---------- | ---------- | ------------------------------------------ | ------------- | --------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | 1 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 1080000 | 3 | 0x036734bd8d37a5ea1f8c29ff3261f65b2f16f9f8 | 13440904 | 1080000 | 2025-02-15T11:45:02.000Z | 0xde9a690a123134f47c93915c47428c4aaecca59c2214707c3caf53074e2694e3 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | 1 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 1080000 | 3 | 0x036734bd8d37a5ea1f8c29ff3261f65b2f16f9f8 | 13440919 | 1080000 | 2025-02-15T11:45:58.000Z | 0xa92fd72de0888e22e2aa49ecd89e09214c64d3b7bb56de16fba674fbfdb75d19 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | 1 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 26100000 | 3 | 0x0f6365c9a421b91a87d0c386d767508ab157bfa1 | 13441956 | 26100000 | 2025-02-15T12:55:52.000Z | 0x969a59ba11870652e895b9f53df590ea930e0371262955ac1ba32d822f8c1040 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_Spend_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_SpendingLimitChanged\_event
Spending limit modification events from Etherfi's DebtManager contract on Scroll, tracking changes to daily and monthly spending caps for user safes. Records old and new limit configurations including spent amounts, renewal timestamps, and timezone offsets for monitoring debt facility usage controls.
| 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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldLimit` | `STRUCT` | Spending limit configuration before the change occurred, including daily and monthly caps, amounts spent, renewal timestamps, and timezone offset. Contains nested fields tracking previous limit states and pending limit adjustments. |
| `in_newLimit` | `STRUCT` | Updated spending limit configuration after the change, containing daily and monthly limits with timezone offset and renewal timestamps in UTC seconds. |
| address | removed | log\_index | in\_newLimit | in\_oldLimit | in\_userSafe | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 4 | \{"dailyLimit":"10000000000","spentToday":"0","monthlyLimit":"10000000000","newDailyLimit":"0","spentThisMonth":"412740000","timezoneOffset":"-18000","newMonthlyLimit":"0","dailyRenewalTimestamp":"1733634000","monthlyRenewalTimestamp":"1735707600","dailyLimitChangeActivationTime":"0","monthlyLimitChangeActivationTime":"0"} | \{"dailyLimit":"1000000000","spentToday":"0","monthlyLimit":"10000000000","newDailyLimit":"0","spentThisMonth":"412740000","timezoneOffset":"-18000","newMonthlyLimit":"0","dailyRenewalTimestamp":"1733634000","monthlyRenewalTimestamp":"1735707600","dailyLimitChangeActivationTime":"0","monthlyLimitChangeActivationTime":"0"} | 0x3139c094db4717ce385e8468d58313a73d48189f | 11723394 | 2024-12-07T15:05:50.000Z | 0x4258972d4f70ae2a4e1afd24359a0c59ed6536c9b3d93335b27d6ac19ab310d5 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 2 | \{"dailyLimit":"1000000000","spentToday":"0","monthlyLimit":"10000000000","newDailyLimit":"0","spentThisMonth":"0","timezoneOffset":"-18000","newMonthlyLimit":"0","dailyRenewalTimestamp":"1733634000","monthlyRenewalTimestamp":"1735707600","dailyLimitChangeActivationTime":"0","monthlyLimitChangeActivationTime":"0"} | \{"dailyLimit":"0","spentToday":"0","monthlyLimit":"0","newDailyLimit":"0","spentThisMonth":"0","timezoneOffset":"0","newMonthlyLimit":"0","dailyRenewalTimestamp":"0","monthlyRenewalTimestamp":"0","dailyLimitChangeActivationTime":"0","monthlyLimitChangeActivationTime":"0"} | 0xc648f8abc7cd9a157dd5e053a9ea37b944f5e790 | 11723346 | 2024-12-07T15:03:12.000Z | 0x18087a27d11c6f05755a5e35b5948b177a11c710b3014386b54cd058d5aeaad7 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 2 | \{"dailyLimit":"10000000000","spentToday":"0","monthlyLimit":"10000000000","newDailyLimit":"0","spentThisMonth":"0","timezoneOffset":"-18000","newMonthlyLimit":"0","dailyRenewalTimestamp":"1736744400","monthlyRenewalTimestamp":"1738386000","dailyLimitChangeActivationTime":"0","monthlyLimitChangeActivationTime":"0"} | \{"dailyLimit":"0","spentToday":"0","monthlyLimit":"0","newDailyLimit":"0","spentThisMonth":"0","timezoneOffset":"0","newMonthlyLimit":"0","dailyRenewalTimestamp":"0","monthlyRenewalTimestamp":"0","dailyLimitChangeActivationTime":"0","monthlyLimitChangeActivationTime":"0"} | 0x911d0d75b514f2ebbba235cd67a72b5fec1ffaee | 12656960 | 2025-01-13T02:03:25.000Z | 0xff9fc746b3e05fe171a63066758c0a8903d905c49b9b7eb9028e8bc96a9d169f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_SpendingLimitChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_Swap\_event
Token swap events from Ether.fi's DebtManager contract on Scroll, recording user safe addresses exchanging input tokens for output tokens with amounts and execution details. Used for tracking debt management activities and token exchange patterns within Ether.fi's 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. |
| `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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_inputToken` | `STRING` | Contract address of the token being deposited or transferred. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_inputAmount` | `STRING` | Amount of source tokens being swapped or deposited. Numeric string representation of token quantity in smallest denomination. |
| `in_outputToken` | `STRING` | Contract address of the token to be received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_outputAmount` | `STRING` | Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination. |
| address | removed | log\_index | in\_userSafe | block\_number | in\_inputToken | in\_inputAmount | in\_outputToken | block\_timestamp | in\_outputAmount | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | --------------- | ------------------------------------------ | ------------------------ | ------------------- | ------------------------------------------------------------------ |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 11 | 0x7f718503d2098688e8c355762929efe0f8d366bf | 11858325 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 10000000 | 0x01f0a31698c4d065659b9bdc21b3610292a1c506 | 2024-12-12T18:26:21.000Z | 2398355916410377 | 0xd26ee5e86651e66849cf5ba26ba696dc293b0c726440dbc6205aaa6dffe1df86 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 11 | 0xc648f8abc7cd9a157dd5e053a9ea37b944f5e790 | 11858681 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 2000000 | 0xd29687c813d741e2f938f4ac377128810e217b1b | 2024-12-12T18:44:44.000Z | 1671210404051972697 | 0x98a7eb516290bc34a91a4359a03320e2fcbc197c873331e216829fb991f12623 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 14 | 0xc648f8abc7cd9a157dd5e053a9ea37b944f5e790 | 11858670 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 10000000 | 0x01f0a31698c4d065659b9bdc21b3610292a1c506 | 2024-12-12T18:44:11.000Z | 2412611751703155 | 0xf7850a415292d23504a7b9f6fe33d0c1dc73c7aa54b80809f5beaa44b702f9d9 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_SwapTransferForSpending\_event
*No description available.*
| 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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_inputToken` | `STRING` | Contract address of the token being deposited or transferred. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_inputAmount` | `STRING` | Amount of source tokens being swapped or deposited. Numeric string representation of token quantity in smallest denomination. |
| `in_outputToken` | `STRING` | Contract address of the token to be received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_outputTokenSent` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_SwapTransferForSpending_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_TransferForSpending\_event
*No description available.*
| 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_userSafe` | `STRING` | User-owned safe contract address. 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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_TransferForSpending_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_Upgraded\_event
Contract upgrade events for Ether.fi's DebtManager contract on Scroll, tracking implementation address changes. Used for monitoring protocol upgrades and verifying contract versioning history.
| 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_implementation` | `STRING` | Contract address of the implementation contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_implementation |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | 5 | 11386827 | 2024-11-25T09:04:18.000Z | 0xdcd559fadad40dcef5c161a079a8f5acde3f6935fa270a38494e349ae5c2639e | 0x5a85fc47f678f715ec72b098eb8570e113cba5d5 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_Upgraded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_UserRecoverySignerSet\_event
*No description available.*
| 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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldRecoverySigner` | `STRING` | - |
| `in_newRecoverySigner` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_UserRecoverySignerSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_WithdrawalAmountUpdated\_event
*No description available.*
| 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_userSafe` | `STRING` | User-owned safe contract address. 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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_WithdrawalAmountUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_WithdrawalCancelled\_event
Withdrawal cancellation events from Ether.fi's DebtManager contract on Scroll, recording when users cancel pending withdrawals with token addresses, amounts, and associated user safe addresses. Useful for tracking withdrawal flow changes and user behavior in Ether.fi's liquid restaking 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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokens` | `ARRAY` | Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings. |
| `in_amounts` | `ARRAY` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| `in_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_tokens | log\_index | in\_amounts | in\_userSafe | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ----------------------------------------------- | ---------- | ----------------------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | \["0xd29687c813d741e2f938f4ac377128810e217b1b"] | 0 | \["100000000000000000"] | 0x26bad54442d7a9501a96c91e6bdc89f76d7c054e | 12701258 | 0xd23808421eebf1f41db40296a451bece0290bf04 | 2025-01-14T20:26:46.000Z | 0x6e6eed065c6d106ebd92996516a86dce5efd3b21b7099d76273804fc07dcc2db |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | \["0xd29687c813d741e2f938f4ac377128810e217b1b"] | 2 | \["100000000000000000"] | 0x26bad54442d7a9501a96c91e6bdc89f76d7c054e | 12701259 | 0xd23808421eebf1f41db40296a451bece0290bf04 | 2025-01-14T20:26:49.000Z | 0x4890ef16d54a087799a93900ccd75f057c3159c9788b090fc32f2619b05fc783 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_WithdrawalCancelled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_WithdrawalProcessed\_event
Withdrawal completion events from EtherFi's DebtManager contract on Scroll, recording token transfers from user safes to recipient addresses with amounts and token contract details. Useful for tracking fund withdrawals and analyzing liquidity outflows from the 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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokens` | `ARRAY` | Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings. |
| `in_amounts` | `ARRAY` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| `in_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_tokens | log\_index | in\_amounts | in\_userSafe | block\_number | in\_recipient | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ----------------------------------------------- | ---------- | -------------------------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | \["0xd29687c813d741e2f938f4ac377128810e217b1b"] | 1 | \["173021850165150299145"] | 0xd58736b9f5389d4262164b0508588cb208be380f | 13816363 | 0xb1eed0fd6fd4050e059e8ff88c4974b5d3d52227 | 2025-03-04T08:49:19.000Z | 0xa2c4b00b0007595452df1e63ad451814a131c286009dfd8b831dec8b08067303 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | \["0x01f0a31698c4d065659b9bdc21b3610292a1c506"] | 1 | \["100000000000000"] | 0x0c188cd4679c7337ef1dfc97b7af55461b62aa3e | 13715558 | 0x0c188cd4679c7337ef1dfc97b7af55461b62aa3e | 2025-02-27T20:34:57.000Z | 0x09c1da34291640ffe5369a132ad1732af5cbe94565fcf1d969c2a978c219d4b5 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | \["0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4"] | 4 | \["272598341"] | 0xffb4e4fa101c44985c5228008877110b479a8c70 | 13710861 | 0x38e23ed81ef2fd2860a69527deb4431714363b87 | 2025-02-27T15:23:06.000Z | 0x8e256775322efed38ce6d1f3d310700817db808b1779d475bd7332b2a29f7002 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_WithdrawalProcessed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_WithdrawalRequested\_event
Withdrawal request events from EtherFi's DebtManager contract on Scroll, recording user-initiated withdrawals with token addresses, amounts, recipient details, and finalization timestamps. Used for tracking pending withdrawal queues and analyzing liquidity exit patterns from 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_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_tokens` | `ARRAY` | Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings. |
| `in_amounts` | `ARRAY` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). |
| `in_recipient` | `STRING` | Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_finalizeTimestamp` | `STRING` | Unix timestamp representing when the withdrawal request becomes eligible for finalization. Typically set to a future date after the withdrawal request is initiated, creating a delay period before funds can be claimed. |
| address | removed | in\_tokens | log\_index | in\_amounts | in\_userSafe | block\_number | in\_recipient | block\_timestamp | transaction\_hash | in\_finalizeTimestamp |
| ------------------------------------------ | ------- | ----------------------------------------------- | ---------- | ------------------------- | ------------------------------------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | --------------------- |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | \["0xd29687c813d741e2f938f4ac377128810e217b1b"] | 3 | \["1000000000000000000"] | 0x1eb003c3738bd5479b0a144e133a787cbf9a68e6 | 12818398 | 0x624e2b7878c2acdbf75c37c8132c93a5de2d8aa3 | 2025-01-19T16:08:08.000Z | 0xd8c61aead8aa027e34533092be1ab9ed1a16658f98a08e9fa0e48f812ca05ca4 | 1737302889 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | \["0xd29687c813d741e2f938f4ac377128810e217b1b"] | 6 | \["14000000000000000000"] | 0x900c2761966a795177e84d61af4261e30d42e776 | 12816253 | 0xfe4e5610751c4944e5d8badc1e82b26d76a2495c | 2025-01-19T14:11:12.000Z | 0x8828c2cf0234baf479b7b67f694e46acacd25a8665042b00bd041fd40b36bea8 | 1737295873 |
| 0x5423885b376ebb4e6104b8ab1a908d350f6a162e | false | \["0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4"] | 0 | \["2034234273"] | 0xff8f64afc989a759e895de2d9675fab55806acfa | 13076464 | 0xd5403f8be37673c7bb14b5d146869bb6e9a86102 | 2025-01-30T14:21:29.000Z | 0x45c51b0b7c4fb29fa094ed6b77cf9f71b8b47bf3e0b1101e615bfd09d188cc85 | 1738246890 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_WithdrawalRequested_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### DebtManager\_WithdrawCollateralFromDebtManager\_event
*No description available.*
| 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_userSafe` | `STRING` | User-owned safe contract address. 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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.DebtManager_WithdrawCollateralFromDebtManager_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TopUp\_Deposit\_event
*No description available.*
| 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_token` | `STRING` | Token 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.TopUp_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TopUp\_TopUp\_event
*No description available.*
| 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_chainId` | `STRING` | Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155. |
| `in_txId` | `STRING` | Transaction identifier for the cross-chain or layer-2 operation. 66-character hex string including 0x prefix. |
| `in_userSafe` | `STRING` | User-owned safe contract address. 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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.TopUp_TopUp_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TopUp\_TopUpBatch\_event
*No description available.*
| 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_chainId` | `ARRAY` | Blockchain network identifier for the destination or target chain in a cross-chain operation. Numeric string representing the chain ID as defined in EIP-155. |
| `in_txId` | `ARRAY` | Transaction identifier for the cross-chain or layer-2 operation. 66-character hex string including 0x prefix. |
| `in_userSafe` | `ARRAY` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_token` | `ARRAY` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_amount` | `ARRAY` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.TopUp_TopUpBatch_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TopUp\_WalletToUserSafeRegistered\_event
*No description available.*
| 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_wallet` | `STRING` | Wallet address associated with the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_userSafe` | `STRING` | User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.TopUp_WalletToUserSafeRegistered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### TopUp\_Withdrawal\_event
*No description available.*
| 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_token` | `STRING` | Token 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. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.TopUp_Withdrawal_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_BorrowApySet\_event
Borrow Annual Percentage Yield (APY) update events from EtherFi's UserSafeEventEmitter contract on Scroll, tracking rate changes for lending positions by token address. Used for monitoring borrowing cost trends and interest rate adjustments in EtherFi's lending 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_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldApy` | `STRING` | Previous annual percentage yield (APY) for the specified token before the update, expressed in basis points where 158548959919 represents \~15,854,895.99%. Typically transitions from a high initial value to a more standard rate as seen in the sample. |
| `in_newApy` | `STRING` | The updated annual percentage yield (APY) for borrowing the specified token after this event. Value is an integer representation that may require scaling by a factor (typically 1e18 or similar) to derive the actual percentage rate. |
| address | removed | in\_token | in\_newApy | in\_oldApy | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 1 | 158548959919 | 3 | 11946290 | 2024-12-16T01:50:31.000Z | 0x48ae751fcafb48ebd52cd315a7e71aa6022807d7c43cd5d900239a2a0c0b6029 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_BorrowApySet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_Borrowed\_event
Borrow event logs from Etherfi's UserSafe contract on Scroll, tracking when users borrow tokens with user address, token address, and borrowed amount. Used for analyzing lending activity and user borrowing patterns in Etherfi's liquid restaking 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_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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_user | removed | in\_token | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | 0x22ff44d99a1eb66c222b0978952195390c97370b | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 97760000 | 6 | 14672048 | 2025-04-12T16:09:08.000Z | 0x0e5437045e0fbbf16e0872bf9898eaff74558412c7702fe136997bb1c5f9eef7 |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | 0x22ff44d99a1eb66c222b0978952195390c97370b | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 92390000 | 1 | 14660334 | 2025-04-12T06:23:26.000Z | 0x039b4b5c5f506960d7983c0af6ade1cf7212a85b061ab54930fc317c7e4bd3a9 |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | 0x22ff44d99a1eb66c222b0978952195390c97370b | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 11500000 | 1 | 14662839 | 2025-04-12T08:28:41.000Z | 0x97ba1fed4158807a803a4bb525f97577b223a0050d7a352f7521f8d04bda4d2e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_Borrowed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_BorrowTokenAdded\_event
Records of tokens enabled for borrowing in Etherfi's user safe contracts on Scroll, emitted when new collateral types are added to lending positions. Used for tracking which assets users can borrow against in the 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_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_token | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 0 | 11386866 | 2024-11-25T09:06:19.000Z | 0x4941436fb41ad4ac91b5d7831251ffd1295486882dd05509d7e278a01bf7da54 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_BorrowTokenAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_BorrowTokenConfigSet\_event
Configuration updates for borrowable tokens in EtherFi's UserSafe lending protocol on Scroll. Tracks interest rate parameters (APY), minimum shares, and borrowing totals for analyzing lending market conditions and risk parameters.
| 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_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_config` | `STRUCT` | Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address. |
| address | removed | in\_token | in\_config | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | \{"borrowApy":"158548959919","minShares":"5000000","lastUpdateTimestamp":"1732525579","totalBorrowingAmount":"0","interestIndexSnapshot":"0","totalSharesOfBorrowTokens":"0"} | 1 | 11386866 | 2024-11-25T09:06:19.000Z | 0x4941436fb41ad4ac91b5d7831251ffd1295486882dd05509d7e278a01bf7da54 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_BorrowTokenConfigSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_BorrowTokenRemoved\_event
*No description available.*
| 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_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_BorrowTokenRemoved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_CollateralTokenAdded\_event
Events tracking when collateral tokens are added to EtherFi user safes on Scroll, recording the token address and emitter contract for each addition. Used to analyze supported collateral types and safe configuration changes 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_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | in\_token | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 5 | 11386850 | 2024-11-25T09:05:31.000Z | 0x291291a258beb277d6e4e439977304ca091116d37294f465fff3e37a24dc364a |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 0x01f0a31698c4d065659b9bdc21b3610292a1c506 | 12 | 11386848 | 2024-11-25T09:05:25.000Z | 0x1bb48f4cce67a333e1158afc532765e602636d44e8c36b4f99a822b2b52c2d0d |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 0xd29687c813d741e2f938f4ac377128810e217b1b | 14 | 11386863 | 2024-11-25T09:06:10.000Z | 0x77b55052390f373f285a8b767dfbf29052abe146255b808001912c907f6de5ee |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_CollateralTokenAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_CollateralTokenConfigSet\_event
Collateral token parameter updates from EtherFi's lending protocol on Scroll, tracking changes to loan-to-value (LTV) ratios, liquidation thresholds, and liquidation bonuses for supported collateral assets. Useful for monitoring risk parameter adjustments and analyzing lending market configuration 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_collateralToken` | `STRING` | Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldConfig` | `STRUCT` | Previous configuration settings for the collateral token, including loan-to-value (LTV), liquidation threshold, and liquidation bonus parameters. Values are zero when a collateral token is being configured for the first time in the protocol. |
| `in_newConfig` | `STRUCT` | New configuration parameters applied after the update. Struct containing protocol-specific settings such as risk parameters, fees, or contract roles. |
| address | removed | log\_index | block\_number | in\_newConfig | in\_oldConfig | block\_timestamp | transaction\_hash | in\_collateralToken |
| ------------------------------------------ | ------- | ---------- | ------------- | ---------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 1 | 11946290 | \{"ltv":"90000000000000000000","liquidationBonus":"1000000000000000000","liquidationThreshold":"95000000000000000000"} | \{"ltv":"80000000000000000000","liquidationBonus":"1000000000000000000","liquidationThreshold":"95000000000000000000"} | 2024-12-16T01:50:31.000Z | 0x48ae751fcafb48ebd52cd315a7e71aa6022807d7c43cd5d900239a2a0c0b6029 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 15 | 11386863 | \{"ltv":"50000000000000000000","liquidationBonus":"1000000000000000000","liquidationThreshold":"75000000000000000000"} | \{"ltv":"0","liquidationBonus":"0","liquidationThreshold":"0"} | 2024-11-25T09:06:10.000Z | 0x77b55052390f373f285a8b767dfbf29052abe146255b808001912c907f6de5ee | 0xd29687c813d741e2f938f4ac377128810e217b1b |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 13 | 11386848 | \{"ltv":"50000000000000000000","liquidationBonus":"1000000000000000000","liquidationThreshold":"75000000000000000000"} | \{"ltv":"0","liquidationBonus":"0","liquidationThreshold":"0"} | 2024-11-25T09:05:25.000Z | 0x1bb48f4cce67a333e1158afc532765e602636d44e8c36b4f99a822b2b52c2d0d | 0x01f0a31698c4d065659b9bdc21b3610292a1c506 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_CollateralTokenConfigSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_CollateralTokenRemoved\_event
*No description available.*
| 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_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_CollateralTokenRemoved_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_Initialized\_event
Initialization events for Ether.fi user safe contracts deployed on Scroll, tracking when new user safes are created with their contract addresses and version numbers. Used to monitor safe deployment activity and analyze user onboarding 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_version` | `STRING` | Version identifier for the contract or event schema. String or integer value indicating the initialization or state version. |
| address | removed | log\_index | in\_version | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ---------- | ----------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 2 | 1 | 11386841 | 2024-11-25T09:05:03.000Z | 0xb10dd7c998e7f43002ef06d8698f64c222d6f16cbea4f41dcbeb6c1ee6ce17d7 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_Initialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_Liquidated\_event
*No description available.*
| 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_liquidator` | `STRING` | Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_debtTokenToLiquidate` | `STRING` | - |
| `in_userCollateralLiquidated` | `ARRAY>` | - |
| `in_beforeDebtAmount` | `STRING` | - |
| `in_debtAmountLiquidated` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_Liquidated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_LiquidationThresholdUpdated\_event
*No description available.*
| 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_oldThreshold` | `STRING` | - |
| `in_newThreshold` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_LiquidationThresholdUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_MinSharesOfBorrowTokenSet\_event
*No description available.*
| 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_token` | `STRING` | Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_oldMinShares` | `STRING` | - |
| `in_newMinShares` | `STRING` | - |
*No sample data available.*
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_MinSharesOfBorrowTokenSet_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_Repaid\_event
Loan repayment events from Etherfi's UserSafe protocol on Scroll, recording token amounts repaid by users. Tracks debt settlement activity with user addresses, token contracts, and repayment amounts for analyzing borrowing behavior and protocol utilization.
| Column | Type | Description |
| ------------------ | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_payer` | `STRING` | Address of the account that provided the funds for the repayment or payment transaction. 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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_user | removed | in\_payer | in\_token | in\_amount | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------------------------ | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | 0x779a5636f4f89ad9d95b04f55f22169cdaf121e1 | false | 0x779a5636f4f89ad9d95b04f55f22169cdaf121e1 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 357620000 | 2 | 14028025 | 2025-03-14T15:54:09.000Z | 0x4e4c3e460c4d49e249f70d6aed54963ede64842ea84ae560c568d5f17f1fa0d9 |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | 0xafdbb2e32ae6cc4891ada488e7be08e77069bc2c | false | 0xafdbb2e32ae6cc4891ada488e7be08e77069bc2c | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 234370000 | 2 | 14030818 | 2025-03-14T19:13:20.000Z | 0xf185900736a8e70c407ab6bf68935e2828ef038f141080420c7e4523a24ac11a |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | 0xcd96907384985d97c4b1c9ef3c1d9f81296b7d02 | false | 0xcd96907384985d97c4b1c9ef3c1d9f81296b7d02 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 3172042966 | 2 | 14343142 | 2025-04-01T04:18:46.000Z | 0xe43f6f35bb3795953ad64e0d6133a824ba4cf955d78a24a550816e0540fa3a62 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_Repaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_Supplied\_event
Token supply events from Etherfi's UserSafe contract on Scroll, recording user deposits of tokens with sender, amount, and token address details. Tracks liquidity provision activity for Etherfi's 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. |
| `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_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_amount` | `STRING` | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
| address | in\_user | removed | in\_token | in\_amount | in\_sender | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------ | ------------------------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | 0x261bec28b8a3bb5098436c9a918bed1270fff1e4 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 100000000000 | 0x261bec28b8a3bb5098436c9a918bed1270fff1e4 | 15 | 12056343 | 2024-12-20T04:34:05.000Z | 0x707fd30ee5930ef32f8b17b315fd367b5fa7921d7bf40e50d0d02ca1fbee485f |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | 0x7d829d50aaf400b8b29b3b311f4ad70ad819dc6e | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 5000000 | 0x7d829d50aaf400b8b29b3b311f4ad70ad819dc6e | 1 | 11445539 | 2024-11-27T10:51:44.000Z | 0x8d64806d1abbdcea8397f5bd3848a35ba7a50b5b11ea0a3e6e129719ec7e1e23 |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | 0x261bec28b8a3bb5098436c9a918bed1270fff1e4 | false | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 1000000000 | 0x261bec28b8a3bb5098436c9a918bed1270fff1e4 | 3 | 11462617 | 2024-11-28T01:52:44.000Z | 0x9b062685ef23cd659b88e584537162089d6e1d03c6d16c2b930a404d942eb44f |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_Supplied_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_TotalBorrowingUpdated\_event
Borrowing balance updates from EtherFi's UserSafe contract on Scroll, tracking total borrowed amounts before and after interest accrual for each borrow token. Used to analyze debt position changes and interest accumulation patterns across user safes.
| 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_borrowToken` | `STRING` | Contract address of the token being borrowed. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_totalBorrowingAmtBeforeInterest` | `STRING` | Total borrowing amount for the specified token before interest accrual is applied. Values are denominated in the smallest unit of the borrow token (similar to wei for ETH). |
| `in_totalBorrowingAmtAfterInterest` | `STRING` | Total borrowing amount for the specified token after accrued interest has been applied, denominated in the smallest unit of the borrow token. Represented as a string to preserve precision for large integer values. |
| address | removed | log\_index | block\_number | in\_borrowToken | block\_timestamp | transaction\_hash | in\_totalBorrowingAmtAfterInterest | in\_totalBorrowingAmtBeforeInterest |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ---------------------------------- | ----------------------------------- |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 0 | 11725284 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 2024-12-07T16:51:46.000Z | 0xba5d8177c75c6b72153f04e1f65bd9cdb700fc8beb9e7b1a566200f72ad9a717 | 624419593 | 624415084 |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 0 | 11720020 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 2024-12-07T12:02:58.000Z | 0xedd8363b7aa40cea525a514a04f84b7d4fb8167eda1205d44a642f2384e0ab13 | 536293458 | 536259839 |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 0 | 11723925 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 2024-12-07T15:35:51.000Z | 0x35c61d0aefdff47ee49aea633fe2f2caa058cf5b1542abe4c9b911bb29b29a1e | 578495084 | 578493015 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_TotalBorrowingUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_Upgraded\_event
Contract upgrade events from Ether.fi's UserSafeEventEmitter on Scroll, tracking implementation address changes when the smart contract is upgraded. Used for monitoring protocol version updates and ensuring users interact with current contract implementations.
| 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_implementation` | `STRING` | Contract address of the implementation contract. Hex-encoded, 0x-prefixed, 42-character string. |
| address | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_implementation |
| ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 4 | 11386843 | 2024-11-25T09:05:09.000Z | 0xd076658070cee25c5e0cb9a7af64162a9386362d719ab16ee8d74e027810b525 | 0x7aef2b4c256f76e0de7fb264fadb15e4dc920682 |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 11 | 11386814 | 2024-11-25T09:03:39.000Z | 0xf034033a9f5d5fd157de850ca80836a93104866f26a138d6bb5a24593a7d0bc3 | 0x318c5f25e44ae661b06dcb9278648475ee52f814 |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 12 | 11888265 | 2024-12-13T20:34:19.000Z | 0x966500852df947d87bae29c004953da61d82c8c45311f73d360b90da09e09ac6 | 0xea25223b4677b4c3d41f3ae9c831c501be780b0e |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_Upgraded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_UserInterestAdded\_event
Interest accrual events from Etherfi's lending protocol on Scroll, tracking user borrowing balances before and after interest additions. Used for analyzing borrowing costs and protocol interest rate dynamics.
| Column | Type | Description |
| ------------------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `block_timestamp` | `TIMESTAMP` | Timestamp when the block was produced. UTC timezone, millisecond precision. |
| `block_number` | `INT64` | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain. |
| `transaction_hash` | `STRING` | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
| `log_index` | `INT64` | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission. |
| `address` | `STRING` | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
| `removed` | `BOOL` | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
| `in_user` | `STRING` | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_borrowingAmtBeforeInterest` | `STRING` | User's borrowing amount before accrued interest is added, denominated in the smallest unit of the borrowed token. This snapshot value represents the principal debt prior to the interest calculation shown in the after-interest field. |
| `in_borrowingAmtAfterInterest` | `STRING` | User's total borrowing amount in the smallest token unit after interest accrual was applied in this event. Values are stored as numeric strings representing wei or similar base unit amounts. |
| address | in\_user | removed | log\_index | block\_number | block\_timestamp | transaction\_hash | in\_borrowingAmtAfterInterest | in\_borrowingAmtBeforeInterest |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ----------------------------- | ------------------------------ |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | 0x30f3e701d9034acc017cf189338be1fe7589759d | false | 1 | 11706329 | 2024-12-06T23:12:03.000Z | 0x32c77f879b8732fd741423bc25ce778b813a01bff514c349ecd68908f3304a99 | 70221629 | 70221444 |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | 0x30f3e701d9034acc017cf189338be1fe7589759d | false | 1 | 11705824 | 2024-12-06T22:44:15.000Z | 0x081fefbe4052ff0f699bc068e0f239d8159068536b31970fb6030e46c52718d8 | 25511444 | 25510007 |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | 0x4b84dda665a3af48cedf8ee3ad462f981d9cb2b1 | false | 1 | 11694107 | 2024-12-06T12:49:46.000Z | 0x7ef556ecbb0eb44cefd887078d015acf5ae4694fde23ad9ddf02732bc20161aa | 4551042 | 4550948 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_UserInterestAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeEventEmitter\_WithdrawBorrowToken\_event
Borrowed token withdrawal events from Ether.fi's UserSafe contract on Scroll, tracking when users withdraw borrowed assets with withdrawer address, token address, and withdrawal amounts. Used for analyzing borrowing activity and liquidity movements within Ether.fi's lending 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_withdrawer` | `STRING` | Address of the account receiving the withdrawn assets. Hex-encoded, 0x-prefixed, 42-character string. |
| `in_borrowToken` | `STRING` | Contract address of the token being borrowed. 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 | block\_number | in\_withdrawer | in\_borrowToken | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------- | ------------ | ---------- | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
| 0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0 | false | 105100975785 | 2 | 16228416 | 0x261bec28b8a3bb5098436c9a918bed1270fff1e4 | 0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4 | 2025-06-04T20:42:18.000Z | 0xabf68625e367aba5bc206fa47781834040b2b6f4504789e4edd8b03413bea25b |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeEventEmitter_WithdrawBorrowToken_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### UserSafeFactory\_UserSafeDeployed\_event
User Safe wallet deployment events from Ether.fi protocol on Scroll, capturing when new Safe smart contract wallets are created for users. Useful for tracking protocol adoption and analyzing user wallet creation 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_safe` | `STRING` | Safe contract address associated with the event. Hex-encoded, 0x-prefixed, 42-character string. |
| address | in\_safe | removed | log\_index | block\_number | block\_timestamp | transaction\_hash |
| ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x18fa07df94b4e9f09844e1128483801b24fe8a27 | 0x6847c9d87eb85c346d2c3ffe8327f9e0fbe35879 | false | 5 | 12330914 | 2024-12-30T16:09:22.000Z | 0xab3421d8794e8488b2c22617a68db27433bad2c81c8aeddc69b854484f0d05a1 |
| 0x18fa07df94b4e9f09844e1128483801b24fe8a27 | 0xa10771875758891daa3c86ce2cf03ef134c81228 | false | 5 | 12332161 | 2024-12-30T17:18:30.000Z | 0x4a67544ee074b39574986b8e2acecd02cc83533574c73a586b954bd06999a913 |
| 0x18fa07df94b4e9f09844e1128483801b24fe8a27 | 0xbad8fd17a914c7aa1e705a8ccd4af58d985c06cd | false | 5 | 12333216 | 2024-12-30T18:15:30.000Z | 0x757bf1d815be7c2e57a99f5a6ef1b0ea9161412aaf2b3cc5b0b2b1b4a71cfec8 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.etherfi_v1_scroll.UserSafeFactory_UserSafeDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***