spark_v1_gnosis

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
7000	0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	56	30326012	2023-10-06T15:19:55.000Z	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672	10500	7500
7000	0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	61	30326012	2023-10-06T15:19:55.000Z	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672	10500	7500
4000	0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0x9c58bacc331c9aa871afd802db6379a98e80cedb	71	30326012	2023-10-06T15:19:55.000Z	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672	11200	5000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spark_v1_gnosis.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
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0xaf204776c7245bf4147c2612bf6e5972ee483701	1000	57	33673178	2024-04-28T13:09:15.000Z	0xb65ef7c3e3a44718af6b84fe5582aec7e8916d67bb1822f2ec40442dc8fd1d86
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	1000	57	30326012	2023-10-06T15:19:55.000Z	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0x6c76971f98945ae98dd7d4dfca8711ebea946ea6	1000	67	30326012	2023-10-06T15:19:55.000Z	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spark_v1_gnosis.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
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	64	33673178	2024-04-28T13:09:15.000Z	0xb65ef7c3e3a44718af6b84fe5582aec7e8916d67bb1822f2ec40442dc8fd1d86	500
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0x4ecaba5870353805a9f068101a40e0f32ed605c6	48	33673178	2024-04-28T13:09:15.000Z	0xb65ef7c3e3a44718af6b84fe5582aec7e8916d67bb1822f2ec40442dc8fd1d86	1000
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0xcb444e90d8198415266c6a2724b7900fb12fc56e	54	33673178	2024-04-28T13:09:15.000Z	0xb65ef7c3e3a44718af6b84fe5582aec7e8916d67bb1822f2ec40442dc8fd1d86	1000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spark_v1_gnosis.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
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0xcb444e90d8198415266c6a2724b7900fb12fc56e	0x6dc304337bf3eb397241d1889cae7da638e6e782	24	33673178	2024-04-28T13:09:15.000Z	0xb65ef7c3e3a44718af6b84fe5582aec7e8916d67bb1822f2ec40442dc8fd1d86	0x80f87b8f9c1199e468923d8ee87cee311690fda6	0x0b33480d3fbd1e2dbe88c82aabe191d7473759d5	0x3bb9d175d3393a537760d08da0a77a76f1d2c9d4
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0x4ecaba5870353805a9f068101a40e0f32ed605c6	0x08b0caebe352c3613302774cd9b82d08afd7bdc4	20	33673178	2024-04-28T13:09:15.000Z	0xb65ef7c3e3a44718af6b84fe5582aec7e8916d67bb1822f2ec40442dc8fd1d86	0x4cb3f681b5e393947bd1e5cae84764f5892923c2	0x3a98abc6f46ca2fc6c7d06ed02184d63c55e19b2	0x589cf38424ba8852c03b3cee201a38c95f35ede4
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0xddafbb505ad214d7b80b1f830fccc89b60fb7a83	0x5850d127a04ed0b4f1fcdfb051b3409fb9fe6b90	16	33673178	2024-04-28T13:09:15.000Z	0xb65ef7c3e3a44718af6b84fe5582aec7e8916d67bb1822f2ec40442dc8fd1d86	0x40bf0bf6aecee50ece10c74e81a52c654a467ae4	0xbc4f20daf4e05c17e93676d2cec39769506b8219	0x589cf38424ba8852c03b3cee201a38c95f35ede4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spark_v1_gnosis.LendingPoolConfigurator_ReserveInitialized_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
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0xfb04df5bc87a78ebcfaa207847da146bd2a7d390	false	10000000000000000000000	248	0xcb444e90d8198415266c6a2724b7900fb12fc56e	34058981	28666319373598217667867961	0xfb04df5bc87a78ebcfaa207847da146bd2a7d390	2024-05-21T13:43:05.000Z	0x66e6cef95a1fcd0710858668af412bf6d56a09e9b200b93de55e6a35c7a4bb9e	2
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0x9988e315a285979ab53078ae302171375e3d6869	false	480000000000000000000	22	0xcb444e90d8198415266c6a2724b7900fb12fc56e	34060063	28741053001050163908941604	0x9988e315a285979ab53078ae302171375e3d6869	2024-05-21T15:14:45.000Z	0x63e8e34e3f1ddf622207cce41e01d39973f8e8385d7f7d29d0502c8d7cd43daf	2
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0xb354af60d85e5fe431facdbb9388e4e4f70e1bbd	false	3000000000	38	0xddafbb505ad214d7b80b1f830fccc89b60fb7a83	34061126	39607135028518310849072432	0xb354af60d85e5fe431facdbb9388e4e4f70e1bbd	2024-05-21T16:45:30.000Z	0x2938550d8b91f775da79c613c65bb99380f2a2b5b02aecfa780143873a684116	2

