instadapp_v2_ethereum

Tables

FluidLiquidity_collectRevenue_function

Revenue collection function calls from Instadapp’s Fluid Liquidity protocol on Ethereum. Records token addresses (ETH, wstETH, USDC, USDT, WBTC) and transaction metadata for tracking protocol fee harvesting across multiple asset pools.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_tokens_`	`ARRAY<STRING>`	Array of token contract addresses from which revenue is being collected in this operation. Contains Ethereum token addresses (0x-prefixed) including the native ETH placeholder (0xeeee…) and various ERC-20 tokens like stablecoins and wrapped assets.

Sample Data

gas	status	gas_used	signature	in_tokens_	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
551101	true	196824	0xac862bfa	[“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0”,“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“0xdac17f958d2ee523a2206206994597c13d831ec7”,“0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f”,“0x2260fac5e5542a773aa44fbcfedf7c193bc2c599”,“0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf”]	0x52aa899454998be5b000ad077a46bbe360f4e497	21467085	0x2386dc45added673317ef068992f19421b481f4c	0,1,0,0,42	2024-12-23T18:50:59.000Z	0xe3f12daa868aaf295a993504fe3177fe02f905da86e6a3fb98fa33db57a1d9dd
2624606	true	100306	0xac862bfa	[“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0”,“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“0xdac17f958d2ee523a2206206994597c13d831ec7”]	0x52aa899454998be5b000ad077a46bbe360f4e497	20155390	0x2386dc45added673317ef068992f19421b481f4c	0,1,0,0,190	2024-06-23T15:49:35.000Z	0x64549ef2c7cf9fefc90989f7d489bbfbd8c4531794f606f9c47a8871ebe005e1
1733557	true	289383	0xac862bfa	[“0xdac17f958d2ee523a2206206994597c13d831ec7”,“0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0”,“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“0x9d39a5de30e57443bff2a8307a4256c8797a3497”,“0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf”,“0x2260fac5e5542a773aa44fbcfedf7c193bc2c599”,“0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f”,“0x4c9edd5852cd905f086c759e8383e09bff1e68b3”]	0x52aa899454998be5b000ad077a46bbe360f4e497	23483983	0x2386dc45added673317ef068992f19421b481f4c	0,1,0,0,2	2025-10-01T15:56:11.000Z	0x8979cc128e80687ea659a9cd748088f96310af99e81df597fb746015ff4df037

Example Query

Query with partition filter

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

FluidLiquidity_LogCollectRevenue_event

Revenue collection events from Fluid Liquidity protocol recording token amounts collected as protocol fees. Contains token address and collected amount in smallest denomination for tracking protocol revenue across supported 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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x52aa899454998be5b000ad077a46bbe360f4e497	false	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	58669691604	418	20944531	2024-10-11T19:41:59.000Z	0x3930265695aeea22b6623f18a45ae51e09bb3504c37936e3e47cc293553c1e53
0x52aa899454998be5b000ad077a46bbe360f4e497	false	0xdac17f958d2ee523a2206206994597c13d831ec7	54442889941	420	20944531	2024-10-11T19:41:59.000Z	0x3930265695aeea22b6623f18a45ae51e09bb3504c37936e3e47cc293553c1e53
0x52aa899454998be5b000ad077a46bbe360f4e497	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	4926562471740419601	416	20944531	2024-10-11T19:41:59.000Z	0x3930265695aeea22b6623f18a45ae51e09bb3504c37936e3e47cc293553c1e53

Example Query

Query with partition filter

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

FluidLiquidity_LogOperate_event

Liquidity operation events from the Fluid protocol recording supply, borrow, and withdrawal actions. Contains user addresses, token addresses, operation amounts, exchange prices, and total liquidity amounts for tracking DeFi lending pool 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_supplyAmount`	`STRING`	Amount supplied in the liquidity operation. Denominated in the smallest unit of the underlying token.
`in_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
`in_withdrawTo`	`STRING`	Address receiving withdrawn funds from the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; Base58-encoded Solana public key for Solana.
`in_borrowTo`	`STRING`	Address receiving the borrowed funds from the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_totalAmounts`	`STRING`	Cumulative total amounts in the liquidity pool after the operation. Decimal string representation of packed data encoding supply and borrow totals.
`in_exchangePricesAndConfig`	`STRING`	Encoded exchange prices and configuration parameters for the liquidity operation. Decimal string representation of packed data containing pricing and settings information.

