etherfi_v1_scroll - Token Terminal Docs

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_beacon`	`STRING`	Contract address of the beacon proxy implementation contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_beacon	block_number	block_timestamp	transaction_hash
0x22f2666bceafbd1b8f984d842b01c6182db3dceb	false	0x48e1630278d8310c86650405ebfbc110cdf3d1ec	14809125	2025-04-17T16:31:41.000Z	0xaa4555ac8de2d6e31b4305dd26c3f0df4d3b769e44b40f77939bcec9a51b84f6
0xf6a7ecb90516be197ee040f4ab17007b9defcf44	false	0x48e1630278d8310c86650405ebfbc110cdf3d1ec	14813251	2025-04-17T20:55:47.000Z	0x91fe521a4ab83694ad6b502a35a8a015fa08205584f308600a9dea726de6733b
0x4b64bc16d9bf09f2e25f14203538b6da86288022	false	0x48e1630278d8310c86650405ebfbc110cdf3d1ec	14796835	2025-04-17T04:06:51.000Z	0xf785b9adf21d26da6601c08afda3fcbc13df1bbbf2a265ff44701edfebab5aa0

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_config`	`STRUCT<interestIndexSnapshot STRING, totalNormalizedBorrowingAmount STRING, totalSharesOfBorrowTokens STRING, lastUpdateTimestamp STRING, borrowApy STRING, minShares STRING>`	Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldConfig`	`STRUCT<ltv STRING, liquidationThreshold STRING, liquidationBonus STRING>`	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<ltv STRING, liquidationThreshold STRING, liquidationBonus STRING>`	New configuration parameters applied after the update. Struct containing protocol-specific settings such as risk parameters, fees, or contract roles.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<STRUCT<token STRING, amount STRING, liquidationBonus STRING>>`	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.

Sample Data

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”}]

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_borrowToken`	`STRING`	Contract address of the token being borrowed. Hex-encoded, 0x-prefixed, 42-character string.
`in_totalBorrowingAmtBeforeInterest`	`STRING`	-
`in_totalBorrowingAmtAfterInterest`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_implementation`	`STRING`	Contract address of the implementation contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_userSafe`	`STRING`	User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_newDelay`	`STRING`	-
`in_effectSchedule`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_userSafe`	`STRING`	User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_incomingOwner`	`STRUCT<ethAddr STRING, x STRING, y STRING>`	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.

Sample Data

address	removed	in_userSafe	block_number	block_timestamp	in_incomingOwner	transaction_hash	in_incomingOwnerStartTime
0x5423885b376ebb4e6104b8ab1a908d350f6a162e	false	0x2412292985aac0f6696bd473fd845fc04e2c8dad	12899708	2025-01-23T02:14:34.000Z	{“x”:“31713242778175050376157551963424503798812577193379658928870560812877953596618”,“y”:“6826675760431073000075185292516336957837144169694797893790106028081785192525”,“ethAddr”:“0x0000000000000000000000000000000000000000”}	0xc137118fa2c887f3e6dd9b2647a06dc70a8122113136daa82b1ea7041a613ada	1737598475
0x5423885b376ebb4e6104b8ab1a908d350f6a162e	false	0x5bba1d1b2820c56c798a831ccf7ad39b70b13a01	12899663	2025-01-23T02:11:07.000Z	{“x”:“43864998669041949201221173348634024681223674489451257520751812415856223433030”,“y”:“53970933790319422473742031252327526387669193498794856854176228339154651659786”,“ethAddr”:“0x0000000000000000000000000000000000000000”}	0x32dc5b24b0b7a7b47566832719b66198ac731fd2dc235754ab57abd623f676f9	1737598268
0x5423885b376ebb4e6104b8ab1a908d350f6a162e	false	0x5bba1d1b2820c56c798a831ccf7ad39b70b13a01	12899365	2025-01-23T01:52:57.000Z	{“x”:“15082030015389049676592162196006690376673174421447289033970482783909831438996”,“y”:“52329193565704708158421732112824785088650014244338840655016082750551971565099”,“ethAddr”:“0x0000000000000000000000000000000000000000”}	0x4126539605a72842032e221f26ded02db47c81c1f880687992a5c27958b61dd4	1737597178

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0x5423885b376ebb4e6104b8ab1a908d350f6a162e	false	7	1	11386827	2024-11-25T09:04:18.000Z	0xdcd559fadad40dcef5c161a079a8f5acde3f6935fa270a38494e349ae5c2639e

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_userSafe`	`STRING`	User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_isActive`	`BOOL`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_userSafe`	`STRING`	User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldOwner`	`STRUCT<ethAddr STRING, x STRING, y STRING>`	Address of the previous owner before an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.
`in_newOwner`	`STRUCT<ethAddr STRING, x STRING, y STRING>`	Address of the newly assigned owner in an ownership transfer event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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).

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_userSafe`	`STRING`	User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldLimit`	`STRUCT<dailyLimit STRING, monthlyLimit STRING, spentToday STRING, spentThisMonth STRING, newDailyLimit STRING, newMonthlyLimit STRING, dailyRenewalTimestamp STRING, monthlyRenewalTimestamp STRING, dailyLimitChangeActivationTime STRING, monthlyLimitChangeActivationTime STRING, timezoneOffset STRING>`	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<dailyLimit STRING, monthlyLimit STRING, spentToday STRING, spentThisMonth STRING, newDailyLimit STRING, newMonthlyLimit STRING, dailyRenewalTimestamp STRING, monthlyRenewalTimestamp STRING, dailyLimitChangeActivationTime STRING, monthlyLimitChangeActivationTime STRING, timezoneOffset STRING>`	Updated spending limit configuration after the change, containing daily and monthly limits with timezone offset and renewal timestamps in UTC seconds.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_implementation`	`STRING`	Contract address of the implementation contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_implementation
0x5423885b376ebb4e6104b8ab1a908d350f6a162e	false	5	11386827	2024-11-25T09:04:18.000Z	0xdcd559fadad40dcef5c161a079a8f5acde3f6935fa270a38494e349ae5c2639e	0x5a85fc47f678f715ec72b098eb8570e113cba5d5

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_userSafe`	`STRING`	User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldRecoverySigner`	`STRING`	-
`in_newRecoverySigner`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_userSafe`	`STRING`	User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_amounts`	`ARRAY<STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_userSafe`	`STRING`	User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_amounts`	`ARRAY<STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_userSafe`	`STRING`	User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_amounts`	`ARRAY<STRING>`	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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_chainId`	`ARRAY<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`	`ARRAY<STRING>`	Transaction identifier for the cross-chain or layer-2 operation. 66-character hex string including 0x prefix.
`in_userSafe`	`ARRAY<STRING>`	User-owned safe contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`ARRAY<STRING>`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`ARRAY<STRING>`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_token	log_index	block_number	block_timestamp	transaction_hash
0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0	false	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	0	11386866	2024-11-25T09:06:19.000Z	0x4941436fb41ad4ac91b5d7831251ffd1295486882dd05509d7e278a01bf7da54

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_config`	`STRUCT<interestIndexSnapshot STRING, totalBorrowingAmount STRING, totalSharesOfBorrowTokens STRING, lastUpdateTimestamp STRING, borrowApy STRING, minShares STRING>`	Configuration account or address containing protocol parameters and settings. Base58-encoded Solana public key or hex-encoded EVM address.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_collateralToken`	`STRING`	Contract address of the collateral token used in the position or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldConfig`	`STRUCT<ltv STRING, liquidationThreshold STRING, liquidationBonus STRING>`	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<ltv STRING, liquidationThreshold STRING, liquidationBonus STRING>`	New configuration parameters applied after the update. Struct containing protocol-specific settings such as risk parameters, fees, or contract roles.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_version`	`STRING`	Version identifier for the contract or event schema. String or integer value indicating the initialization or state version.

Sample Data

address	removed	log_index	in_version	block_number	block_timestamp	transaction_hash
0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0	false	2	1	11386841	2024-11-25T09:05:03.000Z	0xb10dd7c998e7f43002ef06d8698f64c222d6f16cbea4f41dcbeb6c1ee6ce17d7

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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<STRUCT<token STRING, amount STRING, liquidationBonus STRING>>`	-
`in_beforeDebtAmount`	`STRING`	-
`in_debtAmountLiquidated`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_oldThreshold`	`STRING`	-
`in_newThreshold`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldMinShares`	`STRING`	-
`in_newMinShares`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

