spark_v1_ethereum - Token Terminal Docs

Tables

LendingPoolConfigurator_CollateralConfigurationChanged_event

Collateral parameter update events from lending protocol configurator contracts, recording changes to loan-to-value (LTV), liquidation threshold, and liquidation bonus for specific assets. Used for tracking risk parameter adjustments in 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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_ltv`	`STRING`	Loan-to-value ratio for the collateral asset. Numeric string representing basis points where 10000 equals 100%.
`in_liquidationThreshold`	`STRING`	Liquidation threshold at which a position becomes eligible for liquidation. Numeric string representing basis points where 10000 equals 100%.
`in_liquidationBonus`	`STRING`	Liquidation bonus awarded to liquidators for purchasing collateral during liquidation. Numeric string representing basis points where 10000 equals 100%.

Sample Data

in_ltv	address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_liquidationBonus	in_liquidationThreshold
0	0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	200	22617678	2025-06-02T14:47:35.000Z	0x4ddc25f122e8092d40a008e2a1807ed81beb514f054345085ef863cdf266cf5e	10700	4000
7400	0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	184	19462132	2024-03-18T14:00:23.000Z	0x42360f376ade384dddee970b309e051380d0b201127e505eb70c8e6e6c1909c8	10700	7500
7900	0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	186	19462132	2024-03-18T14:00:23.000Z	0x42360f376ade384dddee970b309e051380d0b201127e505eb70c8e6e6c1909c8	10700	8000

Example Query

Query with partition filter

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

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

Aave V3 LendingPoolConfigurator event capturing changes to liquidation protocol fee parameters. Records the asset address, previous fee value, and new fee value for each configuration update.

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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldFee`	`STRING`	Previous liquidation protocol fee before the change. Numeric string representing basis points where 1000 equals 10%.
`in_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

address	removed	in_asset	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	1000	71	16776463	2023-03-07T12:36:11.000Z	0x93494a0fb66734a4ebd6cd6cc1810faa4884cc35904cc7da2062ac8062637af6
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	1000	76	16776471	2023-03-07T12:37:47.000Z	0x14acacc8ba55fd779fb86a7d3cba71f3198a444bfe8db9346312636133e9543b
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	1000	42	16776480	2023-03-07T12:39:35.000Z	0x6e54b5bdb9680e9ae824459c1455af2216779c21bcf1ae74ddd5d24c2025873f

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveFactorChanged_event

Events emitted when the reserve factor parameter is modified for a lending pool asset, capturing the asset address, old factor, and new factor values. Used to track protocol fee adjustments in Aave-based lending protocols.

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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldReserveFactor`	`STRING`	Previous reserve factor value for the asset in the lending pool before the change. Numeric string representing basis points where 10000 equals 100%.
`in_newReserveFactor`	`STRING`	Updated reserve factor value for the asset in the lending pool. Numeric string representing basis points where 10000 equals 100%.

Sample Data

address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactor	in_oldReserveFactor
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	246	17857211	2023-08-06T16:49:35.000Z	0x6afccfeb89bbbd2a9f198004c111b22b13aacd9e2eba23ad13f8dc242516a18d	500	1500
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0xdc035d45d973e3ec169d2276ddab16f1e407384f	382	21723481	2025-01-28T14:00:35.000Z	0x7236e4886857aa0c6cf4a2f1e784158b6a2e698515f64898f41c7e4ae27ba2e9	0	1
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0xdc035d45d973e3ec169d2276ddab16f1e407384f	375	21723481	2025-01-28T14:00:35.000Z	0x7236e4886857aa0c6cf4a2f1e784158b6a2e698515f64898f41c7e4ae27ba2e9	1	0

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveInitialized_event

Aave protocol events emitted when new lending reserves are initialized in the LendingPoolConfigurator contract, recording the deployed aToken, stable debt token, variable debt token, and interest rate strategy addresses for each asset.

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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_aToken`	`STRING`	Contract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_stableDebtToken`	`STRING`	Contract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_variableDebtToken`	`STRING`	Contract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_interestRateStrategyAddress`	`STRING`	Contract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_asset	in_aToken	log_index	block_number	block_timestamp	transaction_hash	in_stableDebtToken	in_variableDebtToken	in_interestRateStrategyAddress
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0xa3931d71877c0e7a3148cb7eb4463524fec27fbd	0x6715bc100a183cc65502f05845b589c1919ca3d3	324	21014413	2024-10-21T14:00:23.000Z	0xda31ba8a27ff7166680d9b556abe508a713a5e2028a729f87334d1c1ef4ccad6	0x55580770e14e008082ab2e8d08a16cc1dc192741	0x4e89b83f426fed3f2ef7bb2d7eb5b53e288e1a13	0xa8632b2f0a3c5327a77ee51a47a168b6490a7178
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0x18084fba666a33d37592fa2633fd49a74dd93a88	0xce6ca9cdce00a2b0c0d1dac93894f4bd2c960567	245	22117224	2025-03-24T14:00:35.000Z	0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab	0xf4b45ed75b50ec613661bcdf2353aa45a288872e	0x764591dc9ba21c1b92049331b80b6e2a2acf8b17	0x0d195221329c38a706966eb1da89636160f27c2a
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0x8236a87084f8b84306f72007f36f2618a5634494	0xa9d4ecebd48c282a70cfd3c469d6c8f178a5738e	241	22117224	2025-03-24T14:00:35.000Z	0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab	0xfbaf333a919cb92caf9e85966d4e28fff80e5d1d	0x096bddfee63f44a97cc6d2945539ee7c8f94637d	0xde5dde40e12763464dc859a9f03793988de953fb

Example Query

Query with partition filter

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

Pool_BackUnbacked_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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_backer`	`STRING`	-
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Pool_Borrow_event

Borrow events emitted when users take loans from lending pools, recording borrower address, borrowed amount, and applicable interest rate. Used for tracking lending protocol utilization and debt positions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool 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_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the 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_interestRateMode`	`INT64`	Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
`in_borrowRate`	`STRING`	Annual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places).
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_borrowRate	in_onBehalfOf	block_timestamp	transaction_hash	in_interestRateMode
0xc13e21b648a5ee794902342038ff3adab66be987	0x28177b138fdec353c1da1858798c52ac0be0a0a8	false	10377205295953186285776	265	0x6b175474e89094c44da98b954eedeac495271d0f	17889732	31401763155165655148976000	0x28177b138fdec353c1da1858798c52ac0be0a0a8	2023-08-11T06:03:23.000Z	0xcf0bf73d4a2bb144344be76af37f4b4f174f8e89b721ad5a36bc56ebbfc5029c	2
0xc13e21b648a5ee794902342038ff3adab66be987	0x2471ee5c959e89470827ce0e8269aa3031481d19	false	30000000000000000000000	142	0x6b175474e89094c44da98b954eedeac495271d0f	17888791	31401763155165655148976000	0x2471ee5c959e89470827ce0e8269aa3031481d19	2023-08-11T02:54:35.000Z	0xe89530f68da2397aa5b0813744a0afd66f07350b7e42a11c363c1a58f570c0ea	2
0xc13e21b648a5ee794902342038ff3adab66be987	0xb584b70908588db7a70ff590000700479868a610	false	65000000000000000000000	173	0x6b175474e89094c44da98b954eedeac495271d0f	17889556	31401763155165655148976000	0xb584b70908588db7a70ff590000700479868a610	2023-08-11T05:27:59.000Z	0x95b58c2b1803bf40a1e803b90b2a03614681b72b19693ca062ff200959643de6	2

Example Query

Query with partition filter

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

Pool_FlashLoan_event

Flash loan event records from Spark Protocol (Aave v3 fork) lending pools on Ethereum, capturing borrowed asset, amount, initiator, target contract, premium fee, and interest rate mode. Used for analyzing flash loan arbitrage strategies, liquidation flows, and protocol utilization 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_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_initiator`	`STRING`	Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_interestRateMode`	`INT64`	Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	removed	in_asset	in_amount	in_target	log_index	block_number	in_initiator	block_timestamp	in_referralCode	transaction_hash
0xc13e21b648a5ee794902342038ff3adab66be987	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	1500000000000000000000	0x619ad2d02dbee6eba3cdbda3f98430410e892882	87	18372089	0x619ad2d02dbee6eba3cdbda3f98430410e892882	2023-10-17T19:10:11.000Z	3228	0x583c4202ccbcb7c440f3ac7f766e38b184dc38500f38f6c0c4469dc9321055b0
0xc13e21b648a5ee794902342038ff3adab66be987	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	20000000000000000000000	0x619ad2d02dbee6eba3cdbda3f98430410e892882	245	18371583	0x619ad2d02dbee6eba3cdbda3f98430410e892882	2023-10-17T17:28:35.000Z	3228	0x3c71e7c2e49602bd775063a37ee99592fa943119e5de359f1b45e0e8db50e8c4
0xc13e21b648a5ee794902342038ff3adab66be987	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	30000000000000000000	0x619ad2d02dbee6eba3cdbda3f98430410e892882	163	18445827	0x619ad2d02dbee6eba3cdbda3f98430410e892882	2023-10-28T02:49:23.000Z	3228	0xa1282718584622b512fc25a40f6cba8b8e2a3898acde2b53eb10f056f52f3755

