instadapp_v1_ethereum

Tables

AvoForwarder_Executed_event

Event logs from Instadapp’s AvoForwarder contract recording successful execution of cross-chain operations through AvoSafe smart wallet accounts. Contains safe addresses, owner addresses, source chain identifiers, and operation metadata for tracking delegated transaction execution across EVM networks.

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_avoSafeOwner`	`STRING`	Address of the account that owns the AvoSafe wallet instance. Hex-encoded, 0x-prefixed, 42-character string.
`in_avoSafeAddress`	`STRING`	Address of the AvoSafe smart contract wallet instance. Hex-encoded, 0x-prefixed, 42-character string.
`in_source`	`STRING`	Source chain identifier for the cross-chain operation. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-1” for Ethereum, “EVM-56” for BSC).
`in_metadata`	`STRING`	Metadata payload associated with the operation. Hex-encoded bytes containing protocol-specific auxiliary data such as action identifiers, addresses, amounts, and configuration parameters.

Sample Data

address	removed	in_source	log_index	in_metadata	block_number	block_timestamp	in_avoSafeOwner	transaction_hash	in_avoSafeAddress
0x375f6b0cd12b34dc28e34c26853a37012c24dde5	false	0x000000000000000000000000000000000000cad0	65	0x	20783141	2024-09-19T07:27:11.000Z	0x10f37ceb965b477ba09d23ff725e0a0f1cdb83a5	0x1d3b719bdb75fede508f9826a3c4ad11072e9ed482958094b4b4431ba2e550ee	0x3b5bd7a9e7184eff518d1466fb47c42e2f05c01f
0x375f6b0cd12b34dc28e34c26853a37012c24dde5	false	0x000000000000000000000000000000000000cad0	228	0x	20787850	2024-09-19T23:13:11.000Z	0x10f37ceb965b477ba09d23ff725e0a0f1cdb83a5	0x4d93d51ee7b61065746d81f8bb3fc1414268501408d369069b05bc69d0ec55e5	0x3b5bd7a9e7184eff518d1466fb47c42e2f05c01f
0x375f6b0cd12b34dc28e34c26853a37012c24dde5	false	0x000000000000000000000000000000000000cad0	476	0x	20784630	2024-09-19T12:26:23.000Z	0x10f37ceb965b477ba09d23ff725e0a0f1cdb83a5	0x31b9abcbad594e7baec97c7581fcbe03c3d9f26ac81c927f02162ada4e569b4d	0x3b5bd7a9e7184eff518d1466fb47c42e2f05c01f

Example Query

Query with partition filter

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

AvoForwarderMultisig_Executed_event

Multisig execution events emitted by the AvoForwarder contract when a transaction is successfully executed through an Avocado smart wallet. Contains the wallet address, owner address, execution index, source identifier, and metadata payload for tracking multisig operations across chains.

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_avocadoOwner`	`STRING`	Address of the owner of the Avocado multisig wallet. Hex-encoded, 0x-prefixed, 42-character string.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_avocadoAddress`	`STRING`	Contract address of the Avocado multisig wallet that executed the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_source`	`STRING`	Source chain identifier for the cross-chain operation. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-1” for Ethereum, “EVM-56” for BSC).
`in_metadata`	`STRING`	Metadata payload associated with the operation. Hex-encoded bytes containing protocol-specific auxiliary data such as action identifiers, addresses, amounts, and configuration parameters.

Sample Data

address	removed	in_index	in_source	log_index	in_metadata	block_number	block_timestamp	in_avocadoOwner	transaction_hash	in_avocadoAddress
0x46978cd477a496028a18c02f07ab7f35edba5a54	false	1	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	111	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014073776170000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000ae7ab96520de3a18e5e111b5eaab095312d7fe84000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800000000000000000000000000000000000000000000000002c7ad11b4c2f000000000000000000000000000000000000000000000000000000000002131e2c900000000000000000000000041493259ada007ea557a49aa7a1a12ba1f7c818831696e63682d7635000000000000000000000000000000000000000000000000	19251559	2024-02-18T01:53:35.000Z	0x41493259ada007ea557a49aa7a1a12ba1f7c8188	0x5d717244b727d0ddf7a835f64e58b50ac77e7770bbcc29c3cd88a3d189129b93	0x16c1f5650846f897698fe0c990fbf6b19454297b
0x46978cd477a496028a18c02f07ab7f35edba5a54	false	1	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	114	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000016064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000002541617665202d204f70656e20536f75726365204c69717569646974792050726f746f636f6c000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001468747470733a2f2f6170702e616176652e636f6d000000000000000000000000	19251809	2024-02-18T02:43:47.000Z	0x41493259ada007ea557a49aa7a1a12ba1f7c8188	0xa6b4a1285d80498411a3c438144c51f1db84906e22e65366c2fb08b8e83d1877	0x16c1f5650846f897698fe0c990fbf6b19454297b
0x46978cd477a496028a18c02f07ab7f35edba5a54	false	1	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	103	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000000e06164642d7369676e65727300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000dc5a92ba2df28e370d7769df64dd08980794109f00000000000000000000000000000000000000000000000000000000000000a06368616e67652d7468726573686f6c64000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000002	19254252	2024-02-18T10:59:35.000Z	0xb69dc6a556bcc68824682395932b7ece3e01aa40	0x082d467b49d14908d794b491079c81123c7ff554568782d68a613f8f81b3deb3	0x19c19458d47e4e0fe61726a089e805480005ca26

Example Query

Query with partition filter

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

Factory_DexT1Deployed_event