Sample Data

address	in_user	removed	in_token	log_index	in_borrowTo	block_number	in_withdrawTo	block_timestamp	in_supplyAmount	in_totalAmounts	transaction_hash	in_exchangePricesAndConfig
0x52aa899454998be5b000ad077a46bbe360f4e497	0x2411802d8bea09be0af8fd8d08314a63e706b29c	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	118	0x0000000000000000000000000000000000000000	20015752	0x0000000000000000000000000000000000000000	2024-06-04T03:24:35.000Z	45352908327917726561	6171211324322111339943679620842729791481341771268609390612	0x1ced76a1073597499e0c7d579eba0f0b1dc500da62a2b5e9ec93b724cd811018	47711810595911985126769607795848813023255904093363411355099
0x52aa899454998be5b000ad077a46bbe360f4e497	0x2411802d8bea09be0af8fd8d08314a63e706b29c	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	250	0x0000000000000000000000000000000000000000	20017072	0x0a50fdfe3138a84fcd3b6bc6f3e008ef47b30d95	2024-06-04T07:49:35.000Z	-42500000000000000000	6182821603415963306937051341828383270108203153817526458644	0x23df50792c137a11fd166bef5edd28352bef408295b3eeaddc5ba2b80cd93bdf	47715416294644006863645940604914812089168464691443041568219
0x52aa899454998be5b000ad077a46bbe360f4e497	0x2411802d8bea09be0af8fd8d08314a63e706b29c	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	338	0x0000000000000000000000000000000000000000	20017122	0x0000000000000000000000000000000000000000	2024-06-04T07:59:35.000Z	47156650491018888872	6182821603415963306937051341828383270108214357508064629268	0x800a3527f882063f36973c762f6a7224482a24eb118051c134841c7beb77d030	47715552358756581102543773878428629605244878344216977606107

Example Query

Query with partition filter

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

FluidLiquidity_LogUpdateExchangePrices_event