Example Query

Query with partition filter

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

Pool_IsolationModeTotalDebtUpdated_event

Event logs tracking total debt changes for isolated assets in Spark Protocol lending pools on Ethereum. Used to monitor aggregate borrowing positions and debt accumulation for specific collateral assets in isolation mode.

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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_totalDebt`	`STRING`	Aggregate debt amount across all positions for the specified asset in the pool’s isolation mode, denominated in the asset’s smallest unit. Values are stored as strings to preserve precision for large integers representing token amounts.

Sample Data

address	removed	in_asset	log_index	block_number	in_totalDebt	block_timestamp	transaction_hash
0xc13e21b648a5ee794902342038ff3adab66be987	false	0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee	482	21020689	4561206443	2024-10-22T11:02:11.000Z	0x8e63f0cb91133ad35436d962d8282b272eee640a14b07324a6b7e7c598b488d0
0xc13e21b648a5ee794902342038ff3adab66be987	false	0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee	246	21020078	3911206443	2024-10-22T08:58:59.000Z	0xe84f7d07c15432506e8313c3b271cdf8280f8c7238c486b07596a34163c57462
0xc13e21b648a5ee794902342038ff3adab66be987	false	0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee	139	21375221	13182931579	2024-12-10T22:54:59.000Z	0xa8ec177876274d4afbb90be9904d5d76bdfac0f9af49165e2ffc6988b7399f18

Example Query

Query with partition filter

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

Pool_LiquidationCall_event

Liquidation events from Spark Protocol (Aave v3 fork) lending pools on Ethereum, capturing when undercollateralized positions are forcibly closed by liquidators. Records debt repayment amounts, seized collateral quantities, and liquidator addresses for analyzing protocol risk and liquidation bot activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_collateralAsset`	`STRING`	Contract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtAsset`	`STRING`	Contract address of the debt asset being repaid during liquidation. 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_debtToCover`	`STRING`	Amount of debt being repaid during the liquidation operation. String-encoded integer representing the quantity in the debt asset’s smallest unit.
`in_liquidatedCollateralAmount`	`STRING`	Amount of collateral seized from the liquidated position. String-encoded integer representing the quantity in the collateral asset’s smallest unit.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiveAToken`	`BOOL`	Boolean flag indicating whether the liquidator receives aTokens instead of the underlying collateral asset during liquidation.

Sample Data

address	in_user	removed	log_index	block_number	in_debtAsset	in_liquidator	in_debtToCover	block_timestamp	in_receiveAToken	transaction_hash	in_collateralAsset	in_liquidatedCollateralAmount
0xc13e21b648a5ee794902342038ff3adab66be987	0xebd551abbf4d86855ded110e7b345807976d2d2c	false	186	18322547	0x6b175474e89094c44da98b954eedeac495271d0f	0xcbed8b1b92c6e4f86a58f66da7ba26a7172df827	332444159064168524654	2023-10-10T20:50:23.000Z	false	0x08e37a31fa047fcc7cd105862f146dbb4f9140bb1e269a1bd1a775760d7a10e5	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	223326565570604934
0xc13e21b648a5ee794902342038ff3adab66be987	0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d	false	112	18322529	0x6b175474e89094c44da98b954eedeac495271d0f	0xde26008df5af55a28da3d77d2996886f3b241845	562475670468718600068	2023-10-10T20:46:35.000Z	false	0x04438bf7075440922444ff3987367a1d2aaf2b71c342dea44d73e7bb2dcd307c	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	336649353261709628
0xc13e21b648a5ee794902342038ff3adab66be987	0x154a1910dca4f418c1cabba264259082c474cac0	false	56	18321228	0x6b175474e89094c44da98b954eedeac495271d0f	0xde26008df5af55a28da3d77d2996886f3b241845	528933506795511026917	2023-10-10T16:24:11.000Z	false	0x9020393a6c4accd9b7bb0f63a45e4f277dcac31f740e311b02681b975797838a	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	354061995433029127

Example Query

Query with partition filter

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

Pool_MintedToTreasury_event

Treasury minting events from Spark Protocol lending pools on Ethereum, recording interest accrual transferred to protocol treasury per reserve asset. Used for tracking protocol revenue generation and reserve-specific yield performance across different collateral types like WETH, DAI, and USDC.

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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountMinted`	`STRING`	Amount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value.

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_amountMinted	transaction_hash
0xc13e21b648a5ee794902342038ff3adab66be987	false	205	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	17708904	2023-07-16T22:44:59.000Z	16036590224556071	0x56e209559d525727ce5d5c9c98879422844907ea34bf5ef1728b8a8b94f070a1
0xc13e21b648a5ee794902342038ff3adab66be987	false	202	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	17708904	2023-07-16T22:44:59.000Z	328873230269530649	0x56e209559d525727ce5d5c9c98879422844907ea34bf5ef1728b8a8b94f070a1
0xc13e21b648a5ee794902342038ff3adab66be987	false	199	0x6b175474e89094c44da98b954eedeac495271d0f	17708904	2023-07-16T22:44:59.000Z	197498406607968	0x56e209559d525727ce5d5c9c98879422844907ea34bf5ef1728b8a8b94f070a1

Example Query

Query with partition filter

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

Pool_MintUnbacked_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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool 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_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the 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_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Pool_Repay_event

Loan repayment events from Spark Protocol lending pools on Ethereum, recording borrower repayments with repaid amounts, reserve token addresses, and whether aTokens were used for repayment. Used for analyzing debt reduction patterns and protocol liquidity flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool 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_repayer`	`STRING`	Address of the account that executed the repayment transaction. 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_useATokens`	`BOOL`	Boolean flag indicating whether aTokens (interest-bearing deposit tokens) were used to repay the debt instead of the underlying reserve asset.

Sample Data

address	in_user	removed	in_amount	log_index	in_repayer	in_reserve	block_number	in_useATokens	block_timestamp	transaction_hash
0xc13e21b648a5ee794902342038ff3adab66be987	0x74b3691ebc3fb083e36065a1986d6c490b13e95a	false	1002285201333203928347689	106	0x74b3691ebc3fb083e36065a1986d6c490b13e95a	0x6b175474e89094c44da98b954eedeac495271d0f	17590669	false	2023-06-30T07:39:59.000Z	0x7378ab0134f799c6206c6292ad0b68a1fe9199188bda223a3b49c8742e3c41e3
0xc13e21b648a5ee794902342038ff3adab66be987	0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d	false	27309849990698405779660	466	0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d	0x6b175474e89094c44da98b954eedeac495271d0f	17816273	false	2023-07-31T23:27:47.000Z	0xb847dc2b9afd04897af7105976c022e305976661660a33ac3536008fe5699835
0xc13e21b648a5ee794902342038ff3adab66be987	0xd4f072b18c7a31d50bbf1df729b68e9ace7bc0d9	false	1000000000000000000000000	292	0xd4f072b18c7a31d50bbf1df729b68e9ace7bc0d9	0x6b175474e89094c44da98b954eedeac495271d0f	17862523	false	2023-08-07T10:40:47.000Z	0x86a959a3c626c237b2f65eca5d597b32da9547be32d31d5e292129b1a28afa97

Example Query

Query with partition filter

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

Pool_ReserveDataUpdated_event