DEX deployment events emitted when a new decentralized exchange instance is created through a factory contract. Contains the deployed DEX address, sequential identifier, and the supply/borrow token pair configuration.

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_dex`	`STRING`	Contract address of the decentralized exchange (DEX) deployment. Hex-encoded, 0x-prefixed, 42-character string.
`in_dexId`	`STRING`	Unique identifier for the deployed decentralized exchange instance. String representation of a sequential integer.
`in_supplyToken`	`STRING`	Contract address of the token being supplied. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrowToken`	`STRING`	Contract address of the token being borrowed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_dex	address	removed	in_dexId	log_index	block_number	in_borrowToken	in_supplyToken	block_timestamp	transaction_hash
0xe0cc64ab3712e2087e1d4aab6f3a14f120449e5f	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	30	209	22126772	0x8236a87084f8b84306f72007f36f2618a5634494	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	2025-03-25T22:04:23.000Z	0x802c238930a04ba630dab8cd0f37c8592c93005b5c0b34fb6d746f075840c4ca
0x0ffda76c8a06d03c104f58ece336348488487e60	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	29	3	22122671	0xdac17f958d2ee523a2206206994597c13d831ec7	0x1202f5c7b4b9e47a1a484e8b270be34dbbc75055	2025-03-25T08:17:11.000Z	0x13d0903cbda469d7764758718c1ba45e7cfd27a36d44ac5dd3be942ac3d13a63
0xde632c3a214d5f14c1d8ddf0b92f8bcd188fee45	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	4	240	21031805	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f	2024-10-24T00:14:23.000Z	0x97cf032308aeb246403160cf2187822f4810fc4993616d674e8e395b72554477

Example Query

Query with partition filter

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

Factory_LogDexDeployed_event

DEX deployment events emitted by Instadapp factory contracts containing the deployed exchange contract address and sequential identifier. Used for tracking new exchange instance creation and registry 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_dex`	`STRING`	Contract address of the decentralized exchange (DEX) deployment. Hex-encoded, 0x-prefixed, 42-character string.
`in_dexId`	`STRING`	Unique identifier for the deployed decentralized exchange instance. String representation of a sequential integer.

Sample Data

in_dex	address	removed	in_dexId	log_index	block_number	block_timestamp	transaction_hash
0x2886a01a0645390872a9eb99dae1283664b0c524	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	5	89	21105297	2024-11-03T06:23:47.000Z	0xa355917f6e498164dd5c77a926e8d66fb9058d99ddff250b8f6091a60974ad1c
0x36a905dcd12c0201f884fafda71e63e9547975da	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	6	159	21105362	2024-11-03T06:36:47.000Z	0x7f77a0ea80adb7e842d899c84b3e0a3a76dc378fb1ee790888d7e104cca3d0fb
0xfd6d459f04c3f0568e7361f29d0390081a43b90b	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	7	4	21105366	2024-11-03T06:37:35.000Z	0xa4c798ec74fa9f8c793337d8169b2172e3ebf1f9d6f72dea47dfb0a324417606

Example Query

Query with partition filter

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

Factory_VaultDeployed_event

Vault deployment events emitted by factory contracts when new vault instances are created. Records vault contract address and sequential vault identifier for tracking protocol-wide vault creation 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_vault`	`STRING`	Contract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.
`in_vaultId`	`STRING`	Unique identifier for a vault within the protocol. Numeric string representation.

Sample Data

address	removed	in_vault	log_index	in_vaultId	block_number	block_timestamp	transaction_hash
0x324c5dc1fc42c7a4d43d92df1eba58a54d13bf2d	false	0xf55b8e9f0c51ace009f4b41d03321675d4c643b3	346	9	19811337	2024-05-06T13:27:35.000Z	0x07a3538ae4a9477130ebcd9ce97a66da28c49b8422dbcce13553b0c9dcb34d29
0x324c5dc1fc42c7a4d43d92df1eba58a54d13bf2d	false	0xdf16adaf80584b2723f3ba1eb7a601338ba18c4e	356	10	19811337	2024-05-06T13:27:35.000Z	0x07a3538ae4a9477130ebcd9ce97a66da28c49b8422dbcce13553b0c9dcb34d29
0x324c5dc1fc42c7a4d43d92df1eba58a54d13bf2d	false	0x40d9b8417e6e1dcd358f04e3328bced061018a82	145	6	19468696	2024-03-19T12:08:35.000Z	0x72e3840ade1e545dc7204d7597fe4057806f37cc6e7d5f99fa918cc9865ad5e5

Example Query

Query with partition filter

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

FluidDex_Swap_event

Token swap events from FluidDex (Instadapp) decentralized exchange contracts recording input and output token amounts with directional swap indicators. Used for tracking DEX trading volume and price impact 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_swap0to1`	`BOOL`	Boolean flag indicating the swap direction, where true represents swapping from token0 to token1 and false represents swapping from token1 to token0.
`in_amountIn`	`STRING`	Amount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
`in_amountOut`	`STRING`	Amount of output tokens received from the swap. Numeric string representing the token quantity in its 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	log_index	in_amountIn	in_swap0to1	block_number	in_amountOut	block_timestamp	transaction_hash
0x70bf6634ee8cb27d04478f184b9b8bb13e5f4710	0x2886a01a0645390872a9eb99dae1283664b0c524	false	256	142798196780652463	false	21355455	570940080	2024-12-08T04:42:11.000Z	0x215e675605a114c8c291d7267af9d86df24076f22820b168139b98d1765e8677
0x70bf6634ee8cb27d04478f184b9b8bb13e5f4710	0x2886a01a0645390872a9eb99dae1283664b0c524	false	217	200000000000000017	false	21356591	794022336	2024-12-08T08:31:23.000Z	0xd4683e874497090c5e9386d59ecf985f81defa23e4464e1966bdecf9692eed7c
0x3451b6b219478037a1ac572706627fc2bda1e812	0x3c0441b42195f4ad6aa9a0978e06096ea616cda7	false	276	462600000	false	21354256	463395582	2024-12-08T00:41:47.000Z	0xea2eba539dad19f62bab38912450a22adb775d138704b5858711af260da30f7f

Example Query

Query with partition filter

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

FluidDexLite_LogSwap_event

Swap event logs from Instadapp’s FluidDexLite protocol on Ethereum, capturing decentralized exchange state variables and swap parameters as encoded integers. Used for tracking liquidity pool dynamics and trade execution within Instadapp’s DeFi aggregation infrastructure.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_swapData`	`STRING`	Encoded swap parameters containing trade details such as amounts, directions, and pricing information for the FluidDex Lite exchange. Large integer values represent packed binary data that must be decoded to extract individual swap attributes.
`in_dexVariables`	`STRING`	Packed state variables of the Fluid DEX pool at swap execution, encoded as a single large integer. Contains pool parameters like reserves, prices, and fee settings that are unpacked by the protocol for swap calculations.