Example Query

Query with partition filter

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

Pool_FlashLoan_event

Flash loan execution events from Spark Protocol (Aave v3 fork) lending pools on Gnosis Chain. Tracks uncollateralized loans with asset borrowed, amount, initiator address, premium fees, and target contract for analyzing arbitrage activity and protocol integrations.

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	transaction_hash
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	0xaf204776c7245bf4147c2612bf6e5972ee483701	7207207207207206649856	0xbc5af6918f200220b2961171085e742580613a9b	13	38039164	0xbc5af6918f200220b2961171085e742580613a9b	2025-01-14T15:21:55.000Z	0x08887f78155e297832f619911fc82766734393989e3b0d433ad4bd33b13a2ae5
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	0xaf204776c7245bf4147c2612bf6e5972ee483701	900900900900900864000	0xbc5af6918f200220b2961171085e742580613a9b	19	38040703	0xbc5af6918f200220b2961171085e742580613a9b	2025-01-14T17:34:20.000Z	0xa93652ea8b2608e8d64c8821646c0f462f9581d77b84051b3be831ffac83a3b2
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	0xaf204776c7245bf4147c2612bf6e5972ee483701	12612612612612611637248	0xbc5af6918f200220b2961171085e742580613a9b	19	38034449	0xbc5af6918f200220b2961171085e742580613a9b	2025-01-14T08:33:45.000Z	0xfa25a0d7e38f7844b8a3e31eeaffa7078891dbe5a6f1cc81f332ff92c8a0e5d2

Example Query

Query with partition filter

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

Pool_LiquidationCall_event

Liquidation events from Spark Protocol lending pools on Gnosis Chain, capturing debt repayment and collateral seizure when borrower positions fall below required health ratios. Used for tracking liquidator activity, collateral volatility risk, and protocol solvency metrics.

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
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0xc1d36d8a11f3c7194b7da63fbc0360e35cc70ce0	false	17	39832710	0xcb444e90d8198415266c6a2724b7900fb12fc56e	0xa0085d1f87b3407ce9ee562c392784ce0363c648	2211034496727545384712	2025-04-30T22:48:25.000Z	false	0x7f105615e07cbba9e515800237085e2d0658016a979a558e7bddaa846d0cd390	0xaf204776c7245bf4147c2612bf6e5972ee483701	2246523427019869187217
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0x6c6405a0ed4f0bd466d0dd021eb2a161587fdc39	false	37	37369002	0x6c76971f98945ae98dd7d4dfca8711ebea946ea6	0x6ba8626d414fc06eab8665b54386b6b0546a86f5	58550585774849	2024-12-05T10:45:00.000Z	false	0xb577330304cb92f7c0e638198fb7826061266bc582358675c45326a9fa27ca9d	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	285616134020763665
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0xdd51487faa89e0af00d48ccdb7c26afa4438cd34	false	267	41544283	0x6c76971f98945ae98dd7d4dfca8711ebea946ea6	0x68a2fb0ce276795842030e5a426a3863389b3eec	56678847681816	2025-08-11T04:16:50.000Z	false	0x9e69884e539ee465d23cc05cc9474e07b023d4c1f84c1d4f12062ea193a1104d	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	310332138749475183

Example Query

Query with partition filter

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

Pool_MintedToTreasury_event

Treasury fee minting events from Spark Protocol lending pools on Gnosis Chain, recording reserve addresses and token amounts transferred to the protocol treasury. Used for tracking protocol revenue and fee accrual across different reserve assets.

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
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	2976	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	30882583	2023-11-10T10:28:25.000Z	52723364962911285	0x610361e39c851bfb583eedc17bd52d617de024432dff4191c648d6e5d30ce85a

Example Query

Query with partition filter

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

Pool_Repay_event