Reserve state updates from Spark Protocol (Aave v3 fork) lending pools on Ethereum, tracking liquidity and borrow indices for interest rate calculations. Each event records the current liquidity rate, variable/stable borrow rates, and cumulative indices for a specific reserve asset, enabling analysis of lending pool dynamics and yield accrual.

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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidityRate`	`STRING`	Current liquidity interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage yield earned by liquidity providers.
`in_stableBorrowRate`	`STRING`	Current stable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a stable rate loan.
`in_variableBorrowRate`	`STRING`	Current variable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a variable rate loan.
`in_liquidityIndex`	`STRING`	Cumulative liquidity index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor since the reserve’s inception, stored as a numeric string.
`in_variableBorrowIndex`	`STRING`	Cumulative variable borrow index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor for variable rate borrowers since the reserve’s inception, stored as a numeric string.

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_liquidityRate	transaction_hash	in_liquidityIndex	in_variableBorrowRate	in_variableBorrowIndex
0xc13e21b648a5ee794902342038ff3adab66be987	false	184	0x6b175474e89094c44da98b954eedeac495271d0f	17580316	2023-06-28T20:51:59.000Z	9155942964767453191920067	0x50036a445b1ee0867728520c710bf80e22221aa954ebb5241e16c5bcb2dd6d60	1000982534517136313072801386	34304803710648653896272000	1003366132954620220860606616
0xc13e21b648a5ee794902342038ff3adab66be987	false	314	0x6b175474e89094c44da98b954eedeac495271d0f	17580473	2023-06-28T21:23:47.000Z	9168946593728384784106356	0x3bb00c60763e5dc932687df9b8fd55572a8a30eb4ff75ed7ca01204bc4937d1d	1000983089016870014745445252	34304803710648653896272000	1003368215462198914922631082
0xc13e21b648a5ee794902342038ff3adab66be987	false	166	0x6b175474e89094c44da98b954eedeac495271d0f	17580201	2023-06-28T20:28:35.000Z	9130598755621093259396610	0x53df746ad6b8b01f25e39b45a208e32f410f23c2ef42eb3730620d1ce3298453	1000982127618642495132698886	34304803710648653896272000	1003364600546143542256870405

Example Query

Query with partition filter

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

Pool_Supply_event

Deposit events from Spark Protocol lending pools on Ethereum, capturing user supply transactions with token reserve addresses, amounts, and optional referral codes. Used for analyzing lending activity, liquidity provider behavior, and reserve utilization across 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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool 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_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the 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_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0xc13e21b648a5ee794902342038ff3adab66be987	0xd1abe5db14d073883f2084c2af105652102bdefc	false	303201023984483786718	293	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	18013757	0xd1abe5db14d073883f2084c2af105652102bdefc	2023-08-28T14:32:23.000Z	0x9990d4fd3ac7e31c966b9059a200952d4dbb47ff08662d245df3537b6a875936
0xc13e21b648a5ee794902342038ff3adab66be987	0x5b183ae7d37aeaf4bcb953aa85622c30772163af	false	23305223245481426	378	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	18010150	0x5b183ae7d37aeaf4bcb953aa85622c30772163af	2023-08-28T02:26:23.000Z	0xf5f0fd2f0f422f2aa566424e761a9a49b446c82052db2ed94a71349fbeea3fe0
0xc13e21b648a5ee794902342038ff3adab66be987	0xe1e271a26a42d00731caf4c7ab8ed1684510ab6e	false	167741730536126406177	301	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	18015219	0xe1e271a26a42d00731caf4c7ab8ed1684510ab6e	2023-08-28T19:27:59.000Z	0xd69832ee2e89ce7559afeefb7d1e64a2793cb44b95cd52da5d11b87d54444f05

Example Query

Query with partition filter

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

Pool_Withdraw_event

Withdrawal events from liquidity pools recording user withdrawals of reserve assets. Contains user address, withdrawn amount, reserve or currency identifier, and recipient address for tracking outbound pool liquidity.

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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool 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_to`	`STRING`	Destination address receiving tokens or assets in the 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

in_to	address	in_user	removed	in_amount	log_index	in_reserve	block_number	block_timestamp	transaction_hash
0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d	0xc13e21b648a5ee794902342038ff3adab66be987	0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d	false	5190000000000000000	283	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	17817903	2023-08-01T04:56:23.000Z	0x2aa5e240737168a6b312be029e50aa3ab4addc83392a9368cedf1aab5c1e1601
0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d	0xc13e21b648a5ee794902342038ff3adab66be987	0x5eaa8bdc315608e8cf873cfaba05e42826f68c4d	false	2300000000000000000	175	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	17817228	2023-08-01T02:40:23.000Z	0x5bc90cfce58bd065bf83159a3281d23c045f615cffb2252df0995d26a8438868
0xa9c2649f667dd489dc7a41b8ae5b804f0d5fcfad	0xc13e21b648a5ee794902342038ff3adab66be987	0xa9c2649f667dd489dc7a41b8ae5b804f0d5fcfad	false	135796019061151760061168	163	0x83f20f44975d03b1b09e64809b757c47f942beea	17819637	2023-08-01T10:45:11.000Z	0x19d8751fb9d6a95edcd564f98c9b505762cf279552d633e6d1997acef35c9e8c

Example Query

Query with partition filter

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

PoolConfigurator_FlashloanPremiumToProtocolUpdated_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_oldFlashloanPremiumToProtocol`	`STRING`	Previous flashloan premium allocated to the protocol treasury before the update. String-encoded integer representing basis points (0.01%), where 4 equals 0.04% and 10000 equals 100%.
`in_newFlashloanPremiumToProtocol`	`STRING`	Updated flashloan premium allocated to the protocol treasury. String-encoded integer representing basis points (0.01%), where 4 equals 0.04% and 10000 equals 100%.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

PoolConfigurator_LiquidationProtocolFeeChanged_event

Liquidation protocol fee configuration changes for assets in Spark Protocol (Aave v3 fork) lending pools on Ethereum. Tracks fee adjustments per asset with old and new fee values in basis points (e.g., 1000 = 10%) for analyzing protocol revenue 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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldFee`	`STRING`	Previous liquidation protocol fee before the change. Numeric string representing basis points where 1000 equals 10%.
`in_newFee`	`STRING`	Updated liquidation protocol fee. Numeric string representing basis points where 1000 equals 10%.

Sample Data

address	removed	in_asset	in_newFee	log_index	block_number	block_timestamp	transaction_hash
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0xcd5fe23c85820f7b72d0926fc9b05b43e359b7ee	1000	260	20111964	2024-06-17T14:00:23.000Z	0x75ee5811583faac5c9e22f2d4a4ec58091f9307e63eb4c8c77d5bdb75a6254ce
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf	1000	194	20863927	2024-09-30T14:00:23.000Z	0xfc1d79ef313c8b5af720830fb9f7f029bf700cbdfc0a472e12df1c72cce6be43
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0x6c3ea9036406852006290770bedfcaba0e23a0e8	1000	181	23118264	2025-08-11T14:00:23.000Z	0x39372da80325b306a02f93de009ecaffdd6e106b7cbd7f305ab7a39adbc527ed

Example Query

Query with partition filter

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

PoolConfigurator_ReserveFactorChanged_event

