> ## Documentation Index > Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # instadapp_v1_avalanche > Tables in tt-contracts.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. | 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. | | 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 | **Query with partition filter** ```sql theme={null} 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. | 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. | | address | removed | in\_index | in\_source | log\_index | in\_metadata | block\_number | block\_timestamp | in\_avocadoOwner | transaction\_hash | in\_avocadoAddress | | ------------------------------------------ | ------- | --------- | ------------------------------------------ | ---------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------ | | 0x46978cd477a496028a18c02f07ab7f35edba5a54 | false | 0 | 0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e | 19 | 0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000015496e73746164617070202d204176616c616e6368650000000000000000000000000000000000000000000000000000000000000000000000000000000000001e68747470733a2f2f6176616c616e6368652e696e737461646170702e696f0000 | 49069750 | 2024-08-10T03:42:31.000Z | 0xf8088c8deb8b8f9a571ff423642cfdb85d453856 | 0x171c44d30b201226f3f64e837493d20c13418840f1b2fea87cbab02c8e2d292a | 0x227ed441231564997e01d4cf1d0d15955606e66a | | 0x46978cd477a496028a18c02f07ab7f35edba5a54 | false | 0 | 0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e | 19 | 0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000015496e73746164617070202d204176616c616e6368650000000000000000000000000000000000000000000000000000000000000000000000000000000000001e68747470733a2f2f6176616c616e6368652e696e737461646170702e696f0000 | 49069712 | 2024-08-10T03:40:47.000Z | 0xf8088c8deb8b8f9a571ff423642cfdb85d453856 | 0x7dda09e9f7b44d77dac6991b2720d026c0fc443348b463eac7d80de42e4a4f70 | 0x227ed441231564997e01d4cf1d0d15955606e66a | | 0x46978cd477a496028a18c02f07ab7f35edba5a54 | false | 0 | 0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e | 48 | 0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014064617070000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000015496e73746164617070202d204176616c616e6368650000000000000000000000000000000000000000000000000000000000000000000000000000000000001e68747470733a2f2f6176616c616e6368652e696e737461646170702e696f0000 | 49064533 | 2024-08-10T00:28:54.000Z | 0xb4042f3b5a70dbfd3b91cf9a11a3817440193bb8 | 0xb3f391bc5c6df9d354beff146eec57fc096ade7f91f0059342c279ff7587e40c | 0x2b75d91d7d8f4efc7892f4d12d1cd0f3fd864639 | **Query with partition filter** ```sql theme={null} 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. | 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` | Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings. | | `in_amounts` | `ARRAY` | Array of token amounts involved in the operation. String-encoded integers representing amounts in the token's smallest unit (e.g., wei for ETH). | | 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 | **Query with partition filter** ```sql theme={null} SELECT * FROM `tt-contracts.instadapp_v1_avalanche.FlashAggregatorAvalanche_LogFlashloan_event` WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY) LIMIT 100 ``` ***