Loan repayment events from Spark Protocol (Aave v3 fork) lending pools on Gnosis Chain. Tracks debt repayments with borrower, repayer, reserve asset, and amount data for analyzing loan lifecycle and liquidation 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_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
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0xd022ce8e78fc9b6f8fc2a35b3f0f331ceccbe1df	false	365000000000000000000	2182	0xbd7d6a9ad7865463de44b05f04559f65e3b11704	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	33475206	false	2024-04-16T16:14:30.000Z	0x549a620d2e782287d2db7076b1805f4c1086c80c0af5f535301e29e76565bdc5
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0x2e906fffc993b20c3556d402d8f2bbb3fb6ebea4	false	2461614315520392889611	601	0x2e906fffc993b20c3556d402d8f2bbb3fb6ebea4	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	33475173	false	2024-04-16T16:11:40.000Z	0x6c841b7f2488067f6dd8230d98e655970e3036cc28be8325861aab56a60fdd5b
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0xad11d1b15f022f5b62b128153c38bfb71849bf5e	false	3209871454272116140	5	0xbd7d6a9ad7865463de44b05f04559f65e3b11704	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	37031354	false	2024-11-15T06:58:40.000Z	0x305be16407b04621fde6193026323209c5c31f12f579ee7b7369690c7ae87c04

Example Query

Query with partition filter

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

Pool_ReserveDataUpdated_event

Reserve data update events from Spark Protocol v1 lending pools on Gnosis Chain, capturing changes to liquidity rates, borrow rates, and index values for each reserve asset. Used for tracking lending market dynamics and calculating accurate interest accrual over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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	transaction_hash	in_liquidityIndex	in_variableBorrowIndex
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	89	0x9c58bacc331c9aa871afd802db6379a98e80cedb	40951053	2025-07-06T13:45:40.000Z	0xbd42510bd699da69f6a339a4d4ca53ecbe61d4120cd0386e8d8f5fad02f9df74	1000000000000000000000000000	1000000000000000000000000000
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	57	0x9c58bacc331c9aa871afd802db6379a98e80cedb	40951205	2025-07-06T13:58:40.000Z	0x2ea017c45625021bce4a280616a9eba144a604400aa0f99e2574d3997bd4c786	1000000000000000000000000000	1000000000000000000000000000
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	83	0x9c58bacc331c9aa871afd802db6379a98e80cedb	40951164	2025-07-06T13:55:10.000Z	0x983ed3a0b439aef77a295bada9df4116d5eab7269cdf84bf793292b11c2028e6	1000000000000000000000000000	1000000000000000000000000000

Example Query

Query with partition filter

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

Pool_Supply_event

Liquidity supply events from Spark Protocol (Aave v3 fork) on Gnosis Chain, recording deposits into lending pools with user addresses, asset reserves, supplied amounts, and optional referral codes. Used for analyzing lending protocol TVL growth, user deposit patterns, and referral program effectiveness.

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	in_referralCode	transaction_hash
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0xef18d342fae9c175e02a4ab6ed3a7d63f2255ac1	false	798936786445255	2599	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	31177748	0xef18d342fae9c175e02a4ab6ed3a7d63f2255ac1	2023-11-28T18:26:15.000Z	0	0x3f1812af18775795ee6a1a8325b57bc165b52c851131b578529a1ad939571819
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0xbd7d6a9ad7865463de44b05f04559f65e3b11704	false	2070000000000000000	2547	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	31174760	0x2893e8995c59662b2b9fa579582af3dc5a6c5884	2023-11-28T14:05:50.000Z	0	0x59f978ed404aedec58df97a302fabcb907c1bf91f3bc1ce2216cf34b89fb0ee6
0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0x017107ab195dbf52278413063156e51564f6578c	false	60000000000000000	5	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	37622143	0x017107ab195dbf52278413063156e51564f6578c	2024-12-20T12:15:05.000Z	128	0xf5dd2912649c4ac9f6ac9b6e594f489847e7589df05640d14cb54eaa1f2387bc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spark_v1_gnosis.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
0x6cae28b3d09d8f8fc74ccd496ac986fc84c0c24e	0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0x852fe5fa6d5e9e3dd45253799c662a94aebd4571	false	61539591040930282	1520	0x6c76971f98945ae98dd7d4dfca8711ebea946ea6	34938421	2024-07-13T03:02:10.000Z	0x914318cc94ee275441b2a4b8c7778239fc1f3d67d87b2a76e992396a5bda2606
0x36f4e1803f6ff34562db567f347dea00dec87246	0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0x36f4e1803f6ff34562db567f347dea00dec87246	false	2082456033338282830973	4	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	34937725	2024-07-13T02:03:05.000Z	0x6170312c9fc41e0c9a95b4bacf7681fb5b399d7c1f23ec5200b6bb3adf76fbd4
0xc1d36d8a11f3c7194b7da63fbc0360e35cc70ce0	0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	0xc1d36d8a11f3c7194b7da63fbc0360e35cc70ce0	false	8550527753688500453770	27	0xaf204776c7245bf4147c2612bf6e5972ee483701	34945615	2024-07-13T13:18:10.000Z	0xb7a38909c521787e577bb7475a8c3cad63cff7e151d6de565055f3620a00a47f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spark_v1_gnosis.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_gnosis.PoolConfigurator_FlashloanPremiumToProtocolUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PoolConfigurator_LiquidationProtocolFeeChanged_event