Reserve factor configuration change events from Spark Protocol’s PoolConfigurator contract on Ethereum, tracking adjustments to the protocol’s reserve allocation percentage for different assets. Shows historical parameter changes useful for analyzing protocol risk management and treasury fee structure evolution.

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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldReserveFactor`	`STRING`	Previous reserve factor value for the asset in the lending pool before the change. Numeric string representing basis points where 10000 equals 100%.
`in_newReserveFactor`	`STRING`	Updated reserve factor value for the asset in the lending pool. Numeric string representing basis points where 10000 equals 100%.

Sample Data

address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactor	in_oldReserveFactor
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0xdac17f958d2ee523a2206206994597c13d831ec7	346	18385588	2023-10-19T16:32:23.000Z	0x557c5c6306aec0f58c282c7b19519eebf5b94c3cab32e729adfee4cd2c41b967	500	0
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	353	18385588	2023-10-19T16:32:23.000Z	0x557c5c6306aec0f58c282c7b19519eebf5b94c3cab32e729adfee4cd2c41b967	500	1000
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0x83f20f44975d03b1b09e64809b757c47f942beea	20	16776448	2023-03-07T12:33:11.000Z	0xff56ceba37cfa6983667b711a19d7459fc9a772b60b749c29f065a123f6aed64	1000	0

Example Query

Query with partition filter

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

PoolConfigurator_ReserveInitialized_event

Reserve initialization events from Spark Protocol (Aave v3 fork) on Ethereum capturing when new lending assets are added to the protocol. Records contract addresses for interest-bearing tokens (aTokens), debt tokens, and interest rate strategy contracts for analyzing protocol expansion and asset onboarding.

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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_aToken`	`STRING`	Contract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_stableDebtToken`	`STRING`	Contract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_variableDebtToken`	`STRING`	Contract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_interestRateStrategyAddress`	`STRING`	Contract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_asset	in_aToken	log_index	block_number	block_timestamp	transaction_hash	in_stableDebtToken	in_variableDebtToken	in_interestRateStrategyAddress
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0xdac17f958d2ee523a2206206994597c13d831ec7	0xe7df13b8e3d6740fe17cbe928c7334243d86c92f	339	18385588	2023-10-19T16:32:23.000Z	0x557c5c6306aec0f58c282c7b19519eebf5b94c3cab32e729adfee4cd2c41b967	0x0dae62f953ceb2e969fb4de85f3f9074fa920776	0x529b6158d1d2992e3129f7c69e81a7c677dc3b12	0xbc8a68b0ab0617d7c90d15bb1601b25d795dc4c8
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	0x59cd1c87501baa753d0b5b5ab5d8416a45cd71db	52	16776431	2023-03-07T12:29:47.000Z	0x76ad67a5e378e3592462a5fee09c3c7a7097cb8d729c11194778509213153093	0x3c6b93d38ffa15ea995d1bc950d5d0fa6b22bd05	0x2e7576042566f8d6990e07a1b61ad1efd86ae70d	0x764b4ab9bca18eb633d92368f725765ebb8f047c
0x542dba469bde58faee189ffb60c6b49ce60e0738	false	0x83f20f44975d03b1b09e64809b757c47f942beea	0x78f897f0fe2d3b5690ebae7f19862deacedf10a7	44	16776431	2023-03-07T12:29:47.000Z	0x76ad67a5e378e3592462a5fee09c3c7a7097cb8d729c11194778509213153093	0xec6c6abed4dc03299eff82ac8a0a83643d3cb335	0xabc57081c04d921388240393ec4088aa47c6832b	0xec4cf692c18e62159a39704aa1db82ca2306ff90

Example Query

Query with partition filter

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

spETH_Deposit_event

Deposit events from the Spark v1 protocol’s spETH (staked ETH) vault on Ethereum, recording asset deposits with corresponding share issuance. Shows asset-to-share conversion rates and depositor addresses for analyzing staking activity and vault growth.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xfe6eb3b609a7c8352a241f7f3a21cea4e9209b8f	false	0x22a84d3612422873985b6acb039c7b43f13ee2b5	999999999999999999	0x22a84d3612422873985b6acb039c7b43f13ee2b5	999740963303216210	82	23671793	2025-10-27T22:35:59.000Z	0xee8c3b349b102acf49923e93c825cdc3af4499f6b1d3d342cac6e0bed927be43
0xfe6eb3b609a7c8352a241f7f3a21cea4e9209b8f	false	0x328ca8f95cd62a07e10343c2ea41268a5d1c99ea	3000000000000000000	0x328ca8f95cd62a07e10343c2ea41268a5d1c99ea	2999245447937879747	410	23670333	2025-10-27T17:41:11.000Z	0x014af408e8e513e4ea88c9cc9cf4255ef8d32829ead1a2f3d958cdc67baf0553
0xfe6eb3b609a7c8352a241f7f3a21cea4e9209b8f	false	0x451248229712d6f207ff9466d8d3a33cb59d103c	4950000000000000000	0x451248229712d6f207ff9466d8d3a33cb59d103c	4948847057357167610	147	23666715	2025-10-27T05:31:59.000Z	0x078483c5bcc202aa7d087df881240adb0d64cd2ed871b90efab529ff2e95c81e

Example Query

Query with partition filter

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

spETH_Withdraw_event

Withdrawal events from Spark Protocol’s spETH (staked ETH) vault on Ethereum, recording conversions of spETH shares back to ETH assets. Contains share amounts, corresponding asset values, and participant addresses for analyzing vault redemption activity and share-to-asset exchange rates.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0xfe6eb3b609a7c8352a241f7f3a21cea4e9209b8f	false	0x00ff6b7d26407a46af2b631b4fa452a036d027e5	11004743852330590387	0x00ff6b7d26407a46af2b631b4fa452a036d027e5	10999606656216840303	32	0x00ff6b7d26407a46af2b631b4fa452a036d027e5	23712209	2025-11-02T14:22:59.000Z	0x8cd87650c15ca531dd2938a651903c9b81318e654ced02dc98c35e6edfeedcc7
0xfe6eb3b609a7c8352a241f7f3a21cea4e9209b8f	false	0x3c16d0d61d9cff2cbac3dc02ccf296421291e51e	22000000000000000	0x3c16d0d61d9cff2cbac3dc02ccf296421291e51e	21996323981273159	59	0x3c16d0d61d9cff2cbac3dc02ccf296421291e51e	23653890	2025-10-25T10:31:23.000Z	0x17d32d5c9c00e3d8a66bad4c5585cddeb866f308bb67b58ce8f72f708026dc57
0xfe6eb3b609a7c8352a241f7f3a21cea4e9209b8f	false	0x3a3986d7be9463a530c71387c4a94cbaeb8592bc	700028006803626289	0x3a3986d7be9463a530c71387c4a94cbaeb8592bc	699894438312110926	176	0x3a3986d7be9463a530c71387c4a94cbaeb8592bc	23658514	2025-10-26T02:00:59.000Z	0x994bf6f6c62bf2aa65aebe3ee554e5ab8acdb407e51d6cb1309bf6bc5477f3b6

Example Query

Query with partition filter

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

spPYUSD_Deposit_event

Deposit events from Spark Protocol’s spPYUSD vault on Ethereum, recording PYUSD (PayPal USD) stablecoin deposits with corresponding share issuance. Useful for tracking vault inflows, share-to-asset exchange rates, and depositor behavior in the Spark 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x80128dbb9f07b93dde62a6daeadb69ed14a7d354	false	0x0000000000000000000000000000000000000001	1000000	0x3300f198988e4c9c63f75df86de36421f06af8c4	1000000	127	24018489	2025-12-15T14:06:11.000Z	0x8faf325fc9893985064042909bd9d560a47c49b3fd600f752414a74173a85347
0x80128dbb9f07b93dde62a6daeadb69ed14a7d354	false	0x52a8305f29f85bec5fa6ee78b87ddd2218d8e12e	19953517376	0x52a8305f29f85bec5fa6ee78b87ddd2218d8e12e	19953493990	233	24018610	2025-12-15T14:30:35.000Z	0xc3ea4b71483233ecceb79d9a3665e478dabe5865cfa39c0ef8bcf728ad9bc3bb
0x80128dbb9f07b93dde62a6daeadb69ed14a7d354	false	0x90598105df535b19420bd0d89aff73ecd6966312	690000	0x90598105df535b19420bd0d89aff73ecd6966312	689990	313	24019429	2025-12-15T17:15:11.000Z	0xeb37749134ff1b1d8c168d6d435ae7edd32d4bb9dcbe6d063a01a70e6387034b

Example Query

Query with partition filter

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

spPYUSD_Withdraw_event

Withdrawal events from Spark Protocol’s PYUSD (PayPal USD) vault on Ethereum, tracking redemptions where users burn vault shares to receive underlying PYUSD assets. Records share-to-asset conversion rates for analyzing vault liquidity flows and user redemption 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x80128dbb9f07b93dde62a6daeadb69ed14a7d354	false	0xe6db30da89e8c6492da3677fa9b5a7d59124995e	9997	0xe6db30da89e8c6492da3677fa9b5a7d59124995e	9996	585	0xe6db30da89e8c6492da3677fa9b5a7d59124995e	24027666	2025-12-16T20:50:59.000Z	0xb62242a28dda4b7f90e41e5b948e596f94b0cd02130baec17dee0fc3a003e0dc
0x80128dbb9f07b93dde62a6daeadb69ed14a7d354	false	0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c	2000000	0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c	2000000	91	0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c	24018546	2025-12-15T14:17:35.000Z	0xd5bec6e74851f0728cbc5b451e047bb758ff12a608dd97f1ba56eb19c5c0a3c9
0x80128dbb9f07b93dde62a6daeadb69ed14a7d354	false	0x1f9f5a2511c4ca5b768dadd067bc19916dd59d88	290000000	0x1f9f5a2511c4ca5b768dadd067bc19916dd59d88	289775755	181	0x1f9f5a2511c4ca5b768dadd067bc19916dd59d88	24069656	2025-12-22T17:31:11.000Z	0x4d565b09c5137bc189d7129e44cac73d8abd6e3b07368d0d0cb11796d53ffc97

Example Query

Query with partition filter

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

spToken_BalanceTransfer_event

BalanceTransfer event logs from Spark Protocol’s spToken contract on Ethereum, tracking all transfers of interest-bearing deposit tokens between addresses. Used for analyzing lending pool liquidity flows, user deposit/withdrawal patterns, and spToken holder activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

in_to	address	in_from	removed	in_index	in_value	log_index	block_number	block_timestamp	transaction_hash
0xbd7d6a9ad7865463de44b05f04559f65e3b11704	0x59cd1c87501baa753d0b5b5ab5d8416a45cd71db	0x465af2bd215b5f6ff97705dd821ff281ca1ef55a	false	1009415560399684515337444845	990689894982841114	192	18517977	2023-11-07T05:24:59.000Z	0x17a216d19ad05b6188503aa598696e1e319a7aef2707300f38868c72dcd71949
0xbd7d6a9ad7865463de44b05f04559f65e3b11704	0x59cd1c87501baa753d0b5b5ab5d8416a45cd71db	0x074fddd3ec0e28a2589fcef3662c7ff65fda9f31	false	1012009211623136588334408366	494066649055557848967	232	18883032	2023-12-28T08:50:59.000Z	0xb5f82511ba9a75339898d2b65f080524ddad5ab5fd8fc58b0b3c78bd8cd37735
0xbd7d6a9ad7865463de44b05f04559f65e3b11704	0x59cd1c87501baa753d0b5b5ab5d8416a45cd71db	0x1758094d540bded730e4b0c35db1e25ea1fccda1	false	1012008525465669322612842603	495055118008485174115	183	18882940	2023-12-28T08:32:35.000Z	0x0f5213241fe4c04832c0085ed28f03fde1ea1c776f27b29c93247ef9850bd8ca

Example Query

Query with partition filter

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

spToken_Burn_event

Burn events from Spark Protocol interest-bearing token contracts on Ethereum, capturing withdrawals where users redeem spTokens for underlying assets. Records include burned amount, accrued interest, and account addresses for analyzing redemption patterns and yield calculations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash	in_balanceIncrease
0x377c3bd93f2a2984e1e7be6a5c22c525ed4a4815	0x3d73fb14ee12a9baabc41122fe852e8a10798113	false	1112747711393705686340603119	39993239710	0x3d73fb14ee12a9baabc41122fe852e8a10798113	252	22130792	2025-03-26T11:30:47.000Z	0xa92922aeef518542860d30217d19577879558cbfca6922e283d6b77590b8e2da	838371728
0x3cfd5c0d4acaa8faee335842e4f31159fc76b008	0xaaf9f14f20145ad50db369e52b2793bfeb18a45b	false	1000000000000000000000000000	2000000000000000000000	0xaaf9f14f20145ad50db369e52b2793bfeb18a45b	167	22130691	2025-03-26T11:10:35.000Z	0x5d03206ec82e604ad8ba2a9f86465584d5ccd4ae9a7f576f9e109951e3b941ac	0
0x4197ba364ae6698015ae5c1468f54087602715b2	0x6c30b5471e42e2d47c18b98df187f35edbab8357	false	1000137529380430378499303886	7999998	0x6c30b5471e42e2d47c18b98df187f35edbab8357	110	22128142	2025-03-26T02:38:35.000Z	0x570b2aff8e4cb7a5e1f29c48c7362c154cd9e5f4e5c9f4ce341dfe991f06c488	2

Example Query

Query with partition filter

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

spToken_Initialized_event

Initialization events for Spark Protocol spTokens (interest-bearing receipt tokens) on Ethereum, capturing when new asset markets are added with metadata including token name, symbol, decimals, underlying asset address, and associated pool/treasury/incentives controller contracts. Used for tracking Spark lending market expansion and spToken configuration details.

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_underlyingAsset`	`STRING`	Contract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_treasury`	`STRING`	Contract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string.
`in_incentivesController`	`STRING`	Contract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string.
`in_aTokenDecimals`	`INT64`	Number of decimal places for the AToken. Integer value representing the divisibility of the token amount.
`in_aTokenName`	`STRING`	Human-readable name of the AToken being initialized in the Aave protocol. String value identifying the token, typically following the pattern “Aave [Chain] [Asset]” or “[Protocol] [Asset]”.
`in_aTokenSymbol`	`STRING`	Trading symbol for the AToken being initialized in the Aave protocol. String value representing the ticker symbol, following patterns like “aArb[Asset]”, “aEth[Asset]”, “aBnb[Asset]”, or protocol-specific variants.
`in_params`	`STRING`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.

Sample Data

address	in_pool	removed	in_params	log_index	in_treasury	block_number	in_aTokenName	block_timestamp	in_aTokenSymbol	transaction_hash	in_aTokenDecimals	in_underlyingAsset	in_incentivesController
0x9985df20d7e9103ecbceb16a84956434b6f06ae8	0xc13e21b648a5ee794902342038ff3adab66be987	false	0x	364	0xb137e7d16564c81ae2b0c8ee6b55de81dd46ece5	17514251	Spark rETH	2023-06-19T14:00:47.000Z	sprETH	0xa4073ced1bd5d26a95fd3642a30417ffea5ce9dc54d84a3a13c47ddb74b65555	18	0xae78736cd615f374d3085123a210448e74fc6393	0x4370d3b6c9588e02ce9d22e684387859c7ff5b34
0x7b481acc9fdaddc9af2cbea1ff2342cb1733e50f	0xc13e21b648a5ee794902342038ff3adab66be987	false	0x	373	0xb137e7d16564c81ae2b0c8ee6b55de81dd46ece5	17365842	Spark GNO	2023-05-29T16:30:59.000Z	spGNO	0x87ab228bf3cbe6c6f763b0f66e6252a0ff90654ebdfaeaf7fdd31a28e2d16bb6	18	0x6810e776880c02933d47db1b9fc05908e5386b96	0x0000000000000000000000000000000000000000
0xa9d4ecebd48c282a70cfd3c469d6c8f178a5738e	0xc13e21b648a5ee794902342038ff3adab66be987	false	0x	238	0xb137e7d16564c81ae2b0c8ee6b55de81dd46ece5	22117224	Spark LBTC	2025-03-24T14:00:35.000Z	spLBTC	0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab	8	0x8236a87084f8b84306f72007f36f2618a5634494	0x4370d3b6c9588e02ce9d22e684387859c7ff5b34

Example Query

Query with partition filter

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

spToken_Mint_event

Mint events from Spark Protocol’s interest-bearing spToken contracts on Ethereum, recording deposit amounts, accrued interest balances, and recipient addresses. Enables tracking of lending pool deposits and yield accumulation across Spark’s money market positions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	removed	in_index	in_value	in_caller	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash	in_balanceIncrease
0x6715bc100a183cc65502f05845b589c1919ca3d3	false	1000000000000000000000000000	150000000000000000000000	0xa53a13a80d72a855481de5211e7654fabdfe3526	394	21601942	0xa53a13a80d72a855481de5211e7654fabdfe3526	2025-01-11T14:49:35.000Z	0x9c4555d316a2d398a6372965a9e2e30e6adbe5181014c87e73708335ee4f5296	0
0x3cfd5c0d4acaa8faee335842e4f31159fc76b008	false	1000000000000000000000000000	4255924522982780138	0xcd54cc88ac8bb4f437937b5dfa9c341570c6169b	255	21600711	0xcd54cc88ac8bb4f437937b5dfa9c341570c6169b	2025-01-11T10:41:59.000Z	0x697d3e0ded41645df89d267169f67083a3db421501322c76ea22dd019be8a150	0
0x12b54025c112aa61face2cdb7118740875a566e9	false	1000040217747267515389394109	15948147065998321492	0x8ed9e66a5cd8dde284038ecb17d3b82f0b557fa1	103	21598106	0x8ed9e66a5cd8dde284038ecb17d3b82f0b557fa1	2025-01-11T01:57:59.000Z	0x989afbdcefc42289123c255d16933419da13e7f3963356e01da414dc7fe17d0c	1001744187466

Example Query

Query with partition filter

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

spUSDC_Deposit_event

Deposit events from Spark Protocol’s spUSDC vault on Ethereum, recording USDC deposits with corresponding share mints. Used for analyzing vault inflows, depositor behavior, and share-to-asset conversion rates.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d	false	0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c	1006394	0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c	1006394	291	23597347	2025-10-17T12:21:35.000Z	0x975e9153a4cfb29152f12f53c2a6652a0162c1bfa7aa3b8e192fdf9685df23cb
0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d	false	0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c	1000000	0xdeeef33399ea7a96c0b53e1b9f476c539bf9d51c	1000000	289	23597359	2025-10-17T12:23:59.000Z	0xe55f2f6561194142842d728c01786dec1d0df88759b5f9907b8b915cd75b1b06
0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d	false	0x0000aa99e12ad566e4c97882296076023d123cfe	390000000000	0x0000aa99e12ad566e4c97882296076023d123cfe	389187611641	430	23742330	2025-11-06T19:28:47.000Z	0x098d2f0bf15e66c815cd5178ad750f253f8ed75c996f7615979cd8372d09dc5f

Example Query

Query with partition filter

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

spUSDC_Withdraw_event

Withdrawal events from the Spark v1 USDC vault (spUSDC) on Ethereum, recording when users redeem vault shares for underlying USDC assets. Tracks the conversion between shares and assets for analyzing vault redemption activity and share price 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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d	false	0x18dff5b53cb6c4a5bddd0b7f0396a4210a2cff90	73042363029	0x18dff5b53cb6c4a5bddd0b7f0396a4210a2cff90	73026654785	188	0x18dff5b53cb6c4a5bddd0b7f0396a4210a2cff90	23633508	2025-10-22T13:57:35.000Z	0x126c5434a953d55c581a625a36d85b63bb10d61357b9b73aa7f576b6b1743f1e
0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d	false	0x83a05e2f45105d88ea0f505544cd8df0b547c1d0	8985973101	0x83a05e2f45105d88ea0f505544cd8df0b547c1d0	8983883869	613	0x83a05e2f45105d88ea0f505544cd8df0b547c1d0	23634483	2025-10-22T17:15:11.000Z	0x7762972b095a0762b9f2456d6abb30eeb21e967f830eba4dc4ad3405a7b7b4e2
0x28b3a8fb53b741a8fd78c0fb9a6b2393d896a43d	false	0x87062ea097b5927bfe3e27d1fe9b4ad4d93f6475	2170000000	0x87062ea097b5927bfe3e27d1fe9b4ad4d93f6475	2169580144	730	0x87062ea097b5927bfe3e27d1fe9b4ad4d93f6475	23632300	2025-10-22T09:53:11.000Z	0x30b43dbdc2bf4372d4109674b8c7765f5fc2935f48c9f45c2dc6a50e5d8a242f

Example Query

Query with partition filter

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

spUSDT_Deposit_event

Deposit events from Spark Protocol’s spUSDT vault on Ethereum, recording USDT deposits with corresponding share issuance. Tracks vault interactions including depositor addresses, asset amounts (6 decimals), and shares minted for analyzing yield strategy participation and liquidity flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	block_number	block_timestamp	transaction_hash
0xe2e7a17dff93280dec073c995595155283e3c372	false	0x2869f0a4a8b63b9d3357588074fb9ffa2d87b985	5200000000	0x2869f0a4a8b63b9d3357588074fb9ffa2d87b985	5194229909	162	23684533	2025-10-29T17:26:47.000Z	0xedd12f40ae5ee56ea667e2dc6d632736d91f947cf976bfeea0538ef543b12d63
0xe2e7a17dff93280dec073c995595155283e3c372	false	0x523b19b99d60ff8345c314b0987ac4499b3bd077	15599976347	0x523b19b99d60ff8345c314b0987ac4499b3bd077	15582973558	659	23683361	2025-10-29T13:31:11.000Z	0x086f2c2b0e5016b6cc0914e4274d58a6d57c7334c100fb99d427571a58358460
0xe2e7a17dff93280dec073c995595155283e3c372	false	0x5d4ad877d2442dc69dfd4c8576d45249784272e9	99998325326	0x5d4ad877d2442dc69dfd4c8576d45249784272e9	99894795785	209	23680126	2025-10-29T02:38:23.000Z	0x06903d80b13e96e025cdb19a5ee7f78907c6a83f6bec59e7d981532c8caa4f66

Example Query

Query with partition filter

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

spUSDT_Withdraw_event

Withdrawal events from Spark Protocol’s USDT vault (spUSDT) on Ethereum, tracking share redemptions with corresponding asset amounts, owner addresses, and receivers. Used for analyzing vault outflows and calculating share-to-asset conversion rates.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_assets`	`STRING`	Number of asset units involved in the deposit or withdrawal transaction. String-encoded integer representing the asset quantity in the protocol’s accounting system.
`in_shares`	`STRING`	Number of shares involved in the deposit or withdrawal transaction. String-encoded integer representing the share quantity in the protocol’s accounting system.