Exchange price and rate updates from Instadapp’s Fluid Liquidity protocol on Ethereum. Captures supply/borrow exchange prices, utilization rates, and borrow rates per token for analyzing lending pool dynamics and yield 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_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_supplyExchangePrice`	`STRING`	Exchange price ratio for lenders depositing into the Instadapp Fluid liquidity pool for the specified token. Represents the conversion rate between pool shares and underlying token amounts at the time of the event.
`in_borrowExchangePrice`	`STRING`	Exchange price for borrowing the token, representing the conversion rate between borrowed token and protocol shares. Stored as a large integer value with implicit decimals for precision.
`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_utilization`	`STRING`	Current utilization rate of the liquidity pool for the specified token, expressed in basis points (e.g., 6261 = 62.61%). This metric indicates what percentage of supplied assets are currently borrowed.

Sample Data

address	removed	in_token	log_index	block_number	in_borrowRate	in_utilization	block_timestamp	transaction_hash	in_borrowExchangePrice	in_supplyExchangePrice
0x52aa899454998be5b000ad077a46bbe360f4e497	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	460	19828951	1788	6261	2024-05-09T00:36:23.000Z	0x8425f3aaa02f893033e99046ba528fc017cc618a89ac363f90bb1f3ba1adaa4f	1033165313252	1020056793468
0x52aa899454998be5b000ad077a46bbe360f4e497	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	461	19828951	1609	6261	2024-05-09T00:36:23.000Z	0x8425f3aaa02f893033e99046ba528fc017cc618a89ac363f90bb1f3ba1adaa4f	1033165313252	1020056793468
0x52aa899454998be5b000ad077a46bbe360f4e497	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	458	19828951	1362	6359	2024-05-09T00:36:23.000Z	0x8425f3aaa02f893033e99046ba528fc017cc618a89ac363f90bb1f3ba1adaa4f	1022751918825	1018544607500

Example Query

Query with partition filter

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

FluidLiquidity_LogUpdateUserBorrowConfigs_event

User borrow configuration change events from Instadapp’s Fluid Liquidity protocol on Ethereum, tracking debt ceiling adjustments and expansion parameters. Useful for monitoring user-specific lending limits and analyzing how borrow capacity evolves over time for different token 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_userBorrowConfigs`	`ARRAY<STRUCT<user STRING, token STRING, mode INT64, expandPercent STRING, expandDuration STRING, baseDebtCeiling STRING, maxDebtCeiling STRING>>`	Nested record containing borrow configuration parameters for a specific user-token pair in Instadapp’s Fluid Liquidity protocol. Includes user address, token address, mode, expand parameters (percent and duration in seconds), and debt ceiling limits (base and max) denominated in token units.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_userBorrowConfigs
0x52aa899454998be5b000ad077a46bbe360f4e497	false	439	19754114	2024-04-28T13:28:11.000Z	0xaa5f4924e21d7d372563c704b1a4e9649e3132a38de231dbda3b5c05a26de13f	[{“mode”:1,“user”:“0x40d9b8417e6e1dcd358f04e3328bced061018a82”,“token”:“0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0”,“expandPercent”:“2500”,“expandDuration”:“43200”,“maxDebtCeiling”:“137538”,“baseDebtCeiling”:“222014”}]
0x52aa899454998be5b000ad077a46bbe360f4e497	false	284	19752857	2024-04-28T09:15:11.000Z	0xebc949cf77a8c4ca38cc91a815a17acdf71d108714e224cf1a58b5bb7db263c8	[{“mode”:1,“user”:“0x40d9b8417e6e1dcd358f04e3328bced061018a82”,“token”:“0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0”,“expandPercent”:“2500”,“expandDuration”:“43200”,“maxDebtCeiling”:“134722”,“baseDebtCeiling”:“222014”}]
0x52aa899454998be5b000ad077a46bbe360f4e497	false	289	19949297	2024-05-25T20:32:11.000Z	0x401b2c1b77e0e51e960e25952d669d4616894cbf81402e5e23b32c30b91fe7d3	[{“mode”:1,“user”:“0x40d9b8417e6e1dcd358f04e3328bced061018a82”,“token”:“0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0”,“expandPercent”:“2500”,“expandDuration”:“43200”,“maxDebtCeiling”:“37213194476753068607927”,“baseDebtCeiling”:“3998331777976545312768”}]

Example Query

Query with partition filter

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

FluidLiquidity_LogUpdateUserSupplyConfigs_event