Liquidation protocol fee configuration changes from Spark Protocol (Aave v3 fork) on Gnosis Chain, tracking fee adjustments per asset with old and new values in basis points. Used for analyzing protocol fee policy changes and revenue model evolution across different 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_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
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0xaf204776c7245bf4147c2612bf6e5972ee483701	1000	57	33673178	2024-04-28T13:09:15.000Z	0xb65ef7c3e3a44718af6b84fe5582aec7e8916d67bb1822f2ec40442dc8fd1d86
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0x6c76971f98945ae98dd7d4dfca8711ebea946ea6	1000	67	30326012	2023-10-06T15:19:55.000Z	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0x9c58bacc331c9aa871afd802db6379a98e80cedb	1000	72	30326012	2023-10-06T15:19:55.000Z	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672

Example Query

Query with partition filter

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

PoolConfigurator_ReserveFactorChanged_event

Reserve factor parameter updates for lending pool assets on Spark Protocol (Gnosis Chain), tracking changes from protocol governance that affect interest allocation between lenders and the protocol treasury. Used for analyzing protocol fee adjustments and reserve management policy over time.

Columns

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

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spark_v1_gnosis.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) lending pool on Gnosis Chain, capturing when new assets are added with their corresponding aToken, stable/variable debt token addresses, and interest rate strategy contracts. Used for tracking pool composition changes and analyzing reserve deployment history.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0x2a22f9c3b484c3629090feed35f17ff8f88f76f0	0xa34db0ee8f84c4b90ed268df5abbe7dcd3c277ec	1506	34746301	2024-07-01T15:21:05.000Z	0x4d6d0f73ed28f646e634cd6d6b4122831b6d88cb7a53e7ccd80dc08e91160f52	0xc5dfde524371f9424c81f453260b2ccd24936c15	0x397b97b572281d0b3e3513bd4a7b38050a75962b	0xe66f24175a204e7286f0609cc594667d343e7aae
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	0xc9fe2d32e96bb364c7d29f3663ed3b27e30767bb	12	30326012	2023-10-06T15:19:55.000Z	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672	0xab1b62a1346acf534b581684940e2fd781f2ea22	0x868adfdf12a86422524eab6978beae08a0008f37	0x8b0271080d53f759ecc607f13316bdb3b86449e2
0x2fc8823e1b967d474b47ae0ad041c2ed562ab588	false	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	0x629d562e92fed431122e865cc650bc6bde6b96b0	16	30326012	2023-10-06T15:19:55.000Z	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672	0xe21bf3fb5a2b5bf7bae8c6f1696c4b097f5d2f93	0x0ad6ccf9a2e81d4d48ab7db791e9da492967eb84	0x0318c53bd3953c0fd1e8e8f9a68005002ed442d2

Example Query

Query with partition filter

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

spToken_BalanceTransfer_event

BalanceTransfer events from Spark Protocol spToken contracts on Gnosis Chain, tracking interest-bearing token transfers between accounts with indexed balance snapshots. Used for analyzing spToken holder movements, yield distribution flows, and liquidity provider activity across Spark 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_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	0xc9fe2d32e96bb364c7d29f3663ed3b27e30767bb	0x33878e070db7f70d2953fe0278cd32adf8104572	false	1047291754969060898249851815	95484376273881962179	4	35494171	2024-08-15T10:38:25.000Z	0xd61515c71ea5874cbe375afd2e54f495a7f0a649b964d555d647a603c2582d45
0xbd7d6a9ad7865463de44b05f04559f65e3b11704	0xc9fe2d32e96bb364c7d29f3663ed3b27e30767bb	0xb3341b14a49777026ea7e3878fbba8a31988e4b4	false	1096315636640753217594371446	835095267641434989	50	39492372	2025-04-10T19:39:50.000Z	0x4841085b2acb8ec4d1a25239203aa545f4fdbac26ddacf812b2c2ab96fea113f
0xbd279eeb1f29098d54b0b4d80b2da1242f79f97e	0x629d562e92fed431122e865cc650bc6bde6b96b0	0x4a8ba30870beed8084a274d1f4713657181e1e32	false	1000905282241531491347791550	1984502426690136	1015	31960171	2024-01-15T16:51:35.000Z	0x67a3b3280e2935fb184bf739ef7328dfd14a90802beed4079a9824bc5cb76153