Sample Data

address	removed	log_index	in_swapData	block_number	block_timestamp	in_dexVariables	transaction_hash
0xbbcb91440523216e2b87052a99f69c604a7b6e00	false	3	127619054699250954011077397202462624929894332660664	23065785	2025-08-04T06:03:11.000Z	46841165447555110366835602784289993065074844343391915248280032434622300165	0x7ff9ef342b165eb074b1a3df63a5ca7168b5a6158fd532526c82ec40d47d5e82
0xbbcb91440523216e2b87052a99f69c604a7b6e00	false	3	212717177341248235313731310599307900102417283316664	23068409	2025-08-04T14:50:35.000Z	43985680587049617206838185258176483515329285245310132200236862102602514437	0x7999e34bdcbe096a8f79a3ae9f4686349263e444e1c0b2b16406cb905b8f5743
0xbbcb91440523216e2b87052a99f69c604a7b6e00	false	3	31897871979751139061443138802776128883018454563768	23066092	2025-08-04T07:04:47.000Z	46663906032263708773261857349153171453850066215710616385363543251809730565	0x198dfee63e5be32978052c94004a1b793e1b1c3e2d786dd9bdfb2ad0e3e008a1

Example Query

Query with partition filter

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

FluidLendingFactory_LogTokenCreated_event

Event logs emitted when the Fluid Lending Factory contract creates a new lending token (fToken). Records the underlying asset address, created token address, token type (fToken or NativeUnderlying), and sequential count for tracking factory deployments.

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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_count`	`STRING`	Number of items or tokens involved in the transaction. Numeric string representation.
`in_fTokenType`	`STRING`	Token type classification for the created Fluid lending token. String value indicating the token wrapper variant such as “fToken” or “NativeUnderlying”.

Sample Data

address	removed	in_asset	in_count	in_token	log_index	block_number	in_fTokenType	block_timestamp	transaction_hash
0x54b91a0d94cb471f37f949c60f7fa7935b551d03	false	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	4	0x2411802d8bea09be0af8fd8d08314a63e706b29c	523	19597495	fToken	2024-04-06T15:10:59.000Z	0x8b1062e9cfe54a1b5ea9a9a82418c7698de5c46bd374c664b69ae4c476387cb8
0x54b91a0d94cb471f37f949c60f7fa7935b551d03	false	0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f	5	0x6a29a46e21c730dca1d8b23d637c101cec605c5b	118	21031435	fToken	2024-10-23T22:59:59.000Z	0xddac9a79f89bc1cf7d7e9f06a3bb1aac0d3cc5841ec226bbafdb918a0cea6f05
0x54b91a0d94cb471f37f949c60f7fa7935b551d03	false	0xc139190f447e929f090edeb554d95abb8b18ac1c	7	0x15e8c742614b5d8db4083a41df1a14f5d2bfb400	517	22636636	fToken	2025-06-05T06:29:23.000Z	0x1103b44f97c0028a25f8752c476650212823dc2099b1bbaadfaff963de7668eb

Example Query

Query with partition filter

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

FluidVaultT1_LogOperate_event

Vault operation events from Instadapp Fluid Protocol tracking collateral and debt position changes. Contains NFT-based position identifiers, collateral amounts, debt amounts, user addresses, and recipient addresses for analyzing leverage activities and vault state transitions across DeFi lending 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_user_`	`STRING`	Address of the user initiating the vault operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_nftId_`	`STRING`	Unique identifier for the vault position. String-encoded integer representing the NFT token ID associated with the user’s vault.
`in_colAmt_`	`STRING`	Collateral amount for the vault operation. String-encoded signed integer representing token quantity in smallest denomination.
`in_debtAmt_`	`STRING`	Debt amount for the vault operation. String-encoded signed integer representing token quantity in smallest denomination.
`in_to_`	`STRING`	Recipient address of the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to_	address	removed	in_user_	in_nftId_	log_index	in_colAmt_	in_debtAmt_	block_number	block_timestamp	transaction_hash
0x4fbbb92efbb0cfc9e3fc65c1aa2385bc378c3505	0x03271c337c86a6fd89625a2820e48621dc2a128b	false	0x4fbbb92efbb0cfc9e3fc65c1aa2385bc378c3505	1776	430	2205245656611881075	0	20728699	2024-09-11T16:56:11.000Z	0x0f28d660563b33d482c5df1f036a0e3379e55e406cea3cd6770a787fad4e4c39
0x69b554b5cf8917040feaf1e08c7db14be60c6425	0x0c8c77b7ff4c2af7f6cebbe67350a490e3dd6cb3	false	0x69b554b5cf8917040feaf1e08c7db14be60c6425	1503	348	19999926217900108946	46600000000	20727395	2024-09-11T12:33:47.000Z	0x531b4b8e25c1d9ffdd28b680fe157e8bef0d5d0bcb50c35bcebf5fe0ccfc073d
0x47b1cf5bb614dd18c91327ee46958dee29235a52	0x0c8c77b7ff4c2af7f6cebbe67350a490e3dd6cb3	false	0x47b1cf5bb614dd18c91327ee46958dee29235a52	1577	207	420000000000000000	0	20723668	2024-09-11T00:03:47.000Z	0xe299ef69683b4d3ca990ff40307571c6bd103941eff2b0892f90b0fcf198c21e

Example Query

Query with partition filter

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

FluidVaultT1_LogRebalance_event

Rebalancing events emitted by Fluid Protocol VaultT1 contracts recording collateral and debt amount adjustments. Used for tracking vault position management and liquidation prevention activities across lending 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_colAmt_`	`STRING`	Collateral amount for the vault operation. String-encoded signed integer representing token quantity in smallest denomination.
`in_debtAmt_`	`STRING`	Debt amount for the vault operation. String-encoded signed integer representing token quantity in smallest denomination.