User supply configuration updates from Instadapp’s Fluid Liquidity protocol on Ethereum. Tracks withdrawal limit parameters including base limits, expansion rates, and durations for analyzing liquidity provider settings and risk management strategies.

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_userSupplyConfigs`	`ARRAY<STRUCT<user STRING, token STRING, mode INT64, expandPercent STRING, expandDuration STRING, baseWithdrawalLimit STRING>>`	Nested record containing the updated supply configuration parameters for a user-token pair in Instadapp’s Fluid Liquidity protocol. Includes withdrawal limits, expansion rates (expandPercent in basis points), time durations, operation mode, and identifies the user address and token being configured.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_userSupplyConfigs
0x52aa899454998be5b000ad077a46bbe360f4e497	false	132	21190396	2024-11-15T03:25:35.000Z	0x9ff94cd0130070c5930df5613c1e270d3ff4d3bcfb4436516a8de4a87744a1c8	[{“mode”:1,“user”:“0x2886a01a0645390872a9eb99dae1283664b0c524”,“token”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“expandPercent”:“5000”,“expandDuration”:“3600”,“baseWithdrawalLimit”:“14081731098265”}]
0x52aa899454998be5b000ad077a46bbe360f4e497	false	131	21190396	2024-11-15T03:25:35.000Z	0x9ff94cd0130070c5930df5613c1e270d3ff4d3bcfb4436516a8de4a87744a1c8	[{“mode”:1,“user”:“0x2886a01a0645390872a9eb99dae1283664b0c524”,“token”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“expandPercent”:“5000”,“expandDuration”:“3600”,“baseWithdrawalLimit”:“5054447971185987919463”}]
0x52aa899454998be5b000ad077a46bbe360f4e497	false	161	21190396	2024-11-15T03:25:35.000Z	0x9ff94cd0130070c5930df5613c1e270d3ff4d3bcfb4436516a8de4a87744a1c8	[{“mode”:1,“user”:“0x2f6c2a725ea6c4304cdc92b49f637a7735362ef5”,“token”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“expandPercent”:“2500”,“expandDuration”:“43200”,“baseWithdrawalLimit”:“2527223985592993959731”}]

Example Query

Query with partition filter

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

FluidReserveContract_LogRebalanceFToken_event

Rebalancing events from Instadapp’s Fluid Reserve Contract on Ethereum, recording fToken transfers between lending protocols with amounts and target protocol addresses. Used for tracking Fluid’s automated yield optimization and liquidity management across integrated DeFi 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_protocol`	`STRING`	Contract address of the protocol receiving funds during this fToken rebalancing operation. Hex-encoded, 0x-prefixed Ethereum address representing a DeFi protocol integrated with Instadapp’s Fluid Reserve system.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	in_protocol	block_number	block_timestamp	transaction_hash
0x264786ef916af64a1db19f513f24a3681734ce92	false	33428532795	53	0x5c20b550819128074fd538edf79791733ccedd18	19434426	2024-03-14T16:28:35.000Z	0xbda406e7e154fcee4b9e9079b773fc0341480ae89964397c237d7a02d9a35d4a
0x264786ef916af64a1db19f513f24a3681734ce92	false	33425886191	48	0x9fb7b4477576fe5b32be4c1843afb1e55f251b33	19434426	2024-03-14T16:28:35.000Z	0xbda406e7e154fcee4b9e9079b773fc0341480ae89964397c237d7a02d9a35d4a
0x264786ef916af64a1db19f513f24a3681734ce92	false	53327981294	473	0x9fb7b4477576fe5b32be4c1843afb1e55f251b33	21105777	2024-11-03T08:00:11.000Z	0xb09d0f7eadfd07172da811fba5d1695ef825d6b5a0e811a7df30d015107f440a

Example Query

Query with partition filter

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

FluidReserveContract_LogRebalanceVault_event