Sample Data

address	removed	in_owner	in_assets	in_sender	in_shares	log_index	in_receiver	block_number	block_timestamp	transaction_hash
0xe2e7a17dff93280dec073c995595155283e3c372	false	0x9b1d7c56c53c6b6f5cdd26f8f9fa021bd0d51e74	101120896	0x9b1d7c56c53c6b6f5cdd26f8f9fa021bd0d51e74	100966900	509	0x9b1d7c56c53c6b6f5cdd26f8f9fa021bd0d51e74	23709052	2025-11-02T03:47:59.000Z	0x3605084f321a6d62ce1f4806e5d742bb75ac85ff3a6076808a99cff194d9c9b7
0xe2e7a17dff93280dec073c995595155283e3c372	false	0xd900411debddaa5483cd5832f4102556df70dc96	10000076636	0xd900411debddaa5483cd5832f4102556df70dc96	9993669335	107	0xd900411debddaa5483cd5832f4102556df70dc96	23657418	2025-10-25T22:20:47.000Z	0x6571634c996cd72e6ecaa08e5029e9540589e5fc7a1297309e443fbdbb697ec3
0xe2e7a17dff93280dec073c995595155283e3c372	false	0x15775b23340c0f50e0428d674478b0e9d3d0a759	10006	0x15775b23340c0f50e0428d674478b0e9d3d0a759	10000	136	0x15775b23340c0f50e0428d674478b0e9d3d0a759	23659979	2025-10-26T06:55:11.000Z	0x1bf9f0b668f8247ca717e062befdd9e52ca2c7040b9a53255c256b408d90fc89