Sample Data

address	removed	log_index	in_colAmt_	in_debtAmt_	block_number	block_timestamp	transaction_hash
0xbc345229c1b52e4c30530c614bb487323ba38da5	false	96	0	19464999171	21397034	2024-12-14T00:00:47.000Z	0xcada7b1ea2d381c4c6b8d2eef5dba0dd452daaec55628d79dcf783c2796e933b
0x3996464c0fcca8183e13ea5e5e74375e2c8744dd	false	285	0	11446042497	21397032	2024-12-14T00:00:23.000Z	0x849fc1d59e3cb3b32f6e129e2741b5c5c951ab784152b6d2cc2b8105f7269eec
0x6f72895cf6904489bcd862c941c3d02a3ee4f03e	false	400	-2	0	21122793	2024-11-05T16:58:35.000Z	0x12e62df966aea6932fc0f4edcd7bd3f2c6d5e3bbe675cd2992372d810b114e92

Example Query

Query with partition filter

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

iDAI_collectRevenueLog_event

Revenue collection events from Instadapp’s interest-bearing DAI (iDAI) vault on Ethereum, tracking fee withdrawals with recipient addresses and amounts in wei.

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`	Amount of tokens involved in the operation. String-encoded integer representing the value in the token’s smallest unit.
`in_to_`	`STRING`	Recipient address of the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to_	address	removed	log_index	in_amount_	block_number	block_timestamp	transaction_hash
0x28849d2b63fa8d361e5fc15cb8abb13019884d09	0x40a9d39aa50871df092538c5999b107f34409061	false	190	11875691813047881724671	16958659	2023-04-02T03:09:35.000Z	0x9c8a602c368270c75e7640ac5fd411850459445b0926fdce26e1889c8e81d101

Example Query

Query with partition filter

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

iDAI_supplyLog_event

DAI supply event logs from Instadapp’s iDAI (interest-bearing DAI) token contract on Ethereum, recording deposits with caller address, recipient, and DAI amounts in wei. Used to track liquidity provisioning and yield strategy flows through Instadapp’s DeFi protocol aggregator.

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`	Amount of tokens involved in the operation. String-encoded integer representing the value in the token’s smallest unit.
`in_caller_`	`STRING`	Address of the account that initiated the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to_`	`STRING`	Recipient address of the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to_	address	removed	log_index	in_amount_	in_caller_	block_number	block_timestamp	transaction_hash
0xceea299d63fdd2d05b4406918a1bdeb429a24316	0x40a9d39aa50871df092538c5999b107f34409061	false	162	265217000000000000000000	0xceea299d63fdd2d05b4406918a1bdeb429a24316	15987930	2022-11-17T06:23:47.000Z	0xc17646a208a70b467b1643393a842a6c4bee5dacc15ddfeb1068be4a0e2c8c89
0x54426307974b659b48e70b1faa44f17aa0e3c4cf	0x40a9d39aa50871df092538c5999b107f34409061	false	22	13021000000000000000000	0x54426307974b659b48e70b1faa44f17aa0e3c4cf	15988346	2022-11-17T07:47:23.000Z	0xb7833951f42edbe15de23d413169227f3ded609d010722999113217d17b12efc
0x94dd6b39b4beb7566b01400c084680d35249c531	0x40a9d39aa50871df092538c5999b107f34409061	false	57	100000000000000000000000	0x94dd6b39b4beb7566b01400c084680d35249c531	15986051	2022-11-17T00:06:35.000Z	0xd040b088e03642d706e9d192e14b7928b3cfc29708ee5247d72ab05649f246b5

Example Query

Query with partition filter

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

iDAI_updateFeesLog_event

Fee parameter update events from Instadapp’s iDAI vault contract on Ethereum. Tracks changes to revenue, deleverage, withdrawal, and swap fees (measured in basis points) for analyzing vault economics and fee structure evolution.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_revenueFee_`	`STRING`	Revenue fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.
`in_withdrawalFee_`	`STRING`	Withdrawal fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.
`in_swapFee_`	`STRING`	Swap fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.
`in_deleverageFee_`	`STRING`	Deleverage fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.

Sample Data

address	removed	log_index	in_swapFee_	block_number	in_revenueFee_	block_timestamp	transaction_hash	in_deleverageFee_	in_withdrawalFee_
0x40a9d39aa50871df092538c5999b107f34409061	false	165	5	14880669	1000	2022-05-31T20:06:37.000Z	0xa441b2b081b1c50b542bfda9b51a32d8b624224a974513455f3db4b3bc9ffcda	0	1

Example Query

Query with partition filter

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

iDAI_withdrawLog_event