Example Query

Query with partition filter

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

spToken_Burn_event

Token burn events from Spark Protocol (spToken) on Gnosis Chain recording withdrawals and redemptions. Tracks burned token amounts, user addresses, accrued interest (balanceIncrease), and redemption targets for analyzing protocol outflows and yield distribution.

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
0xc9fe2d32e96bb364c7d29f3663ed3b27e30767bb	0xbd7d6a9ad7865463de44b05f04559f65e3b11704	false	1022169246057712837921331353	5000000000000000	0xbd7d6a9ad7865463de44b05f04559f65e3b11704	1018	33588391	2024-04-23T11:27:45.000Z	0xfd192e49209d25b77f35839d4df47680193a1f3730cfe0725c5b82a9a26fb013
0x5671b0b8ac13dc7813d36b99c21c53f6cd376a14	0x468aa1c6c53bae70823c31042a1a00044a3be8b3	false	1000000000000000000000000000	107085569580579562786	0x468aa1c6c53bae70823c31042a1a00044a3be8b3	2737	33592130	2024-04-23T16:51:10.000Z	0x98616176a06a63bca3a4b47bae8327a785dea762305d83c8cb419d0e77e401cb
0xc9fe2d32e96bb364c7d29f3663ed3b27e30767bb	0xbd7d6a9ad7865463de44b05f04559f65e3b11704	false	1012404354039761162281844737	10094639405711369687	0xbd7d6a9ad7865463de44b05f04559f65e3b11704	2245	32729718	2024-03-02T16:38:10.000Z	0x4f98cee3fa26cb58ed9489290be927048b21c197b91f40795e6079d07d8a33b5

Example Query

Query with partition filter

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

spToken_Initialized_event

Initialization events for Spark Protocol interest-bearing tokens (spTokens) on Gnosis Chain, recording when new lending markets are created with their associated pool, treasury, and underlying asset addresses. Used for tracking protocol deployment and identifying available lending markets across different assets like USDC, WETH, GNO, and stablecoins.

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
0xa34db0ee8f84c4b90ed268df5abbe7dcd3c277ec	0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	0x	1503	0xb9e6dbfa4de19cced908bcbfe1d015190678ab5f	34746301	Spark USDC.e	2024-07-01T15:21:05.000Z	spUSDC.e	0x4d6d0f73ed28f646e634cd6d6b4122831b6d88cb7a53e7ccd80dc08e91160f52	6	0x2a22f9c3b484c3629090feed35f17ff8f88f76f0	0x98e6bcba7d5dafbfa4a92daf08d3d7512820c30c
0x5671b0b8ac13dc7813d36b99c21c53f6cd376a14	0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	0x	21	0xb9e6dbfa4de19cced908bcbfe1d015190678ab5f	30326012	Spark GNO	2023-10-06T15:19:55.000Z	spGNO	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672	18	0x9c58bacc331c9aa871afd802db6379a98e80cedb	0x98e6bcba7d5dafbfa4a92daf08d3d7512820c30c
0xc9fe2d32e96bb364c7d29f3663ed3b27e30767bb	0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	0x	9	0xb9e6dbfa4de19cced908bcbfe1d015190678ab5f	30326012	Spark WXDAI	2023-10-06T15:19:55.000Z	spWXDAI	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672	18	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	0x98e6bcba7d5dafbfa4a92daf08d3d7512820c30c

Example Query

Query with partition filter

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

spToken_Mint_event

