instadapp_v1_polygon

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	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	98	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000e07472616e736665720000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000600000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f61900000000000000000000000000000000000000000000000001ef72071caa3ad60000000000000000000000003a083b42b9ac971c16ed61779fc4e772fcd49cfd	60150754	2024-08-03T16:12:45.000Z	0x9800020b610194dba52cf606e8aa142f9f256166	0x2387e3a5eb55531332864c9af09d119e00f72cf6f165b7d9a17eeb4b0ca1ef24	0x3a083b42b9ac971c16ed61779fc4e772fcd49cfd
0x375f6b0cd12b34dc28e34c26853a37012c24dde5	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	157	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000e07472616e73666572000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000060000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f0000000000000000000000000000000000000000000000000000000017835e9a0000000000000000000000007b09cc602e06c1e7e34a5ed209d5f9d22a5ecbca	60150784	2024-08-03T16:14:15.000Z	0x9800020b610194dba52cf606e8aa142f9f256166	0x179f633736cdf77ab3ef1ee54310fb86687a9210b518b123858ccf06cac27a3f	0x3a083b42b9ac971c16ed61779fc4e772fcd49cfd
0x375f6b0cd12b34dc28e34c26853a37012c24dde5	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	112	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014073776170000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f000000000000000000000000972999c58bbce63a2e398d4ed3bde414b8349eb3000000000000000000000000000000000000000000000000000000000074adcb000000000000000000000000000000000000000000000002928c96c0f06de508000000000000000000000000705f8f0eaac561aabb1d5d8f4d0dab36d5a62e8670617261737761702d7635000000000000000000000000000000000000000000	60135039	2024-08-03T06:26:00.000Z	0x705f8f0eaac561aabb1d5d8f4d0dab36d5a62e86	0x007245c6ff4d11672ad7c687150659dfc6914f80fd5a344d0299727315fa9d3d	0xeb0d6abda6fee522cfd8e42c64186a84fbc03bd0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_polygon.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_source	log_index	in_metadata	block_number	block_timestamp	in_avocadoOwner	transaction_hash	in_avocadoAddress
0x46978cd477a496028a18c02f07ab7f35edba5a54	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	293	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000009496e737461646170700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001c68747470733a2f2f706f6c79676f6e2e696e737461646170702e696f00000000	56042881	2024-04-20T11:31:44.000Z	0x8961ce440fe7a401fc1eda5e641e2020d12ba167	0xd02e73231770c846dbbe4c85fdf4e3ff139cf58c1dc3b919a4dd0224ad6d1b73	0x171f4cecbc26716e7eed42c1ca05565b5595fed7
0x46978cd477a496028a18c02f07ab7f35edba5a54	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	190	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000009496e737461646170700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001c68747470733a2f2f706f6c79676f6e2e696e737461646170702e696f00000000	56042853	2024-04-20T11:30:44.000Z	0x8961ce440fe7a401fc1eda5e641e2020d12ba167	0xf2ab070e7db5d78882747981351dc494f58f5d171846a185c38c5e3cb7458a4e	0x171f4cecbc26716e7eed42c1ca05565b5595fed7
0x46978cd477a496028a18c02f07ab7f35edba5a54	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	150	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000e07472616e736665720000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000600000000000000000000000002791bca1f2de4661ed88a30c99a7a9449aa841740000000000000000000000000000000000000000000000000000000003567e000000000000000000000000001f906ab7bd49059d29cac759bc84f9008dbf4112	56043774	2024-04-20T12:03:54.000Z	0x1f906ab7bd49059d29cac759bc84f9008dbf4112	0x355bed72cf62857037bbc590d11c7b40cc4f2959c1bcb48d427b7e54062a9a9e	0x24562d631857b690de393199c213942f3c0951e5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_polygon.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
0xde632c3a214d5f14c1d8ddf0b92f8bcd188fee45	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	4	47	69475225	0x3c499c542cef5e3811e1192ce70d8cc03d5c3359	0x00000000efe302beaa2b3e6e1b18d08d69a9012a	2025-03-25T08:20:59.000Z	0x11667bebcbf0f370e06cddb497902c2ab56b142b0a04fa42610872842c0f079f
0x0b1a513ee24972daef112bc777a5610d4325c9e7	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	1	27	69475141	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	0x3c499c542cef5e3811e1192ce70d8cc03d5c3359	2025-03-25T08:18:01.000Z	0xbc120a45616d8fd85a05acf823ebee87b82c1cde51919e51913d3e470f76419a
0x3c0441b42195f4ad6aa9a0978e06096ea616cda7	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	3	31	69475197	0x57f5e098cad7a3d1eed53991d4d66c45c9af7812	0x3c499c542cef5e3811e1192ce70d8cc03d5c3359	2025-03-25T08:19:59.000Z	0xc1c05279cb400dd64be1e2dbaba9466f353dd34db3683adf5663043cd583dd88

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_polygon.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
0x667701e51b4d1ca244f17c78f7ab8744b4c99f9b	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	2	71	69475158	2025-03-25T08:18:37.000Z	0xfbfb315a6a92d8df1bc050db45531868e4352ad3e569609893c21c642eb76201
0xde632c3a214d5f14c1d8ddf0b92f8bcd188fee45	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	4	48	69475225	2025-03-25T08:20:59.000Z	0x11667bebcbf0f370e06cddb497902c2ab56b142b0a04fa42610872842c0f079f
0x0b1a513ee24972daef112bc777a5610d4325c9e7	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	1	28	69475141	2025-03-25T08:18:01.000Z	0xbc120a45616d8fd85a05acf823ebee87b82c1cde51919e51913d3e470f76419a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_polygon.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	0x01c7c1c41dea58b043e700efb23dc077f12a125e	47	29	71760643	2025-05-20T19:40:17.000Z	0xb46aacd3b635d0cbf5acc939ce52d53b2157c4c37ff5490268d9da94c28063ff
0x324c5dc1fc42c7a4d43d92df1eba58a54d13bf2d	false	0xdf16adaf80584b2723f3ba1eb7a601338ba18c4e	38	10	68649766	2025-03-04T20:43:55.000Z	0x0382c8057024fa1de064f2a0d800fc0f544bb7b631eb33888edf2ec1b7d726c7
0x324c5dc1fc42c7a4d43d92df1eba58a54d13bf2d	false	0x40d9b8417e6e1dcd358f04e3328bced061018a82	59	6	68649700	2025-03-04T20:41:35.000Z	0xe89ca1b33650757a102f51828f60b4179c1a557bb4dd12f96d826f4420f294c2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_polygon.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
0x000010036c0190e009a000d0fc3541100a07380a	0x2886a01a0645390872a9eb99dae1283664b0c524	false	17	500347015	false	77153366	500285249	2025-10-02T03:57:03.000Z	0xab2d5234ad02074e6340711f5a572291b4d008eb467dcd6ffafd21c4b9a044a7
0x000010036c0190e009a000d0fc3541100a07380a	0x2886a01a0645390872a9eb99dae1283664b0c524	false	12	500313335	false	77153718	500251354	2025-10-02T04:09:31.000Z	0x98a91eb941ad3ecfc461b7376f427b67ed045f439949e390706a1f76ef0d3e83
0x00c600b30fb0400701010f4b080409018b9006e0	0x2886a01a0645390872a9eb99dae1283664b0c524	false	21	330250143	false	77153228	330209448	2025-10-02T03:52:09.000Z	0x9bfde49934e3f400d087ccaea2b857a7d09d62bf36c6ba3dc169d1e473f67db9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_polygon.FluidDex_Swap_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	0x00000000efe302beaa2b3e6e1b18d08d69a9012a	6	0xd70dd80bc39d56e21a4475f72021bc6c5b0e4518	84	69559905	fToken	2025-03-27T10:57:37.000Z	0xe4a311022c6f5f7633e9951957f55fe8dc2196ec982c30f75f1e9bcc83226289
0x54b91a0d94cb471f37f949c60f7fa7935b551d03	false	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	5	0x41b8b33a413681cb7d869d287e99c30c6df775b9	136	68649665	NativeUnderlying	2025-03-04T20:40:21.000Z	0xe74c2856def13156962949df8f1956be9daac6bad0babb829850bb65312a8467
0x54b91a0d94cb471f37f949c60f7fa7935b551d03	false	0x3c499c542cef5e3811e1192ce70d8cc03d5c3359	1	0x571d456b578fdc34e26e6d636736ed7c0cdb9d89	178	68643675	fToken	2025-03-04T17:05:03.000Z	0x9462e3e2fa00a4500ecd95f2e294939c4c912171f23e482080cbe133f8d2d9b8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_polygon.FluidLendingFactory_LogTokenCreated_event`
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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_polygon.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	0x8c618d33463f10ddaecba2739fcfb25d58c23243	false	0x03b54a6e9a984069379fae1a4fc4dbae93b3bccd	198	0x0000000000000000000000000000000000000000	76734014	0x663b3b2e7eb0dd11ee628aea5522dc4d54919e29	2025-09-21T19:35:10.000Z	-5620691309868468	17740234194740679951	0x37b1a89ae07a1c355493954145ae7944e09ec60b987bbd45c0718ed67f4355d6	45671926166590716196341031100955111753973181364321420574720
0x52aa899454998be5b000ad077a46bbe360f4e497	0x8c618d33463f10ddaecba2739fcfb25d58c23243	false	0x03b54a6e9a984069379fae1a4fc4dbae93b3bccd	400	0x0000000000000000000000000000000000000000	76733977	0x0000000000000000000000000000000000000000	2025-09-21T19:33:52.000Z	5620691309868468	17740278106391538447	0xcf061a7bc3a275437410f7d0722e04384946af830f8cdc0ffa9c1040b01174eb	45671926166590716196341031100955111753973181364321420574720
0x52aa899454998be5b000ad077a46bbe360f4e497	0xbc345229c1b52e4c30530c614bb487323ba38da5	false	0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6	504	0x0000000000000000000000000000000000000000	76715433	0x0000000000000000000000000000000000000000	2025-09-21T08:37:04.000Z	291812	8712948799486319134252920832396742727185119644416	0x657ca08d51b29fe640b9d73eb96230236c5b46af9ba7278aee377153cdb5b93d	45673293791684720275705273607695356040187735205567384780807

Example Query

Query with partition filter

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

FluidVaultT2_LogOperate_event

Vault operation events from Instadapp’s Fluid Protocol on Polygon, tracking collateral and debt changes for NFT-identified positions. Used for analyzing lending position management, liquidations, and user borrowing behavior across the protocol’s Type 2 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_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
0xf641e91a1d976a0d6c8fcf23b5193a035e96e064	0x1c2bb46f36561bc4f05a94bd50916496aa501078	false	0xf641e91a1d976a0d6c8fcf23b5193a035e96e064	1467	46	-3000000000000000000	-3199997343468523498	79067015	2025-11-15T20:37:31.000Z	0xd7f296c9a3ba2c4a07f47b49ce9a93078a4c0939e5aabb517db59c2460928280
0xf641e91a1d976a0d6c8fcf23b5193a035e96e064	0x1c2bb46f36561bc4f05a94bd50916496aa501078	false	0xf641e91a1d976a0d6c8fcf23b5193a035e96e064	1467	184	-2584088461426626239	-2600512165059246644	79068621	2025-11-15T21:31:03.000Z	0xbf5d07fdbc20a0eebce26f97682f03c8dd3794ca30453d023acc3d003b40276f
0xf641e91a1d976a0d6c8fcf23b5193a035e96e064	0x1c2bb46f36561bc4f05a94bd50916496aa501078	false	0xf641e91a1d976a0d6c8fcf23b5193a035e96e064	1473	432	1067093344126605680	1200000000000000000	79066660	2025-11-15T20:25:41.000Z	0x6a2cac6016cc58799065d494be0b5e19976f034b7ab0e202e22f00a8acf291b4

Example Query

Query with partition filter

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

FluidVaultT2_LogRebalance_event

Rebalancing events from Instadapp’s Fluid Vault T2 protocol on Polygon, tracking collateral and debt position adjustments. Contains vault address, collateral amount changes (in_colAmt_), and debt amount changes (in_debtAmt_) for analyzing vault health management and liquidation prevention 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_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
0xb4f3bf2d96139563777c0231899ce06ee95cc946	false	979	-375545745	2004215486	77624834	2025-10-13T11:19:03.000Z	0x5c76b3edd8d5ed77791d8436232cbee34453c1f2419934eafc9a0440c3f8a6d9
0x1982cc7b1570c2503282d0a0b41f69b3b28fdcc3	false	419	-41269284	230831052	77624824	2025-10-13T11:18:43.000Z	0x384ef94c2a32954d7dcddc8b76567d3a7258ea6e7307667e0be1ed78f8569ffd

Example Query

Query with partition filter

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

InstaFlashAggregatorPolygon_LogFlashloan_event

Flash loan execution events from Instadapp’s Flash Aggregator contract on Polygon, recording borrowed token addresses, amounts, routing providers, and borrower accounts for analyzing flash loan usage patterns and liquidity sources.

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
0xb2a7f20d10a006b0bea86ce42f2524fde5d6a0f4	false	1	[“0x8f3cf7ad23cd3cadbd9735aff958023239c6a063”]	674	0xc43df82983e655bd759e79fdee35360c987a39a2	[“64507945144127460000”]	30251953	2022-07-02T12:44:37.000Z	0x31f5aed2922b818bdb243924fb6c61174e149f37b5751c7359a807f25d7a9568
0xb2a7f20d10a006b0bea86ce42f2524fde5d6a0f4	false	1	[“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”]	233	0xc43df82983e655bd759e79fdee35360c987a39a2	[“159832568315485630”]	30246944	2022-07-02T09:34:39.000Z	0xf87238377f5fef458cec5bc166dbc447810e703acd8c44b1a6b1b5b844ac9621
0xb2a7f20d10a006b0bea86ce42f2524fde5d6a0f4	false	1	[“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”]	234	0xc43df82983e655bd759e79fdee35360c987a39a2	[“228012753580401250”]	30267152	2022-07-02T22:43:15.000Z	0x7a12777f170c2f36de54287012973d69a05426f9d12472246d80ce3058cd70a9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_polygon.InstaFlashAggregatorPolygon_LogFlashloan_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

FluidLendingFactory_LogTokenCreated_event

FluidLiquidity_LogCollectRevenue_event

FluidLiquidity_LogOperate_event

FluidVaultT2_LogOperate_event

FluidVaultT2_LogRebalance_event

InstaFlashAggregatorPolygon_LogFlashloan_event

​Tables

​AvoForwarder_Executed_event

​AvoForwarderMultisig_Executed_event

​Factory_DexT1Deployed_event

​Factory_LogDexDeployed_event

​Factory_VaultDeployed_event

​FluidDex_Swap_event

​FluidLendingFactory_LogTokenCreated_event

​FluidLiquidity_LogCollectRevenue_event

​FluidLiquidity_LogOperate_event

​FluidVaultT2_LogOperate_event

​FluidVaultT2_LogRebalance_event

​InstaFlashAggregatorPolygon_LogFlashloan_event

Tables

AvoForwarder_Executed_event

AvoForwarderMultisig_Executed_event

Factory_DexT1Deployed_event

Factory_LogDexDeployed_event

Factory_VaultDeployed_event

FluidDex_Swap_event

FluidLendingFactory_LogTokenCreated_event

FluidLiquidity_LogCollectRevenue_event

FluidLiquidity_LogOperate_event

FluidVaultT2_LogOperate_event

FluidVaultT2_LogRebalance_event

InstaFlashAggregatorPolygon_LogFlashloan_event