Withdrawal event logs from Instadapp’s iDAI (interest-bearing DAI) token contract on Ethereum, capturing caller addresses, recipient addresses, and withdrawal amounts in wei. Used for tracking DeFi Smart Account DAI withdrawals and analyzing liquidity movement 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_amount_`	`STRING`	Amount of tokens involved in the operation. String-encoded integer representing the value in the token’s smallest unit.
`in_caller_`	`STRING`	Address of the account that initiated the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to_`	`STRING`	Recipient address of the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to_	address	removed	log_index	in_amount_	in_caller_	block_number	block_timestamp	transaction_hash
0xeac446a86091dac36348df5fec35a09d0bd8e7d7	0x40a9d39aa50871df092538c5999b107f34409061	false	869	115792089237316195423570985008687907853269984665640564039457584007913129639935	0xeac446a86091dac36348df5fec35a09d0bd8e7d7	17177892	2023-05-03T04:40:35.000Z	0x37c73dc53f5233c44981b88e41e7e271a1d41b75134b94dc8d1ffa2285b2a673
0x55d9bdb8f45b5023a190503a689887f747ee4084	0x40a9d39aa50871df092538c5999b107f34409061	false	282	1500000000000000000000	0x55d9bdb8f45b5023a190503a689887f747ee4084	16168838	2022-12-12T13:10:47.000Z	0xa69e0997acb1508f33f15b0a9790ca32dbf2a0d60fc034307fcbfceb46a560e1
0xbdb910984f263ff8cb96ee765067a8f95e0ed587	0x40a9d39aa50871df092538c5999b107f34409061	false	55	40000000000000000000000	0xbdb910984f263ff8cb96ee765067a8f95e0ed587	16166812	2022-12-12T06:22:47.000Z	0xd20a04f7dc008162e32431a4ff359fee782c9aa146089fcbca4462ee9772a057

Example Query

Query with partition filter

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

iETH_collectRevenueLog_event

Revenue collection events from Instadapp’s iETH vault on Ethereum, tracking withdrawals of protocol fees in WETH (Wrapped Ether) and stETH (Staked Ether) to designated recipient addresses. Used for analyzing protocol revenue streams and fee distribution 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_amount_`	`STRING`	Amount of tokens involved in the operation. String-encoded integer representing the value in the token’s smallest unit.
`in_stethAmt_`	`STRING`	Amount of stETH (Lido Staked Ether) tokens collected as revenue, denominated in wei (10^-18 stETH). This field contains the raw integer value and may be zero when revenue is collected in other token formats like WETH.
`in_wethAmt_`	`STRING`	Amount of Wrapped Ether (WETH) collected as revenue in the transaction, denominated in wei (10^-18 ETH). Can be zero when revenue is collected entirely in other tokens like stETH.
`in_to_`	`STRING`	Recipient address of the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to_	address	removed	log_index	in_amount_	in_wethAmt_	block_number	in_stethAmt_	block_timestamp	transaction_hash
0x28849d2b63fa8d361e5fc15cb8abb13019884d09	0xc383a3833a87009fd9597f8184979af5edfad019	false	181	243278015545443710109	0	16958659	243278015545443710109	2023-04-02T03:09:35.000Z	0x9c8a602c368270c75e7640ac5fd411850459445b0926fdce26e1889c8e81d101

Example Query

Query with partition filter

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

iETH_supplyLog_event

Supply events for Instadapp’s iETH vault on Ethereum, recording deposits of ETH and stETH (Lido Staked Ether) with recipient addresses and amounts. Used for tracking vault inflows and user deposit activity across different token 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_token_`	`STRING`	Contract address of the token being supplied to the Instadapp iETH vault. Uses the special address 0xeeee…eeee to represent native ETH, while other addresses like 0xae7a…fe84 represent ERC-20 tokens such as stETH.
`in_amount_`	`STRING`	Amount of tokens involved in the operation. String-encoded integer representing the value in the token’s smallest unit.
`in_to_`	`STRING`	Recipient address of the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to_	address	removed	in_token_	log_index	in_amount_	block_number	block_timestamp	transaction_hash
0xd5daaab4e9243e0f5889216f06c95296135da0ec	0xc383a3833a87009fd9597f8184979af5edfad019	false	0xae7ab96520de3a18e5e111b5eaab095312d7fe84	90	2302420203013815888	16622081	2023-02-13T20:00:35.000Z	0x7ec918e16977acb2a4decd0d6a686b47ba8debf62b6af3964a08c45e06bdd468
0x6b6ca461435ff2c9d21bcbee58e8b6061ae0f851	0xc383a3833a87009fd9597f8184979af5edfad019	false	0xae7ab96520de3a18e5e111b5eaab095312d7fe84	112	250409744610043892	16617364	2023-02-13T04:10:59.000Z	0x8eeb6a83bdf9ccd540c73cac7dd5f135655e66a7654332bef541a84c3f07d776
0xf3d6c27401acf73c795f49adc13d094e53f4c4cf	0xc383a3833a87009fd9597f8184979af5edfad019	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	120	1333000000000000000	16619814	2023-02-13T12:23:23.000Z	0xede5054d6f73d3352cb6f8675582b97cda12c4c09b06e5eaa84f01dc70b36e30

Example Query

Query with partition filter

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