Mint events for Spark Protocol interest-bearing tokens (spTokens) on Gnosis Chain, recording deposit amounts, accrued interest, and beneficiary addresses. Tracks lending pool deposits with balance increases from yield accrual for analyzing TVL 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_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
0xe877b96caf9f180916bf2b5ce7ea8069e0123182	false	1000000000000000000000000000	11608503130459470728188	0x9f894f3909ed3d9b2b3ea059590022b79642ea32	15	41632857	0x9f894f3909ed3d9b2b3ea059590022b79642ea32	2025-08-16T11:58:10.000Z	0xac2239c5a3c342b1f329b27af166d716c4f1abcf2f25438e60b0d711b61311a3	0
0xc9fe2d32e96bb364c7d29f3663ed3b27e30767bb	false	1120536961652153907295976683	1135994843792373594	0xbd7d6a9ad7865463de44b05f04559f65e3b11704	62	41639242	0x64eed4ffdc64dc82f069b255cd8e195f61da8ec1	2025-08-16T21:13:05.000Z	0xa876ee478ffd3f3f4225ba7944e979be685052d9673e1f54105d00bc9c5979df	1135994843792373594
0xe877b96caf9f180916bf2b5ce7ea8069e0123182	false	1000000000000000000000000000	1900000000000000000000	0xd33a9d186364d9a6e5b4432c985fc414fb51c1af	6	35511430	0xd33a9d186364d9a6e5b4432c985fc414fb51c1af	2024-08-16T12:04:15.000Z	0xed76294a37e3acdc2e0519c63f068b9aef3f4ce648b59bc543413332529f9ec9	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spark_v1_gnosis.spToken_Mint_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_gnosis.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 on Gnosis Chain, recording the creation of debt token contracts for various assets including stablecoins (USDC, USDT, EURe), wrapped tokens (WETH, wstETH), and native assets (GNO, WXDAI). Used for tracking protocol deployment and asset onboarding history.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x40bf0bf6aecee50ece10c74e81a52c654a467ae4	0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	0x	14	33673178	2024-04-28T13:09:15.000Z	Spark Stable Debt USDC	0xb65ef7c3e3a44718af6b84fe5582aec7e8916d67bb1822f2ec40442dc8fd1d86	stableDebtUSDC	0xddafbb505ad214d7b80b1f830fccc89b60fb7a83	6	0x98e6bcba7d5dafbfa4a92daf08d3d7512820c30c
0x4cb3f681b5e393947bd1e5cae84764f5892923c2	0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	0x	18	33673178	2024-04-28T13:09:15.000Z	Spark Stable Debt USDT	0xb65ef7c3e3a44718af6b84fe5582aec7e8916d67bb1822f2ec40442dc8fd1d86	stableDebtUSDT	0x4ecaba5870353805a9f068101a40e0f32ed605c6	6	0x98e6bcba7d5dafbfa4a92daf08d3d7512820c30c
0x2cf710377b3576287be7cf352ff75d4472902789	0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	0x	10	33673178	2024-04-28T13:09:15.000Z	Spark Stable Debt sDAI	0xb65ef7c3e3a44718af6b84fe5582aec7e8916d67bb1822f2ec40442dc8fd1d86	stableDebtsDAI	0xaf204776c7245bf4147c2612bf6e5972ee483701	18	0x98e6bcba7d5dafbfa4a92daf08d3d7512820c30c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spark_v1_gnosis.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_gnosis.StableDebtToken_Mint_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
0x0ad6ccf9a2e81d4d48ab7db791e9da492967eb84	0x23e51402ff300c8b70784fcee0ccea80968474e4	false	1003942428633544330102687818	499747584448843	0x0000000000000000000000000000000000000000	10	32086649	2024-01-23T10:30:55.000Z	0xc89f3cf762ac4828a1f5e863f14a8fe49151268f0817ae1878600327cd09a6ce	252415551157
0x868adfdf12a86422524eab6978beae08a0008f37	0xe7b30a037f5598e4e73702ca66a59af5cc650dcd	false	1014281967573379924224892682	1200305560171939484697	0x0000000000000000000000000000000000000000	1061	32087534	2024-01-23T11:49:20.000Z	0x55c632d68802c5c079639780c8305e721f3b17d0057385d9c3056224c193566c	3449639999327477235
0x868adfdf12a86422524eab6978beae08a0008f37	0x44602b0819d9744d1e20e5d157e0cdb01c54f2fe	false	1003797853355258321779398396	31849743398339642749	0x0000000000000000000000000000000000000000	2507	30824187	2023-11-06T18:18:20.000Z	0x69a187d452b1b12d1a6206aecbb9bf296aa783c987df76ba94f156a738a4801a	75411266096054

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spark_v1_gnosis.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 Protocol (Aave v3 fork) on Gnosis Chain, capturing new debt token deployments with metadata including token symbols, decimals, underlying assets, and incentives controller addresses. Used for tracking lending market expansions and available borrowing assets.

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
0x0ad6ccf9a2e81d4d48ab7db791e9da492967eb84	0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	0x	15	30326012	2023-10-06T15:19:55.000Z	Spark Variable Debt WETH	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672	variableDebtWETH	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	18	0x98e6bcba7d5dafbfa4a92daf08d3d7512820c30c
0x868adfdf12a86422524eab6978beae08a0008f37	0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	0x	11	30326012	2023-10-06T15:19:55.000Z	Spark Variable Debt WXDAI	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672	variableDebtWXDAI	0xe91d153e0b41518a2ce8dd3d7944fa863463a97d	18	0x98e6bcba7d5dafbfa4a92daf08d3d7512820c30c
0x3294da2e28b29d1c08d556e2b86879d221256d31	0x2dae5307c5e3fd1cf5a72cb6f698f915860607e0	false	0x	19	30326012	2023-10-06T15:19:55.000Z	Spark Variable Debt wstETH	0x5d40cced32bf37d52e1bdd0bd4023ca70dc15b00ee67e6c0ce2ebd41fc505672	variableDebtwstETH	0x6c76971f98945ae98dd7d4dfca8711ebea946ea6	18	0x98e6bcba7d5dafbfa4a92daf08d3d7512820c30c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.spark_v1_gnosis.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
0x868adfdf12a86422524eab6978beae08a0008f37	false	1014331846519754481738887876	6000000000000000000	0xbd7d6a9ad7865463de44b05f04559f65e3b11704	474	32093533	0xe66fbc8be19bd6b60a7fdc743a1019435ee0a04f	2024-01-23T20:39:05.000Z	0xca33d00a7ae0520bf3a073fde27943502910b9e8590a4a1a7a36e1001aea4ef9	0
0x3294da2e28b29d1c08d556e2b86879d221256d31	false	1002799567554596923748614421	1000000011245720	0x2f3ad8312da1a09b9814de22f25c5fdd006aa838	3005	32086633	0x2f3ad8312da1a09b9814de22f25c5fdd006aa838	2024-01-23T10:29:35.000Z	0x450a24158fe9b6c72550c46265e9dc3cf78819d494ea0512c85c73bb7512fa84	11245720
0x0ad6ccf9a2e81d4d48ab7db791e9da492967eb84	false	1003942545446220679460399701	2000000058206349	0x23e51402ff300c8b70784fcee0ccea80968474e4	13	32086704	0x23e51402ff300c8b70784fcee0ccea80968474e4	2024-01-23T10:36:00.000Z	0x2e3a9301458c268430aea7b47d9f4d439de4315ac175cfcbe69b3362dfa727b0	58206349

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