address	removed	block_number	in_borrowToken	block_timestamp	transaction_hash	in_totalBorrowingAmtAfterInterest	in_totalBorrowingAmtBeforeInterest
0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0	false	11725284	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	2024-12-07T16:51:46.000Z	0xba5d8177c75c6b72153f04e1f65bd9cdb700fc8beb9e7b1a566200f72ad9a717	624419593	624415084
0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0	false	11720020	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	2024-12-07T12:02:58.000Z	0xedd8363b7aa40cea525a514a04f84b7d4fb8167eda1205d44a642f2384e0ab13	536293458	536259839
0x8f9d2cd33551ce06dd0564ba147513f715c2f4a0	false	11723925	0x06efdbff2a14a7c8e15944d1f4a48f9f95f663a4	2024-12-07T15:35:51.000Z	0x35c61d0aefdff47ee49aea633fe2f2caa058cf5b1542abe4c9b911bb29b29a1e	578495084	578493015

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_implementation`	`STRING`	Contract address of the implementation contract. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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.

Sample Data

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

Example Query

Query with partition filter

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_safe`	`STRING`	Safe contract address associated with the event. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

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

Example Query

Query with partition filter

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

⌘I

​Tables

​BeaconProxy_BeaconUpgraded_event

​CashDebitCore_BorrowApySet_event

