instadapp_v1_avalanche

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	10	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000009496e737461646170700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001e68747470733a2f2f6176616c616e6368652e696e737461646170702e696f0000	36876157	2023-10-24T21:34:41.000Z	0x08f47ffbb40aae4662eb5f4f284f2d056deb0dc2	0xb0b172cac8ee385ae5b3820cb9b735a8e8f453338a54a4a2f9aa9d888d988b57	0xb3cf3657a7571f010eb6d30d24dd8768122fc48b
0x375f6b0cd12b34dc28e34c26853a37012c24dde5	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	5	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000e07472616e73666572000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000060000000000000000000000000b97ef9ef8734c71904d8002f8b6bc66dd9c48a6e00000000000000000000000000000000000000000000000000000000030048b1000000000000000000000000469f909640212fbb526730ad68616a2608df1977	36876395	2023-10-24T21:42:49.000Z	0x08f47ffbb40aae4662eb5f4f284f2d056deb0dc2	0xa94dbf7e928b77cafecfe8448a0721fb118c974fdc333ae3966535636961173e	0xb3cf3657a7571f010eb6d30d24dd8768122fc48b
0x375f6b0cd12b34dc28e34c26853a37012c24dde5	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	32	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000009496e737461646170700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001e68747470733a2f2f6176616c616e6368652e696e737461646170702e696f0000	36876126	2023-10-24T21:33:39.000Z	0x08f47ffbb40aae4662eb5f4f284f2d056deb0dc2	0xdcd5d33f2a1b169e2c4418c143253ecfb6d5dbb1aaf96f03920f684923b67163	0xb3cf3657a7571f010eb6d30d24dd8768122fc48b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_avalanche.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	19	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000015496e73746164617070202d204176616c616e6368650000000000000000000000000000000000000000000000000000000000000000000000000000000000001e68747470733a2f2f6176616c616e6368652e696e737461646170702e696f0000	49069750	2024-08-10T03:42:31.000Z	0xf8088c8deb8b8f9a571ff423642cfdb85d453856	0x171c44d30b201226f3f64e837493d20c13418840f1b2fea87cbab02c8e2d292a	0x227ed441231564997e01d4cf1d0d15955606e66a
0x46978cd477a496028a18c02f07ab7f35edba5a54	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	19	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000015496e73746164617070202d204176616c616e6368650000000000000000000000000000000000000000000000000000000000000000000000000000000000001e68747470733a2f2f6176616c616e6368652e696e737461646170702e696f0000	49069712	2024-08-10T03:40:47.000Z	0xf8088c8deb8b8f9a571ff423642cfdb85d453856	0x7dda09e9f7b44d77dac6991b2720d026c0fc443348b463eac7d80de42e4a4f70	0x227ed441231564997e01d4cf1d0d15955606e66a
0x46978cd477a496028a18c02f07ab7f35edba5a54	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	48	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000015496e73746164617070202d204176616c616e6368650000000000000000000000000000000000000000000000000000000000000000000000000000000000001e68747470733a2f2f6176616c616e6368652e696e737461646170702e696f0000	49064533	2024-08-10T00:28:54.000Z	0xb4042f3b5a70dbfd3b91cf9a11a3817440193bb8	0xb3f391bc5c6df9d354beff146eec57fc096ade7f91f0059342c279ff7587e40c	0x2b75d91d7d8f4efc7892f4d12d1cd0f3fd864639

Example Query

Query with partition filter

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

FlashAggregatorAvalanche_LogFlashloan_event

Flash loan execution records from Instadapp’s FlashAggregator contract on Avalanche. Tracks borrowed token amounts, routing identifiers, and borrower accounts for analyzing arbitrage activity and flash loan usage 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_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
0x2b65731a085b55dbe6c7dcc8d717ac36c00f6d19	false	9	[“0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab”]	40	0x2159d9853f82bb169aa31bf12494dc1732792565	[“1000000000000000000”]	18350963	2022-08-07T23:05:14.000Z	0xcb95e99fe085f86de32f7fd5b25760423011aba1131ece93fca09e19bcfb5756
0x2b65731a085b55dbe6c7dcc8d717ac36c00f6d19	false	9	[“0x49d5c2bdffac6ce2bfdb6640f4f80f226bc10bab”]	80	0x2159d9853f82bb169aa31bf12494dc1732792565	[“995216137857165762”]	18351403	2022-08-07T23:19:55.000Z	0x0f317ffa7191cc035d4ad4d77291854c8ecd6e05efbefd5db087503e2975dbb1
0x2b65731a085b55dbe6c7dcc8d717ac36c00f6d19	false	9	[“0x50b7545627a5162f82a992c33b87adc75187b218”]	88	0xec16d751b1e76043ab9fb20bd8a28d7f6b5846df	[“4692200”]	18310466	2022-08-07T00:21:53.000Z	0x799c0a4facc4d0d76bb7ff381eafaa7dac3fe7555c21a41093c3e4b94661f9a8

Example Query

Query with partition filter

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

FlashAggregatorAvalanche_LogFlashloan_event

​Tables

​AvoForwarder_Executed_event

​AvoForwarderMultisig_Executed_event

​FlashAggregatorAvalanche_LogFlashloan_event

Tables

AvoForwarder_Executed_event

AvoForwarderMultisig_Executed_event

FlashAggregatorAvalanche_LogFlashloan_event