instadapp_v1_arbitrum

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	2	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000d4761696e73204e6574776f726b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001368747470733a2f2f6761696e732e747261646500000000000000000000000000	178401222	2024-02-07T16:44:34.000Z	0x4eab0d60c1758bf3bdc29257694e00ebc0121f2e	0x41ea3823e9b9e0b0be910360e8a196ec4ecbfa59666e3a12dff337d3f6db3d76	0xefdac5770fb361cfc1ec1e11582e1d7ab50e8f37
0x375f6b0cd12b34dc28e34c26853a37012c24dde5	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	5	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000d4761696e73204e6574776f726b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001368747470733a2f2f6761696e732e747261646500000000000000000000000000	178495686	2024-02-07T23:35:51.000Z	0x4e80b64bd13709ffd694873698addc11fb27a779	0xb88e529e96ec4783bdd6f0618fd71a69819f6c5bf0e05b781632ed72d25451c4	0xb20752c53c40ca87ceda9de15f03b9cda43e0232
0x375f6b0cd12b34dc28e34c26853a37012c24dde5	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	7	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000d4761696e73204e6574776f726b00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001368747470733a2f2f6761696e732e747261646500000000000000000000000000	178495914	2024-02-07T23:36:52.000Z	0x4e80b64bd13709ffd694873698addc11fb27a779	0x45f785548d07bf084d4c67d6b5f201c835a823432fbc8953b2e868dfffa08a12	0xb20752c53c40ca87ceda9de15f03b9cda43e0232

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_arbitrum.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	10	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000016062726964676500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000e000000000000000000000000000000000000000000000000003534fea3117ba0000000000000000000000000057b6d5b35944e24e1f678e9c31550b815c3a4123000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000028688e5b6d4c1000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	210287965	2024-05-11T22:07:29.000Z	0x57b6d5b35944e24e1f678e9c31550b815c3a4123	0x456583d57755f88f08eaf4fcc37ce1757430b59da024b6b4f5303568858ad54e	0x615a8fc9f6f1712e1addd763e1998e4bbd2ebed9
0x46978cd477a496028a18c02f07ab7f35edba5a54	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	13	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014073776170000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000da10009cbd5d07dd0cecc66161fc93d7c9000da1000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000000000000000000000000001553928e9bed42a00000000000000000000000000000000000000000000000000001dd63e56a1d606c00000000000000000000000057b6d5b35944e24e1f678e9c31550b815c3a412331696e63682d7636000000000000000000000000000000000000000000000000	210294272	2024-05-11T22:33:59.000Z	0x57b6d5b35944e24e1f678e9c31550b815c3a4123	0xe27966157b22621476026efbd71a9906e7417f03bc9bd5ba4ae120b87e7a6f71	0x615a8fc9f6f1712e1addd763e1998e4bbd2ebed9
0x46978cd477a496028a18c02f07ab7f35edba5a54	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	60	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014073776170000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000da10009cbd5d07dd0cecc66161fc93d7c9000da1000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000000000000000000000000025f273933db57000000000000000000000000000000000000000000000000000000350c410081bbd4700000000000000000000000057b6d5b35944e24e1f678e9c31550b815c3a41236b796265722d7631000000000000000000000000000000000000000000000000	210287462	2024-05-11T22:05:24.000Z	0x57b6d5b35944e24e1f678e9c31550b815c3a4123	0x628ae416f560c7fb57c2a9b46b3ea4c05313156d48a0db0e42b49e8385f5566b	0x615a8fc9f6f1712e1addd763e1998e4bbd2ebed9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_arbitrum.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
0x8710039d5de6840ede452a85672b32270a709ae2	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	10	13	367548649	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0x66cfbd79257dc5217903a36293120282548e2254	2025-08-12T05:59:21.000Z	0x08677887471d8cbe0774c25e29bdb01b0021f48ee9202d1c1c48484b78d0e5ef
0x2886a01a0645390872a9eb99dae1283664b0c524	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	5	3	338757771	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x61e030a56d33e8260fdd81f03b162a79fe3449cd	2025-05-20T19:40:40.000Z	0x237e0e3969126c8b6b59c9622c4fbb310df6e1629e4c60e7efe1eea29ae8e23b
0xba9ed8ae94c70ef9aa2cd1045ed473aaa405c6c7	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	8	7	359098691	0xaf88d065e77c8cc2239327c5edb3a432268e5831	0x0a1a1a107e45b7ced86833863f482bc5f4ed82ef	2025-07-18T19:47:18.000Z	0xd78a063bc0fbf69b0577d79ba0a03a314a44c1f369ddbf7fcf564156d6977fa2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_arbitrum.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
0x0b1a513ee24972daef112bc777a5610d4325c9e7	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	1	6	285775309	2024-12-17T17:38:36.000Z	0x7d7198b9af07566444ba8a13e655cf79a4052388de881e48203570f567648739
0x667701e51b4d1ca244f17c78f7ab8744b4c99f9b	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	2	16	285775501	2024-12-17T17:39:24.000Z	0xd021e0db0862c77a252696ac3020d3c76997c55f2c9d634ae5d9bdc2750f2ddb
0x3c0441b42195f4ad6aa9a0978e06096ea616cda7	0x91716c4eda1fb55e84bf8b4c7085f84285c19085	false	3	23	303322750	2025-02-06T18:47:25.000Z	0xc32be8bfc36340889638be34ef6bd94e0662f8f3626c160dc65a9b4e29de4aa3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_arbitrum.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	0x0c8c77b7ff4c2af7f6cebbe67350a490e3dd6cb3	24	11	229349829	2024-07-06T11:50:06.000Z	0xb82beb06d9487893a7bb72aa28eb17cb88b9d9bb2c52b6418215b7b892d1c3db
0x324c5dc1fc42c7a4d43d92df1eba58a54d13bf2d	false	0xdf16adaf80584b2723f3ba1eb7a601338ba18c4e	14	10	229349829	2024-07-06T11:50:06.000Z	0xb82beb06d9487893a7bb72aa28eb17cb88b9d9bb2c52b6418215b7b892d1c3db
0x324c5dc1fc42c7a4d43d92df1eba58a54d13bf2d	false	0xf55b8e9f0c51ace009f4b41d03321675d4c643b3	4	9	229349829	2024-07-06T11:50:06.000Z	0xb82beb06d9487893a7bb72aa28eb17cb88b9d9bb2c52b6418215b7b892d1c3db

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_arbitrum.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
0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	0x0b1a513ee24972daef112bc777a5610d4325c9e7	false	31	270296843417242575	true	292232953	321413060053000000	2025-01-05T12:01:45.000Z	0x925944afb7411646e2a569d2df4968137045b17d253c20acb91835474728c856
0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	0x0b1a513ee24972daef112bc777a5610d4325c9e7	false	6	2635288000000000000	true	292233756	3133649193357000000	2025-01-05T12:05:05.000Z	0xc827d26bd8d69d7456a777df47fec6b22a63362639c1304e33ceebc61e9ba84b
0x11ddd59c33c73c44733b4123a86ea5ce57f6e854	0x0b1a513ee24972daef112bc777a5610d4325c9e7	false	46	4483004145747904758	true	292222637	5330806317330000000	2025-01-05T11:18:43.000Z	0xc6d7eac9988259cae5acc052d4d6454291d82de1efdcd40854301acbea6775b5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_arbitrum.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	0x7dff72693f6a4149b17e7c6314655f6a9f7c8b33	8	0x037dff1c12805707d7c29f163e0f09fc9102657a	2	358573754	fToken	2025-07-17T07:24:14.000Z	0xa67690b20cebcaee92748823a42b3f28d6ecdea885243fba5d5d72549e7c723d
0x54b91a0d94cb471f37f949c60f7fa7935b551d03	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	1	0x45df0656f8adf017590009d2f1898eeca4f0a205	41	228806604	NativeUnderlying	2024-07-04T21:59:43.000Z	0xc5896065ddfc012ea85e2e34cda18970bc4d66ba872be2cae65811832224af68
0x54b91a0d94cb471f37f949c60f7fa7935b551d03	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	3	0x4a03f37e7d3fc243e3f99341d36f4b829bee5e03	51	228806604	fToken	2024-07-04T21:59:43.000Z	0xc5896065ddfc012ea85e2e34cda18970bc4d66ba872be2cae65811832224af68