Example Query

Query with partition filter

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

StableDebtToken_Burn_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_from`	`STRING`	Address originating the transfer 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_currentBalance`	`STRING`	User’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_avgStableRate`	`STRING`	Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
`in_newTotalSupply`	`STRING`	Updated total supply of stable debt tokens after the 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.spark_v1_ethereum.StableDebtToken_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StableDebtToken_Initialized_event

Initialization events for stable-rate debt tokens in Spark Protocol lending markets on Ethereum, capturing token metadata including name, symbol, decimals, and associated pool and underlying asset addresses. Used for tracking new debt token deployments and market expansions.

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_underlyingAsset`	`STRING`	Contract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_incentivesController`	`STRING`	Contract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtTokenDecimals`	`INT64`	Number of decimal places for the debt token. Integer value matching the precision of the underlying asset.
`in_debtTokenName`	`STRING`	Human-readable name of the debt token being initialized in the lending protocol.
`in_debtTokenSymbol`	`STRING`	Ticker symbol for the debt token being initialized in the lending protocol.
`in_params`	`STRING`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.

Sample Data

address	in_pool	removed	in_params	log_index	block_number	block_timestamp	in_debtTokenName	transaction_hash	in_debtTokenSymbol	in_underlyingAsset	in_debtTokenDecimals	in_incentivesController
0xbf13910620722d4d4f8a03962894eb3335bf4fae	0xc13e21b648a5ee794902342038ff3adab66be987	false	0x	374	17365842	2023-05-29T16:30:59.000Z	Spark Stable Debt GNO	0x87ab228bf3cbe6c6f763b0f66e6252a0ff90654ebdfaeaf7fdd31a28e2d16bb6	stableDebtGNO	0x6810e776880c02933d47db1b9fc05908e5386b96	18	0x0000000000000000000000000000000000000000
0xfbaf333a919cb92caf9e85966d4e28fff80e5d1d	0xc13e21b648a5ee794902342038ff3adab66be987	false	0x	239	22117224	2025-03-24T14:00:35.000Z	Spark Stable Debt LBTC	0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab	stableDebtLBTC	0x8236a87084f8b84306f72007f36f2618a5634494	8	0x4370d3b6c9588e02ce9d22e684387859c7ff5b34
0x1b16e95958e06291c028e709727f8b0bb56451d3	0xc13e21b648a5ee794902342038ff3adab66be987	false	0x	251	22117224	2025-03-24T14:00:35.000Z	Spark Stable Debt rsETH	0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab	stableDebtrsETH	0xa1290d69c65a6fe4df752f95823fae25cb99e5a7	18	0x4370d3b6c9588e02ce9d22e684387859c7ff5b34

Example Query

Query with partition filter

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

StableDebtToken_Mint_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_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the 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_currentBalance`	`STRING`	User’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_newRate`	`STRING`	Updated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
`in_avgStableRate`	`STRING`	Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
`in_newTotalSupply`	`STRING`	Updated total supply of stable debt tokens after the 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.spark_v1_ethereum.StableDebtToken_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StakingRewards_Recovered_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.spark_v1_ethereum.StakingRewards_Recovered_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StakingRewards_Referral_event