Pool_Borrow_event

Pool_FlashLoan_event

Pool_LiquidationCall_event

Pool_MintedToTreasury_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

spToken_BalanceTransfer_event

spToken_Burn_event

spToken_Initialized_event

spToken_Mint_event

StableDebtToken_Burn_event

StableDebtToken_Initialized_event

StableDebtToken_Mint_event

VariableDebtToken_Burn_event

VariableDebtToken_Initialized_event

VariableDebtToken_Mint_event

​Tables

​LendingPoolConfigurator_CollateralConfigurationChanged_event

​LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​Pool_Borrow_event

​Pool_FlashLoan_event

​Pool_LiquidationCall_event

​Pool_MintedToTreasury_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

​spToken_BalanceTransfer_event

​spToken_Burn_event

​spToken_Initialized_event

​spToken_Mint_event

​StableDebtToken_Burn_event

​StableDebtToken_Initialized_event

​StableDebtToken_Mint_event

​VariableDebtToken_Burn_event

​VariableDebtToken_Initialized_event

​VariableDebtToken_Mint_event

Tables

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

Pool_Borrow_event

Pool_FlashLoan_event

Pool_LiquidationCall_event

Pool_MintedToTreasury_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

spToken_BalanceTransfer_event

spToken_Burn_event

spToken_Initialized_event

spToken_Mint_event

StableDebtToken_Burn_event

StableDebtToken_Initialized_event

StableDebtToken_Mint_event

VariableDebtToken_Burn_event

VariableDebtToken_Initialized_event

VariableDebtToken_Mint_event