Example Query

Query with partition filter

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

address	removed	in_token	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x52aa899454998be5b000ad077a46bbe360f4e497	false	0xaf88d065e77c8cc2239327c5edb3a432268e5831	22808659678	10	292631961	2025-01-06T15:50:57.000Z	0x6a21bb4e3d607e24b53a6d4087e14c21167997e4e47eb11c89ff15fc4b18c4b8
0x52aa899454998be5b000ad077a46bbe360f4e497	false	0x5979d7b546e38e414f7e9822514be443a4800529	391539196716671403	14	292631961	2025-01-06T15:50:57.000Z	0x6a21bb4e3d607e24b53a6d4087e14c21167997e4e47eb11c89ff15fc4b18c4b8
0x52aa899454998be5b000ad077a46bbe360f4e497	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	13124507335	12	292631961	2025-01-06T15:50:57.000Z	0x6a21bb4e3d607e24b53a6d4087e14c21167997e4e47eb11c89ff15fc4b18c4b8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_arbitrum.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	0x4045720a33193b4fe66c94dfbc8d37b0b4d9b469	false	0x35751007a407ca6feffe80b3cb397736d2cf4dbe	4	0x0000000000000000000000000000000000000000	240750753	0x0000000000000000000000000000000000000000	2024-08-08T14:49:17.000Z	2207824832737747415	11353549876121343760	0x138a17fe60aa00d582dd4a3e2c12e146fc7ea526b1feeddb9acaf49535499c2b	45671926166590716196341031100955101561600595846610507268096
0x52aa899454998be5b000ad077a46bbe360f4e497	0x4045720a33193b4fe66c94dfbc8d37b0b4d9b469	false	0x35751007a407ca6feffe80b3cb397736d2cf4dbe	21	0x0000000000000000000000000000000000000000	240685463	0x0000000000000000000000000000000000000000	2024-08-08T10:15:08.000Z	19149652610517493	12289902643023767824	0x8a8e81c705e4235dee24b39b673ef98b09df4d1536758a8967f1c890d0c88664	45671926166590716196341031100955101561600595846610507268096
0x52aa899454998be5b000ad077a46bbe360f4e497	0x4045720a33193b4fe66c94dfbc8d37b0b4d9b469	false	0x35751007a407ca6feffe80b3cb397736d2cf4dbe	7	0x0000000000000000000000000000000000000000	240622753	0x0000000000000000000000000000000000000000	2024-08-08T05:53:01.000Z	2686930377246441244	12274202828194897680	0xaf6dbefd63c4abb584ccbee38e5c2b0c4cb81a18a3f58ffee2aafe04d3be47e5	45671926166590716196341031100955101561600595846610507268096

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_arbitrum.FluidLiquidity_LogOperate_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
0x431381ec4269b644345e654afaee873ee38e65c8	0x0c8c77b7ff4c2af7f6cebbe67350a490e3dd6cb3	false	0x431381ec4269b644345e654afaee873ee38e65c8	1393	47	0	63000000000	275676167	2024-11-18T07:03:10.000Z	0xefc35cb5fec5450080f4236390fbf9ff7b519fd99ee6017451d78676b893cdac
0x431381ec4269b644345e654afaee873ee38e65c8	0x0c8c77b7ff4c2af7f6cebbe67350a490e3dd6cb3	false	0x431381ec4269b644345e654afaee873ee38e65c8	1393	6	154676093094351134224349	0	275675068	2024-11-18T06:58:31.000Z	0x551d24bb4b2bd77e0a9131ef4fbc642baf8a087bd5b0f2b11d60b2d4b464315f
0xfbde41d78e95d4defcfbca2e934dfb191a846dd5	0x0c8c77b7ff4c2af7f6cebbe67350a490e3dd6cb3	false	0xfbde41d78e95d4defcfbca2e934dfb191a846dd5	1403	2	0	1200000000	275888202	2024-11-18T21:51:00.000Z	0x2b97ff253b9949535b3fb2bbd6bddfa3ebafd804411611bf5085313b49cddee8

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

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