​CashDebitCore_Borrowed_event

​CashDebitCore_BorrowTokenAdded_event

​CashDebitCore_BorrowTokenConfigSet_event

​CashDebitCore_BorrowTokenRemoved_event

​CashDebitCore_CollateralTokenAdded_event

​CashDebitCore_CollateralTokenConfigSet_event

​CashDebitCore_CollateralTokenRemoved_event

​CashDebitCore_InterestIndexUpdated_event

​CashDebitCore_Liquidated_event

​CashDebitCore_Repaid_event

​CashDebitCore_Supplied_event

​CashDebitCore_TotalBorrowingUpdated_event

​CashDebitCore_Unpaused_event

​CashDebitCore_Upgraded_event

​CashDebitCore_UserInterestAdded_event

​CashDebitCore_WithdrawBorrowToken_event

​CashEventEmitter_RepayDebtManager_event

​CashEventEmitter_Spend_event

​CashFactory_BeaconProxyDeployed_event

​DebtManager_AddCollateralToDebtManager_event

​DebtManager_BorrowFromDebtManager_event

​DebtManager_Cashback_event

​DebtManager_CloseAccountWithDebtManager_event

​DebtManager_DefaultAdminDelayChangeCanceled_event

​DebtManager_DefaultAdminDelayChangeScheduled_event

​DebtManager_DefaultAdminTransferCanceled_event

​DebtManager_DefaultAdminTransferScheduled_event

​DebtManager_IncomingOwnerSet_event

​DebtManager_Initialized_event

​DebtManager_IsRecoveryActiveSet_event

​DebtManager_ModeSet_event

​DebtManager_OwnerSet_event

​DebtManager_PendingCashbackCleared_event

​DebtManager_RepayDebtManager_event

​DebtManager_RoleAdminChanged_event

​DebtManager_RoleGranted_event

​DebtManager_RoleRevoked_event

​DebtManager_Spend_event

​DebtManager_SpendingLimitChanged_event

​DebtManager_Swap_event

​DebtManager_SwapTransferForSpending_event

​DebtManager_TransferForSpending_event

​DebtManager_Upgraded_event

​DebtManager_UserRecoverySignerSet_event

​DebtManager_WithdrawalAmountUpdated_event

​DebtManager_WithdrawalCancelled_event

​DebtManager_WithdrawalProcessed_event

​DebtManager_WithdrawalRequested_event

​DebtManager_WithdrawCollateralFromDebtManager_event

​TopUp_Deposit_event

​TopUp_TopUp_event

​TopUp_TopUpBatch_event

​TopUp_WalletToUserSafeRegistered_event

​TopUp_Withdrawal_event

​UserSafeEventEmitter_BorrowApySet_event

​UserSafeEventEmitter_Borrowed_event

​UserSafeEventEmitter_BorrowTokenAdded_event

​UserSafeEventEmitter_BorrowTokenConfigSet_event

​UserSafeEventEmitter_BorrowTokenRemoved_event

​UserSafeEventEmitter_CollateralTokenAdded_event

​UserSafeEventEmitter_CollateralTokenConfigSet_event

​UserSafeEventEmitter_CollateralTokenRemoved_event

​UserSafeEventEmitter_Initialized_event