iETH_updateFeesLog_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_revenueFee_`	`STRING`	Revenue fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.
`in_withdrawalFee_`	`STRING`	Withdrawal fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.
`in_swapFee_`	`STRING`	Swap fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.
`in_deleverageFee_`	`STRING`	Deleverage fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

iETH_withdrawLog_event

ETH withdrawal events from Instadapp’s iETH token contract on Ethereum, recording recipient addresses and withdrawal amounts in wei. Used for tracking user redemptions and liquidity outflows from the protocol.

Columns

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

Sample Data

in_to_	address	removed	log_index	in_amount_	block_number	block_timestamp	transaction_hash
0x5ab404ab63831bfcf824f53b4ac3737b9d155d90	0xc383a3833a87009fd9597f8184979af5edfad019	false	271	49900000000000000000	14760384	2022-05-12T09:46:09.000Z	0xe739411053745210a15ad6b55feaac69194170c8ebf8fcd3957db665d78050a2
0xf212ce21a97dbe30999a4c2b309d278bccbb686a	0xc383a3833a87009fd9597f8184979af5edfad019	false	228	1500000000000000000	14758045	2022-05-12T00:34:51.000Z	0x6babaad730e0bbcd40939079fb020a1ca29b9895e5c75642c0f4ad626f27c37a
0x2732461fe2b5cec445b361d834f3d5f4c4b9ecca	0xc383a3833a87009fd9597f8184979af5edfad019	false	343	468000000000000000	14758698	2022-05-12T03:12:27.000Z	0xa23643924a2d6d9649e4c9739d559693f753eeb322beb260ad82eeefb83c1b81

Example Query

Query with partition filter

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

InstaFlashAggregator_LogFlashloan_event

Flash loan execution events from Instadapp’s aggregator contract on Ethereum, recording borrowed token amounts, recipient accounts, and routing providers. Used for analyzing flash loan usage patterns, popular lending protocols, and DeFi arbitrage 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_route`	`STRING`	Identifier for the flash loan provider route used to source the loan. String-encoded integer indicating which lending protocol or liquidity source fulfilled the flash loan request.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_amounts`	`ARRAY<STRING>`	Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).

Sample Data

address	removed	in_route	in_tokens	log_index	in_account	in_amounts	block_number	block_timestamp	transaction_hash
0x619ad2d02dbee6eba3cdbda3f98430410e892882	false	5	[“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”]	107	0xb3d8cca14f249cf68e5272c1e7623bfecc705591	[“362500000000000000000”]	15498924	2022-09-08T21:28:04.000Z	0x4d031d4241f0629e7551e4292e3099297448418c981c82b9697f3d7ce467b6e7
0x619ad2d02dbee6eba3cdbda3f98430410e892882	false	5	[“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”]	102	0xc651a7356d2ece899a150dfc0d8456fa2695cc82	[“5000000000000000000”]	15497298	2022-09-08T15:11:48.000Z	0x068a296468c9e0d3a9f0945f75139effc89a03d6c60a4823ba8ee824634d5944
0x619ad2d02dbee6eba3cdbda3f98430410e892882	false	5	[“0x6b175474e89094c44da98b954eedeac495271d0f”]	220	0xb821a5da474c1baa1f3e3e6e440171cf08c7396a	[“20000000000000000000000”]	15496521	2022-09-08T12:18:31.000Z	0x3a35a59c0d86be9f47ab695c9c2fbc3193cdc4f3e8762f4f309fd8982a646850

Example Query

Query with partition filter

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

iUSDC_collectRevenueLog_event

Revenue collection events from Instadapp’s iUSDC vault on Ethereum, recording when protocol fees are withdrawn to designated addresses. Tracks recipient addresses and USDC amounts (in base units) for monitoring protocol revenue extraction.

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`	Amount of tokens involved in the operation. String-encoded integer representing the value in the token’s smallest unit.
`in_to_`	`STRING`	Recipient address of the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to_	address	removed	log_index	in_amount_	block_number	block_timestamp	transaction_hash
0x28849d2b63fa8d361e5fc15cb8abb13019884d09	0xc8871267e07408b89aa5aecc58adca5e574557f8	false	184	85894238641	16958659	2023-04-02T03:09:35.000Z	0x9c8a602c368270c75e7640ac5fd411850459445b0926fdce26e1889c8e81d101

Example Query

Query with partition filter

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

iUSDC_supplyLog_event

USDC supply events from Instadapp’s iUSDC token contract on Ethereum, recording deposits of USDC (amounts in 6-decimal format) with caller and recipient addresses. Used for tracking liquidity provision and yield farming activity in Instadapp’s DeFi Smart Layer.

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`	Amount of tokens involved in the operation. String-encoded integer representing the value in the token’s smallest unit.
`in_caller_`	`STRING`	Address of the account that initiated the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to_`	`STRING`	Recipient address of the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to_	address	removed	log_index	in_amount_	in_caller_	block_number	block_timestamp	transaction_hash
0xe9da858c0109fc4811f3dd4fa3969e8d88593193	0xc8871267e07408b89aa5aecc58adca5e574557f8	false	62	3000000000	0xe9da858c0109fc4811f3dd4fa3969e8d88593193	15728884	2022-10-12T01:55:59.000Z	0xa13a5a20b731726440d3fc8426bb7fa2cdfa6f3ea80d64aa887222e432568ef3
0xa663473951a57fe34c0a8f4e3d869a29593cf5bc	0xc8871267e07408b89aa5aecc58adca5e574557f8	false	103	9039130000	0xa663473951a57fe34c0a8f4e3d869a29593cf5bc	14691411	2022-05-01T10:22:11.000Z	0xecd82a893bb3d21091bb064c80d3c9ea38bec1691c0f50bb3687323d5e37b3f5
0xf212ce21a97dbe30999a4c2b309d278bccbb686a	0xc8871267e07408b89aa5aecc58adca5e574557f8	false	26	241373000000	0xf212ce21a97dbe30999a4c2b309d278bccbb686a	14693907	2022-05-01T19:51:49.000Z	0xd753d224f2744622e82b1a52032e892c6b09d7d8411c3d1c2ef4e64f47c2d1d4

Example Query

Query with partition filter

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

iUSDC_updateFeesLog_event