Vault rebalancing events from Instadapp’s Fluid Reserve Contract on Ethereum, recording collateral and debt adjustments across different protocols. Used for tracking automated position management and liquidity rebalancing activity within Fluid vaults.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_protocol`	`STRING`	Contract address of the lending protocol being rebalanced within the Instadapp Fluid Reserve system. Hex-encoded, 0x-prefixed Ethereum address identifying the specific protocol vault where collateral and debt positions are adjusted.
`in_colAmount`	`STRING`	Amount of collateral involved in the vault rebalancing operation, denominated in the smallest unit of the collateral token. May be negative (-1) when collateral is fully withdrawn or rebalanced out of the vault.
`in_debtAmount`	`STRING`	Amount of debt denominated in the smallest unit of the token. Represented as a numeric string without decimal formatting.

Sample Data

address	removed	log_index	in_protocol	block_number	in_colAmount	in_debtAmount	block_timestamp	transaction_hash
0x264786ef916af64a1db19f513f24a3681734ce92	false	37	0xbec491fef7b4f666b270f9d5e5c3f443cbf20991	19500818	22543443452683566137	67235	2024-03-24T00:21:59.000Z	0xb1ffc1ac74493b71524f5cb6478cacbd94b41ea3179eceac656850bd93212e72
0x264786ef916af64a1db19f513f24a3681734ce92	false	32	0xeabbfca72f8a8bf14c4ac59e69ecb2eb69f0811c	19500818	21742509536295839272	23211	2024-03-24T00:21:59.000Z	0xb1ffc1ac74493b71524f5cb6478cacbd94b41ea3179eceac656850bd93212e72
0x264786ef916af64a1db19f513f24a3681734ce92	false	208	0xeabbfca72f8a8bf14c4ac59e69ecb2eb69f0811c	19348537	3238381799735773770	17871	2024-03-02T16:00:35.000Z	0x407b7865a63b67c8eaadda978ce0c17d343b26cc9dbc43f0a61d422049380263

Example Query

Query with partition filter

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

iETH_Deposit_event

Deposit events from Instadapp’s iETH vault on Ethereum, recording ETH deposits with corresponding share issuance. Tracks depositor addresses, asset amounts (in wei), and vault shares minted for yield strategy analysis.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	0xc9ea1aff83f0b35371729935e1bbecc41e590728	6944959378927347033	0xa13cea5fe07253075deae089d167854e8a7cf91d	6465058129019522705	284	19329720	2024-02-29T00:51:11.000Z	0x22e10b0ba4a0a7193e4c2ba118ca31cbc6de8cbbec2bdd1dc0ac6758d292b08d
0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	0xc441385128750d611464070b83c086f1b62af196	1899999999999999999	0xa13cea5fe07253075deae089d167854e8a7cf91d	1768297052589582048	110	19334574	2024-02-29T17:11:47.000Z	0xabd5b7107220660d07f785b7ef56902efdd81633f681fdff971e6f119153af69
0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	0xa8c6e8aa1cb02d2e8b6aa57d958915bdb2223320	5030000000000000000	0xa8c6e8aa1cb02d2e8b6aa57d958915bdb2223320	4681333776066104055	96	19335166	2024-02-29T19:10:35.000Z	0x76fe6d6c61aebd207f760172dab8380c829831f9f8e74ee2792931b641277d41

Example Query

Query with partition filter

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

iETH_LogCollectRevenue_event

Revenue collection events from Instadapp V2’s iETH (interest-bearing ETH) contract on Ethereum. Tracks protocol fee withdrawals with recipient addresses and amounts in wei for analyzing Instadapp’s revenue streams and treasury management.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to	address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x28849d2b63fa8d361e5fc15cb8abb13019884d09	0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	417200000000000000000	130	18537182	2023-11-09T21:50:35.000Z	0x4a3b711efc6d0c6845b617958873281029182de4555a5b91ed97ade45c06d2e3
0x28849d2b63fa8d361e5fc15cb8abb13019884d09	0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	452000000000000000000	111	20229030	2024-07-03T22:40:35.000Z	0x4034854736288d473373723a678b8f4340b1ad999e3f5e58b09c8a17c7c876e9
0x28849d2b63fa8d361e5fc15cb8abb13019884d09	0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	151715060802010378082	115	20895572	2024-10-04T23:53:11.000Z	0x4149e4c4d69cedbc238228e347fea6e3a6f4793aefc11792522752bf8a8345a6

Example Query

Query with partition filter

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

iETH_LogUpdateFees_event

Fee parameter update events from Instadapp’s iETH vault on Ethereum. Tracks changes to revenue fee percentages, withdrawal fee percentages, and minimum withdrawal fees for analyzing vault fee structure adjustments 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_revenueFeePercentage`	`STRING`	Revenue fee percentage charged by the Instadapp iETH vault, represented in basis points where 100000 equals 10%. The value changes over time through contract governance updates as shown in the sample data (10% to 20%).
`in_withdrawalFeePercentage`	`STRING`	Percentage fee charged on withdrawals from the Instadapp iETH vault, represented in basis points where 100 equals 0.01%. Appears to be stored as a string-encoded integer that gets updated through fee configuration events.
`in_withdrawFeeAbsoluteMin`	`STRING`	Minimum absolute withdrawal fee amount in wei (smallest token unit) that must be charged regardless of percentage calculations. Can be zero to disable minimum fee enforcement, as seen in later fee updates.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_revenueFeePercentage	in_withdrawFeeAbsoluteMin	in_withdrawalFeePercentage
0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	14	16609610	2023-02-12T02:11:35.000Z	0xac7e1a2b0af4c35d80382f478641d9d5236758c1f2817354ceb60c3566b3ef0f	100000	1000000000	100
0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	75	16670384	2023-02-20T14:35:23.000Z	0x1bc3a202e01ee3e7f67c18deb279d83cc04f01508789f860ac44a1ea0632bf09	200000	0	500

Example Query

Query with partition filter

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

iETH_LogWithdrawFeeCollected_event