InstaFlashAggregatorArbitrum_LogFlashloan_event

Flash loan event logs from Instadapp’s Flash Aggregator contract on Arbitrum, recording borrowed token addresses, amounts, borrower accounts, and routing information. Useful for analyzing flash loan usage patterns, popular borrowed assets, 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
0x1f882522df99820df8e586b6df8baae2b91a782d	false	5	[“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”]	26	0x8c681affafc63dd385daa5d56699db200b0caa98	[“143780340522020910”]	57599431	2023-02-03T04:59:34.000Z	0xd45208a51f261919b78ad75e867d792aef1b2f7069330a4f5ab1fc4b7cbb3cde
0x1f882522df99820df8e586b6df8baae2b91a782d	false	5	[“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”]	31	0x8c681affafc63dd385daa5d56699db200b0caa98	[“144629632237889656”]	57595820	2023-02-03T04:36:08.000Z	0xe7c31f960407175b58fa4145d1eea883821239404ee55138b153c3a1a021a442
0x1f882522df99820df8e586b6df8baae2b91a782d	false	5	[“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”]	22	0x8c681affafc63dd385daa5d56699db200b0caa98	[“144074288139102943”]	57590405	2023-02-03T04:02:51.000Z	0x5bbf82af7b06e7518c410413728144a6eef34101ba6a1362e4a2ef18769677cd

Example Query

Query with partition filter

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

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

FluidVaultT1_LogOperate_event

FluidVaultT1_LogRebalance_event

InstaFlashAggregatorArbitrum_LogFlashloan_event

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

​FluidVaultT1_LogOperate_event

​FluidVaultT1_LogRebalance_event

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

FluidVaultT1_LogOperate_event

FluidVaultT1_LogRebalance_event

InstaFlashAggregatorArbitrum_LogFlashloan_event