Fee parameter update events for Instadapp’s iUSDC vault on Ethereum, recording changes to swap, withdrawal, revenue, and deleverage fee rates in basis points for protocol governance 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_revenueFee_`	`STRING`	Revenue fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.
`in_withdrawalFee_`	`STRING`	Withdrawal fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.
`in_swapFee_`	`STRING`	Swap fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.
`in_deleverageFee_`	`STRING`	Deleverage fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.

Sample Data

address	removed	log_index	in_swapFee_	block_number	in_revenueFee_	block_timestamp	transaction_hash	in_deleverageFee_	in_withdrawalFee_
0xc8871267e07408b89aa5aecc58adca5e574557f8	false	163	5	14880669	1000	2022-05-31T20:06:37.000Z	0xa441b2b081b1c50b542bfda9b51a32d8b624224a974513455f3db4b3bc9ffcda	0	1
0xc8871267e07408b89aa5aecc58adca5e574557f8	false	8	5	14572640	1000	2022-04-12T19:26:31.000Z	0xff263e48f758b00922727c828644dc1c3b6e4406e473625f412cfe0af8f48fd3	1	1

Example Query

Query with partition filter

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

iUSDC_withdrawLog_event

Withdrawal event logs from Instadapp’s iUSDC (interest-bearing USDC) vault on Ethereum, recording user redemptions with amounts, recipient addresses, and transaction details. Used for tracking vault outflows and user withdrawal 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_amount_`	`STRING`	Amount of tokens involved in the operation. String-encoded integer representing the value in the token’s smallest unit.
`in_caller_`	`STRING`	Address of the account that initiated the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to_`	`STRING`	Recipient address of the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to_	address	removed	log_index	in_amount_	in_caller_	block_number	block_timestamp	transaction_hash
0x74b3691ebc3fb083e36065a1986d6c490b13e95a	0xc8871267e07408b89aa5aecc58adca5e574557f8	false	138	200000000000	0x74b3691ebc3fb083e36065a1986d6c490b13e95a	15924660	2022-11-08T10:17:11.000Z	0xa29a2eafcc254c7060a73c851e1aa00b0fca72c0c5be1a189de6e762cb02450c
0x74b3691ebc3fb083e36065a1986d6c490b13e95a	0xc8871267e07408b89aa5aecc58adca5e574557f8	false	225	200000000000	0x74b3691ebc3fb083e36065a1986d6c490b13e95a	15925955	2022-11-08T14:36:47.000Z	0x6295fa0db37c87e39f1cb7ba12c19ce1ca31de28a6f1a90d322b7b7e1ea6c770
0x74b3691ebc3fb083e36065a1986d6c490b13e95a	0xc8871267e07408b89aa5aecc58adca5e574557f8	false	200	200000000000	0x74b3691ebc3fb083e36065a1986d6c490b13e95a	15927230	2022-11-08T18:52:59.000Z	0xbf6b51b2ede7362bcc87fecba81008cac2aef686c3f792fa810ee4e8a2e62041

Example Query

Query with partition filter

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

iWBTC_collectRevenueLog_event

Revenue collection events from Instadapp’s iWBTC (interest-bearing Wrapped Bitcoin) vault on Ethereum. Tracks protocol fee withdrawals with recipient addresses and amounts for monitoring vault economics and treasury flows.

Columns

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

Sample Data

in_to_	address	removed	log_index	in_amount_	block_number	block_timestamp	transaction_hash
0x28849d2b63fa8d361e5fc15cb8abb13019884d09	0xec363faa5c4dd0e51f3d9b5d0101263760e7cdeb	false	187	285918569	16958659	2023-04-02T03:09:35.000Z	0x9c8a602c368270c75e7640ac5fd411850459445b0926fdce26e1889c8e81d101

Example Query

Query with partition filter

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

iWBTC_supplyLog_event

Wrapped Bitcoin (WBTC) supply events from Instadapp’s iWBTC lending pool on Ethereum, recording deposits with amounts, caller addresses, and recipient addresses. Used for tracking WBTC lending activity and liquidity provider behavior in Instadapp’s DeFi protocol.

Columns

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

Sample Data

in_to_	address	removed	log_index	in_amount_	in_caller_	block_number	block_timestamp	transaction_hash
0xad948e1f72218196d23276b4f092ba8fa75b93c8	0xec363faa5c4dd0e51f3d9b5d0101263760e7cdeb	false	46	58240000	0xad948e1f72218196d23276b4f092ba8fa75b93c8	16163041	2022-12-11T17:44:35.000Z	0x00ae75492128fbf9826bfb5f895e50f6ef2ec63c55ca4feb8f1e7d4ca115287a
0xc6339709cb26e8655595c2273886ec6a535511f2	0xec363faa5c4dd0e51f3d9b5d0101263760e7cdeb	false	21	1000000000	0xc6339709cb26e8655595c2273886ec6a535511f2	15668550	2022-10-03T15:33:59.000Z	0xa8a55cf23a404f94b1beafae534ece4bbf551abd17def15fdc425dc807b13214
0x0550bed1c94afbd468aa739852632d7e9b4c2f86	0xec363faa5c4dd0e51f3d9b5d0101263760e7cdeb	false	177	24360000	0x0550bed1c94afbd468aa739852632d7e9b4c2f86	15667382	2022-10-03T11:39:23.000Z	0x2cb15fee7fc7adcaa12680223fef4aea6dfc9572d879beeca7f7125d8d8a3a47

Example Query

Query with partition filter

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

iWBTC_updateFeesLog_event

Fee parameter change events for Instadapp’s iWBTC vault on Ethereum. Tracks updates to swap, revenue, deleverage, and withdrawal fee configurations in basis points for analyzing vault economics and governance decisions.

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_revenueFee_`	`STRING`	Revenue fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.
`in_withdrawalFee_`	`STRING`	Withdrawal fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.
`in_swapFee_`	`STRING`	Swap fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.
`in_deleverageFee_`	`STRING`	Deleverage fee charged by the Instadapp protocol, measured in basis points. Numeric string representing fee percentage where 1 equals 0.01%.