Withdrawal fee collection events from Instadapp V2’s iETH (interest-bearing ETH) vault on Ethereum. Records fee amounts in wei and payer addresses for tracking protocol revenue and fee collection 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_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`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

in_fee	address	removed	in_payer	log_index	block_number	block_timestamp	transaction_hash
1500000000000000	0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	0x6446819d375e34837c4a85d6a42a184829571e87	590	20087256	2024-06-14T03:07:11.000Z	0x40a22c32a7bed05388c8d266ac9b70c6d427acb7e9b84379872f93377f62ddc5
8195000000000000	0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	0x2456bad5adc5537154b326ff1f05722a1820a944	403	20092320	2024-06-14T20:04:59.000Z	0x430b199806c05db78fc1c2808d4d2442e7dfba6b481a35bf1a6e47c0f940eeb2
3544301961655013	0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	0xb6691a65387e127a93a80e86f977730ab75608a6	259	17738415	2023-07-21T02:01:59.000Z	0x84bc378e0b61ad4ac7a855f1d6cc19ef1b411ec94aa7681ca357e26fbde38771

Example Query

Query with partition filter

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

iETH_Withdraw_event

Withdrawal events from Instadapp’s iETH vault on Ethereum, tracking redemptions of vault shares for underlying ETH assets with owner, receiver, and share-to-asset conversion data. Used 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
0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	0x5a2b583f5fe3630a4381b75a12355139acaa3fd6	44127825050000000000	0xa13cea5fe07253075deae089d167854e8a7cf91d	42928512646513883306	73	0xa13cea5fe07253075deae089d167854e8a7cf91d	17480284	2023-06-14T19:34:35.000Z	0xb2d4f51a3e8ecac0e5b1849767878b6b520f23bd5b90dfddc55445d7462d02fa
0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	0x825c657e9e72c04b7dc1e92b947f2fa33d1127fb	199900000000000000	0xa13cea5fe07253075deae089d167854e8a7cf91d	194555832687870723	338	0xa13cea5fe07253075deae089d167854e8a7cf91d	17478289	2023-06-14T12:50:35.000Z	0xeb02e86162df27a9604a81a5a4c8e782d4999e6d4642cf98d987b13f339ace48
0xa0d3707c569ff8c87fa923d3823ec5d81c98be78	false	0xcfcce06af0ee209dfa340247199057fe619c98c9	99999975000000000000	0xcfcce06af0ee209dfa340247199057fe619c98c9	97326555302107328839	42	0xcfcce06af0ee209dfa340247199057fe619c98c9	17476510	2023-06-14T06:49:35.000Z	0x7d99b4770024c014f14b8b4fc1145c1d39616422aac4a0592de3cd97a2328a25

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

FluidLiquidity_collectRevenue_function

FluidLiquidity_LogCollectRevenue_event

FluidLiquidity_LogOperate_event

FluidLiquidity_LogUpdateExchangePrices_event

FluidLiquidity_LogUpdateUserBorrowConfigs_event

FluidLiquidity_LogUpdateUserSupplyConfigs_event

FluidReserveContract_LogRebalanceFToken_event

FluidReserveContract_LogRebalanceVault_event

iETH_Deposit_event

iETH_LogCollectRevenue_event

iETH_LogUpdateFees_event

iETH_LogWithdrawFeeCollected_event

iETH_Withdraw_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​FluidLiquidity_collectRevenue_function

​FluidLiquidity_LogCollectRevenue_event

​FluidLiquidity_LogOperate_event

​FluidLiquidity_LogUpdateExchangePrices_event

​FluidLiquidity_LogUpdateUserBorrowConfigs_event

​FluidLiquidity_LogUpdateUserSupplyConfigs_event

​FluidReserveContract_LogRebalanceFToken_event

​FluidReserveContract_LogRebalanceVault_event

​iETH_Deposit_event

​iETH_LogCollectRevenue_event

​iETH_LogUpdateFees_event

​iETH_LogWithdrawFeeCollected_event

​iETH_Withdraw_event

Tables

FluidLiquidity_collectRevenue_function

FluidLiquidity_LogCollectRevenue_event

FluidLiquidity_LogOperate_event

FluidLiquidity_LogUpdateExchangePrices_event

FluidLiquidity_LogUpdateUserBorrowConfigs_event

FluidLiquidity_LogUpdateUserSupplyConfigs_event

FluidReserveContract_LogRebalanceFToken_event

FluidReserveContract_LogRebalanceVault_event

iETH_Deposit_event

iETH_LogCollectRevenue_event

iETH_LogUpdateFees_event

iETH_LogWithdrawFeeCollected_event

iETH_Withdraw_event