Referral reward events from Spark Protocol’s staking contract on Ethereum, tracking reward amounts distributed to users through the referral program. Used for analyzing referral incentive distribution and user acquisition economics.

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_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol 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_amount	log_index	in_referral	block_number	block_timestamp	transaction_hash
0x173e314c7635b45322cd8cb14f44b312e079f3af	0x55e55c649895940826a852820d9e1a076ec47b09	false	10000000000000000000	96	1	22796704	2025-06-27T15:35:35.000Z	0x98c4eb625f8e1031d7bcf55359eedc282004e06f853c0a4d22799f6ee2c6630a
0x173e314c7635b45322cd8cb14f44b312e079f3af	0xcc95127fe5195c9deee63fb7ab921dbdcbbb8c8b	false	1036537158726295518601	139	1	22847827	2025-07-04T19:04:59.000Z	0x7efd9048b55b66d479c798cb6f1d76a065a9ec48b05a4d47f99fbff71cdcd0a9
0x173e314c7635b45322cd8cb14f44b312e079f3af	0x6ae4e505c3e1f56014d5e3a5b73aeffbf71b03f4	false	132796426604018922690	231	1	22843191	2025-07-04T03:33:23.000Z	0xd1d04214338cf2cb01254daf11ee0f8d31b65ee70f09f440e731dab86beedf0c

Example Query

Query with partition filter

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

StakingRewards_RewardAdded_event

RewardAdded events from Spark Protocol v1 staking contracts on Ethereum, capturing when new reward tokens are allocated to staking pools. Used for tracking reward distribution schedules and analyzing staking incentive programs.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x173e314c7635b45322cd8cb14f44b312e079f3af	false	21688679604261796042617960	139	22967140	2025-07-21T11:02:23.000Z	0xf0af1f60548794fe82d785a92b1d50c824075acb959a99e90b645dfc85679325
0x173e314c7635b45322cd8cb14f44b312e079f3af	false	21685216894977168949771690	1012	23216211	2025-08-25T06:05:11.000Z	0x87a5829941cb71f0b1f57d434171b175474432a414b865bbc8221f3a019fde08
0x173e314c7635b45322cd8cb14f44b312e079f3af	false	21691276636225266362252663	313	23315890	2025-09-08T04:08:35.000Z	0xeeaf316b5b998e0a0d57d2a13ce0d653d8ac13d510318b991711af145cc45ea8

Example Query

Query with partition filter

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

StakingRewards_RewardPaid_event

Reward distribution events from StakingRewards contracts recording when staked positions earn incentives. Contains recipient address, reward amount, and optional token or position identifiers for tracking yield distribution across protocols.

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_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	transaction_hash
0x173e314c7635b45322cd8cb14f44b312e079f3af	0x01c2f22754e1c2cc64a18ba6162e5c7d417fff7f	false	9045209254313298181749	439	22945050	2025-07-18T09:00:23.000Z	0xda59689cb1f084c6ad6b83d90711b0870b3cef4a8ba9ec09255b1b682444412e
0x173e314c7635b45322cd8cb14f44b312e079f3af	0x05654ff0cb3635fa5de00cc11607dbf203435c13	false	5939368676934709111434	419	22947232	2025-07-18T16:18:35.000Z	0x3f86b86a444712cbe85f1422f1d70cfcbcc921a4039e986d8504f9bcbc742b98
0x173e314c7635b45322cd8cb14f44b312e079f3af	0x0ee69a11b4391c5af5eb2fb088c2df5dd2a0d075	false	5117416871734860743663	165	22945052	2025-07-18T09:00:47.000Z	0x46a994e6ca1079928303fe518fa74aaba4ccf540b7004035b4d26902051f61c6

Example Query

Query with partition filter

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

StakingRewards_RewardsDistributionUpdated_event

Events emitted when the rewards distribution address is updated in Spark v1 staking contracts on Ethereum. Tracks administrative changes to the address authorized to distribute staking rewards.

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_newRewardsDistribution`	`STRING`	The new rewards distribution contract address that was set in this update event. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the contract authorized to distribute staking rewards.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newRewardsDistribution
0x173e314c7635b45322cd8cb14f44b312e079f3af	false	143	22817692	2025-06-30T14:00:23.000Z	0x666eb7807c1b4098f9b91658eb008e8931063c5050e4dbe28bd6fac3a2948d02	0x3959e23a63ca7ac12d658bb44f90cb1f7ee4c02c

Example Query

Query with partition filter

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

StakingRewards_RewardsDurationUpdated_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_newDuration`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

StakingRewards_Staked_event

Staking deposit events from Spark v1 protocol on Ethereum, capturing user addresses and token amounts when positions are created. Tracks individual stake transactions with wei-denominated amounts for analyzing protocol TVL (Total Value Locked) growth and user deposit patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol 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_amount	log_index	block_number	block_timestamp	transaction_hash
0x173e314c7635b45322cd8cb14f44b312e079f3af	0x01149169454715c5ccaf0a47dc53f8cdd2412d54	false	1444585731525000000000000	129	22975795	2025-07-22T16:05:23.000Z	0x5ec39f2891522e3aca1716464f33d5c8e387be56cfb1c691a10ccd8f6298b44b
0x173e314c7635b45322cd8cb14f44b312e079f3af	0x01149169454715c5ccaf0a47dc53f8cdd2412d54	false	500007014999000000000000	482	22975293	2025-07-22T14:24:11.000Z	0xb3de329060e51dc930995c8f002bb7bed2858b3758f9a66863764543423a9c9b
0x173e314c7635b45322cd8cb14f44b312e079f3af	0x01857b094e58e94f4fea0ba506b8475504910a8f	false	6936413950793426583425	52	22974989	2025-07-22T13:22:59.000Z	0x2df10a59e970af47915d162340b6f5809ad7fe5af5fe23cb65ab1af18925d7fc

Example Query

Query with partition filter

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

StakingRewards_Withdrawn_event

Staking reward withdrawal events from Spark protocol on Ethereum, recording when users withdraw their earned rewards with withdrawal amounts and user addresses. Used for tracking reward distribution patterns and participant behavior in the Spark staking program.

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_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_amount	log_index	block_number	block_timestamp	transaction_hash
0x173e314c7635b45322cd8cb14f44b312e079f3af	0x05654ff0cb3635fa5de00cc11607dbf203435c13	false	1169901075004693273519325	135	23256284	2025-08-30T20:16:11.000Z	0xd15692432e717484814f30ccd02aac4606af712c912b72f5ee9b3c4eaa76e904
0x173e314c7635b45322cd8cb14f44b312e079f3af	0x0ee69a11b4391c5af5eb2fb088c2df5dd2a0d075	false	50228656577589786091	436	23254054	2025-08-30T12:48:23.000Z	0x5dad783fa19913e4dc5644ff2dfa9f4687cc0c3fa24e8d219d8093c6537adfac
0x173e314c7635b45322cd8cb14f44b312e079f3af	0x198a2e8b12bb4f12e7f7a0d154dced16c7967c07	false	50000000000000000000000	1990	23254057	2025-08-30T12:48:59.000Z	0xd18896e01897fd023c4d7410da60007d8b49ca5b5eab80dcd65301ee519b150a

Example Query

Query with partition filter

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

sUSDC_Deposit_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	-
`block_number`	`INT64`	-
`transaction_hash`	`STRING`	-
`log_index`	`INT64`	-
`address`	`STRING`	-
`removed`	`BOOL`	-
`in_sender`	`STRING`	-
`in_owner`	`STRING`	-
`in_assets`	`STRING`	-
`in_shares`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

sUSDC_Withdraw_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	-
`block_number`	`INT64`	-
`transaction_hash`	`STRING`	-
`log_index`	`INT64`	-
`address`	`STRING`	-
`removed`	`BOOL`	-
`in_sender`	`STRING`	-
`in_receiver`	`STRING`	-
`in_owner`	`STRING`	-
`in_assets`	`STRING`	-
`in_shares`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

VariableDebtToken_Burn_event