Sample Data

address	removed	log_index	in_swapFee_	block_number	in_revenueFee_	block_timestamp	transaction_hash	in_deleverageFee_	in_withdrawalFee_
0xec363faa5c4dd0e51f3d9b5d0101263760e7cdeb	false	164	5	14880669	1000	2022-05-31T20:06:37.000Z	0xa441b2b081b1c50b542bfda9b51a32d8b624224a974513455f3db4b3bc9ffcda	0	1

Example Query

Query with partition filter

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

iWBTC_withdrawLog_event

Withdrawal event logs from Instadapp’s iWBTC (interest-bearing Wrapped Bitcoin) vault on Ethereum, capturing WBTC redemptions with caller address, recipient, and withdrawal amounts in satoshis. Used for tracking user fund movements and analyzing vault liquidity changes.

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`	Amount of tokens involved in the operation. String-encoded integer representing the value in the token’s smallest unit.
`in_caller_`	`STRING`	Address of the account that initiated the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to_`	`STRING`	Recipient address of the operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

in_to_	address	removed	log_index	in_amount_	in_caller_	block_number	block_timestamp	transaction_hash
0x736dde3e0f5c588ddc53ad7f0f65667c0cca2801	0xec363faa5c4dd0e51f3d9b5d0101263760e7cdeb	false	63	480000000	0x736dde3e0f5c588ddc53ad7f0f65667c0cca2801	16673254	2023-02-21T00:13:59.000Z	0xc7f5776669e8a227e71639c708b467c4f5c20948c848999f6052a3cffa9a08c9
0x4f58985b75eec8f14c536878a19eadf4a1960d6c	0xec363faa5c4dd0e51f3d9b5d0101263760e7cdeb	false	91	1954990000	0x4f58985b75eec8f14c536878a19eadf4a1960d6c	16675974	2023-02-21T09:26:35.000Z	0x20733e9ab3caf0915be3581653084f7036a7a326b8a4843414a7005053c82941
0x4f58985b75eec8f14c536878a19eadf4a1960d6c	0xec363faa5c4dd0e51f3d9b5d0101263760e7cdeb	false	78	2116990000	0x4f58985b75eec8f14c536878a19eadf4a1960d6c	16675944	2023-02-21T09:20:35.000Z	0x829d61a01c19f84c7098a1429d8e45f9209d41264658be0bb35076069150e672

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AvoForwarder_Executed_event

AvoForwarderMultisig_Executed_event

Factory_DexT1Deployed_event

Factory_LogDexDeployed_event

Factory_VaultDeployed_event

FluidDex_Swap_event

FluidDexLite_LogSwap_event

FluidLendingFactory_LogTokenCreated_event

FluidVaultT1_LogOperate_event

FluidVaultT1_LogRebalance_event

iDAI_collectRevenueLog_event

iDAI_supplyLog_event

iDAI_updateFeesLog_event

iDAI_withdrawLog_event

iETH_collectRevenueLog_event

iETH_supplyLog_event

iETH_updateFeesLog_event

iETH_withdrawLog_event

InstaFlashAggregator_LogFlashloan_event

iUSDC_collectRevenueLog_event

iUSDC_supplyLog_event

iUSDC_updateFeesLog_event

iUSDC_withdrawLog_event

iWBTC_collectRevenueLog_event

iWBTC_supplyLog_event

iWBTC_updateFeesLog_event

iWBTC_withdrawLog_event

​Tables

​AvoForwarder_Executed_event

​AvoForwarderMultisig_Executed_event

​Factory_DexT1Deployed_event

​Factory_LogDexDeployed_event

​Factory_VaultDeployed_event

​FluidDex_Swap_event

​FluidDexLite_LogSwap_event

​FluidLendingFactory_LogTokenCreated_event

​FluidVaultT1_LogOperate_event

​FluidVaultT1_LogRebalance_event

​iDAI_collectRevenueLog_event

​iDAI_supplyLog_event

​iDAI_updateFeesLog_event

​iDAI_withdrawLog_event

​iETH_collectRevenueLog_event

​iETH_supplyLog_event

​iETH_updateFeesLog_event

​iETH_withdrawLog_event

​InstaFlashAggregator_LogFlashloan_event

​iUSDC_collectRevenueLog_event

​iUSDC_supplyLog_event

​iUSDC_updateFeesLog_event

​iUSDC_withdrawLog_event

​iWBTC_collectRevenueLog_event

​iWBTC_supplyLog_event

​iWBTC_updateFeesLog_event

​iWBTC_withdrawLog_event

Tables

AvoForwarder_Executed_event

AvoForwarderMultisig_Executed_event

Factory_DexT1Deployed_event

Factory_LogDexDeployed_event

Factory_VaultDeployed_event

FluidDex_Swap_event

FluidDexLite_LogSwap_event

FluidLendingFactory_LogTokenCreated_event

FluidVaultT1_LogOperate_event

FluidVaultT1_LogRebalance_event

iDAI_collectRevenueLog_event

iDAI_supplyLog_event

iDAI_updateFeesLog_event

iDAI_withdrawLog_event

iETH_collectRevenueLog_event

iETH_supplyLog_event

iETH_updateFeesLog_event

iETH_withdrawLog_event

InstaFlashAggregator_LogFlashloan_event

iUSDC_collectRevenueLog_event

iUSDC_supplyLog_event

iUSDC_updateFeesLog_event

iUSDC_withdrawLog_event

iWBTC_collectRevenueLog_event

iWBTC_supplyLog_event

iWBTC_updateFeesLog_event

iWBTC_withdrawLog_event