​UserSafeEventEmitter_Liquidated_event

​UserSafeEventEmitter_LiquidationThresholdUpdated_event

​UserSafeEventEmitter_MinSharesOfBorrowTokenSet_event

​UserSafeEventEmitter_Repaid_event

​UserSafeEventEmitter_Supplied_event

​UserSafeEventEmitter_TotalBorrowingUpdated_event

​UserSafeEventEmitter_Upgraded_event

​UserSafeEventEmitter_UserInterestAdded_event

​UserSafeEventEmitter_WithdrawBorrowToken_event

​UserSafeFactory_UserSafeDeployed_event

Tables

BeaconProxy_BeaconUpgraded_event

CashDebitCore_BorrowApySet_event

CashDebitCore_Borrowed_event

CashDebitCore_BorrowTokenAdded_event

CashDebitCore_BorrowTokenConfigSet_event

CashDebitCore_BorrowTokenRemoved_event

CashDebitCore_CollateralTokenAdded_event

CashDebitCore_CollateralTokenConfigSet_event

CashDebitCore_CollateralTokenRemoved_event

CashDebitCore_InterestIndexUpdated_event

CashDebitCore_Liquidated_event

CashDebitCore_Repaid_event

CashDebitCore_Supplied_event

CashDebitCore_TotalBorrowingUpdated_event

CashDebitCore_Unpaused_event

CashDebitCore_Upgraded_event

CashDebitCore_UserInterestAdded_event

CashDebitCore_WithdrawBorrowToken_event

CashEventEmitter_RepayDebtManager_event

CashEventEmitter_Spend_event

CashFactory_BeaconProxyDeployed_event

DebtManager_AddCollateralToDebtManager_event

DebtManager_BorrowFromDebtManager_event

DebtManager_Cashback_event

DebtManager_CloseAccountWithDebtManager_event

DebtManager_DefaultAdminDelayChangeCanceled_event

DebtManager_DefaultAdminDelayChangeScheduled_event

DebtManager_DefaultAdminTransferCanceled_event

DebtManager_DefaultAdminTransferScheduled_event

DebtManager_IncomingOwnerSet_event

DebtManager_Initialized_event

DebtManager_IsRecoveryActiveSet_event

DebtManager_ModeSet_event

DebtManager_OwnerSet_event

DebtManager_PendingCashbackCleared_event

DebtManager_RepayDebtManager_event

DebtManager_RoleAdminChanged_event

DebtManager_RoleGranted_event

DebtManager_RoleRevoked_event

DebtManager_Spend_event

DebtManager_SpendingLimitChanged_event

DebtManager_Swap_event

DebtManager_SwapTransferForSpending_event

DebtManager_TransferForSpending_event

DebtManager_Upgraded_event

DebtManager_UserRecoverySignerSet_event

DebtManager_WithdrawalAmountUpdated_event

DebtManager_WithdrawalCancelled_event

DebtManager_WithdrawalProcessed_event

DebtManager_WithdrawalRequested_event

DebtManager_WithdrawCollateralFromDebtManager_event

TopUp_Deposit_event

TopUp_TopUp_event

TopUp_TopUpBatch_event

TopUp_WalletToUserSafeRegistered_event

TopUp_Withdrawal_event

UserSafeEventEmitter_BorrowApySet_event

UserSafeEventEmitter_Borrowed_event

UserSafeEventEmitter_BorrowTokenAdded_event

UserSafeEventEmitter_BorrowTokenConfigSet_event

UserSafeEventEmitter_BorrowTokenRemoved_event

UserSafeEventEmitter_CollateralTokenAdded_event

UserSafeEventEmitter_CollateralTokenConfigSet_event

UserSafeEventEmitter_CollateralTokenRemoved_event

UserSafeEventEmitter_Initialized_event

UserSafeEventEmitter_Liquidated_event

UserSafeEventEmitter_LiquidationThresholdUpdated_event

UserSafeEventEmitter_MinSharesOfBorrowTokenSet_event

UserSafeEventEmitter_Repaid_event

UserSafeEventEmitter_Supplied_event

UserSafeEventEmitter_TotalBorrowingUpdated_event

UserSafeEventEmitter_Upgraded_event

UserSafeEventEmitter_UserInterestAdded_event

UserSafeEventEmitter_WithdrawBorrowToken_event

UserSafeFactory_UserSafeDeployed_event