Variable rate debt token burn events emitted when users repay borrowed assets in lending protocols. Records the debt amount repaid, accumulated interest, and liquidity index at the time of repayment for tracking variable-rate loan lifecycle and interest accrual.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash	in_balanceIncrease
0xd5c3e3b566a42a6110513ac7670c1a86d76e13e6	0x6236b9a8477d934dd1bfc9899bd8a11b8a670afc	false	1001258000703429566284182985	39967287531874684	0x0000000000000000000000000000000000000000	355	17928923	2023-08-16T17:37:23.000Z	0x8ea2cd21490c467e469c2fc3fc0521e7901e6c4452b467914f4fcc04ffe08fd1	32712468125316
0xf705d2b7e92b3f38e6ae7afadaa2fee110fe5914	0x171c53d55b1bcb725f660677d9e8bad7fd084282	false	1007769838259551760529283171	977385044138115928718613	0x0000000000000000000000000000000000000000	219	17930291	2023-08-16T22:12:35.000Z	0x92da596a465939987619838f8b3e86627113932156618348023913fd7558a471	22614955861884071281387
0xf705d2b7e92b3f38e6ae7afadaa2fee110fe5914	0xd3cbf4408c97f8de3c54e16b425e520d87760cdd	false	1007750391002041397404600634	500000000000000000000	0x0000000000000000000000000000000000000000	277	17928687	2023-08-16T16:49:35.000Z	0x71663511810777dd51c99b14ed2c51265ed70e07d79b525bebe00305a142fac4	273400302989964253

Example Query

Query with partition filter

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

VariableDebtToken_Initialized_event

Variable debt token initialization events from Spark lending protocol on Ethereum, recording when new borrowable assets are added to the pool. Tracks token metadata (symbols like variableDebtUSDC, variableDebtGNO), underlying asset addresses, and incentive controller configurations for analyzing protocol expansion and supported collateral types.

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_underlyingAsset`	`STRING`	Contract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_incentivesController`	`STRING`	Contract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtTokenDecimals`	`INT64`	Number of decimal places for the debt token. Integer value matching the precision of the underlying asset.
`in_debtTokenName`	`STRING`	Human-readable name of the debt token being initialized in the lending protocol.
`in_debtTokenSymbol`	`STRING`	Ticker symbol for the debt token being initialized in the lending protocol.
`in_params`	`STRING`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.

Sample Data

address	in_pool	removed	in_params	log_index	block_number	block_timestamp	in_debtTokenName	transaction_hash	in_debtTokenSymbol	in_underlyingAsset	in_debtTokenDecimals	in_incentivesController
0x57a2957651da467fcd4104d749f2f3684784c25a	0xc13e21b648a5ee794902342038ff3adab66be987	false	0x	375	17365842	2023-05-29T16:30:59.000Z	Spark Variable Debt GNO	0x87ab228bf3cbe6c6f763b0f66e6252a0ff90654ebdfaeaf7fdd31a28e2d16bb6	variableDebtGNO	0x6810e776880c02933d47db1b9fc05908e5386b96	18	0x0000000000000000000000000000000000000000
0x764591dc9ba21c1b92049331b80b6e2a2acf8b17	0xc13e21b648a5ee794902342038ff3adab66be987	false	0x	244	22117224	2025-03-24T14:00:35.000Z	Spark Variable Debt tBTC	0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab	variableDebttBTC	0x18084fba666a33d37592fa2633fd49a74dd93a88	18	0x4370d3b6c9588e02ce9d22e684387859c7ff5b34
0xb0b14dd477e6159b4f3f210cf45f0954f57c0fab	0xc13e21b648a5ee794902342038ff3adab66be987	false	0x	248	22117224	2025-03-24T14:00:35.000Z	Spark Variable Debt ezETH	0xfa915f838ad5b31fe05d1f31669af9496e65c5cc0656695298bd14dc8b6793ab	variableDebtezETH	0xbf5495efe5db9ce00f80364c8b423567e58d2110	18	0x4370d3b6c9588e02ce9d22e684387859c7ff5b34

Example Query

Query with partition filter

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

VariableDebtToken_Mint_event

Variable debt token minting events from lending protocols recording debt issuance to borrowers. Contains borrower address, delegated beneficiary, debt amount, and liquidity index in ray units (1e27) for tracking compounding interest on variable-rate loans.

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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	removed	in_index	in_value	in_caller	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash	in_balanceIncrease
0x2e7576042566f8d6990e07a1b61ad1efd86ae70d	false	1016183352447502092972378895	35000428362340379709	0xbd7d6a9ad7865463de44b05f04559f65e3b11704	238	18360149	0xdd84ce1adcb3a4908db61a1dfa3353c3974c5a2b	2023-10-16T03:08:23.000Z	0x9b303ba5173d383a0884db634ac4efe99f08de6a290ca658451829ce98d6e3d6	428362340379709
0x2e7576042566f8d6990e07a1b61ad1efd86ae70d	false	1016182193850258646390086116	75248032398002238826	0xbd7d6a9ad7865463de44b05f04559f65e3b11704	198	18360051	0xdd84ce1adcb3a4908db61a1dfa3353c3974c5a2b	2023-10-16T02:48:35.000Z	0xf6035c8ee2e87e8a536bb2fcdbaacbfe00aa9e02710fafd5db0a2955fc6297ac	248032398002238826
0x2e7576042566f8d6990e07a1b61ad1efd86ae70d	false	1016195726834655588510924497	30005001326125201254	0xbd7d6a9ad7865463de44b05f04559f65e3b11704	122	18361203	0xdd84ce1adcb3a4908db61a1dfa3353c3974c5a2b	2023-10-16T06:39:47.000Z	0x0635df3d6fb1789d7232e53d72faee41fa5774b47e46172842ce273340ac6b8a	5001326125201254

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​LendingPoolConfigurator_CollateralConfigurationChanged_event

​LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​Pool_BackUnbacked_event

​Pool_Borrow_event

​Pool_FlashLoan_event

​Pool_IsolationModeTotalDebtUpdated_event

​Pool_LiquidationCall_event

​Pool_MintedToTreasury_event

​Pool_MintUnbacked_event

​Pool_Repay_event

​Pool_ReserveDataUpdated_event

​Pool_Supply_event

​Pool_Withdraw_event

​PoolConfigurator_FlashloanPremiumToProtocolUpdated_event

​PoolConfigurator_LiquidationProtocolFeeChanged_event

​PoolConfigurator_ReserveFactorChanged_event

​PoolConfigurator_ReserveInitialized_event

​spETH_Deposit_event

​spETH_Withdraw_event

​spPYUSD_Deposit_event

​spPYUSD_Withdraw_event

​spToken_BalanceTransfer_event

​spToken_Burn_event

​spToken_Initialized_event

​spToken_Mint_event

​spUSDC_Deposit_event

​spUSDC_Withdraw_event

​spUSDT_Deposit_event

​spUSDT_Withdraw_event

​StableDebtToken_Burn_event

​StableDebtToken_Initialized_event

​StableDebtToken_Mint_event

​StakingRewards_Recovered_event

​StakingRewards_Referral_event

​StakingRewards_RewardAdded_event

​StakingRewards_RewardPaid_event

​StakingRewards_RewardsDistributionUpdated_event

​StakingRewards_RewardsDurationUpdated_event

​StakingRewards_Staked_event

​StakingRewards_Withdrawn_event

​sUSDC_Deposit_event

​sUSDC_Withdraw_event

​VariableDebtToken_Burn_event

​VariableDebtToken_Initialized_event

​VariableDebtToken_Mint_event

Tables

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

Pool_BackUnbacked_event

Pool_Borrow_event

Pool_FlashLoan_event

Pool_IsolationModeTotalDebtUpdated_event

Pool_LiquidationCall_event

Pool_MintedToTreasury_event

Pool_MintUnbacked_event

Pool_Repay_event

Pool_ReserveDataUpdated_event

Pool_Supply_event

Pool_Withdraw_event

PoolConfigurator_FlashloanPremiumToProtocolUpdated_event

PoolConfigurator_LiquidationProtocolFeeChanged_event

PoolConfigurator_ReserveFactorChanged_event

PoolConfigurator_ReserveInitialized_event

spETH_Deposit_event

spETH_Withdraw_event

spPYUSD_Deposit_event

spPYUSD_Withdraw_event

spToken_BalanceTransfer_event

spToken_Burn_event

spToken_Initialized_event

spToken_Mint_event

spUSDC_Deposit_event

spUSDC_Withdraw_event

spUSDT_Deposit_event

spUSDT_Withdraw_event

StableDebtToken_Burn_event

StableDebtToken_Initialized_event

StableDebtToken_Mint_event

StakingRewards_Recovered_event

StakingRewards_Referral_event

StakingRewards_RewardAdded_event

StakingRewards_RewardPaid_event

StakingRewards_RewardsDistributionUpdated_event

StakingRewards_RewardsDurationUpdated_event

StakingRewards_Staked_event

StakingRewards_Withdrawn_event

sUSDC_Deposit_event

sUSDC_Withdraw_event

VariableDebtToken_Burn_event

VariableDebtToken_Initialized_event

VariableDebtToken_Mint_event