> ## 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_optimism
> Tables in tt-contracts.instadapp_v1_optimism
## 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 | 0x0000000000000000000000000000000000000001 | 2 | 0x | 76093835 | 2023-02-22T23:12:25.000Z | 0x910e413dbf3f6276fe8213ff656726bdc142e08e | 0x696420c0d1175148d24734b762d7ca830a10d2b19fd843fd24bc134f92bbedf9 | 0x132c3107f3cfd0cf33485bda398c993b1cd4723d |
| 0x375f6b0cd12b34dc28e34c26853a37012c24dde5 | false | 0x0000000000000000000000000000000000000001 | 2 | 0x | 76094099 | 2023-02-22T23:14:42.000Z | 0x7284a8451d9a0e7dc62b3a71c0593ea2ec5c5638 | 0x9d46d242c4be5140d3907d1ad00deabe42370ab6f766cdf8e5101295d1b1e8ac | 0xd535f68266b56b3cfbfec869f7d56420cd8f2046 |
| 0x375f6b0cd12b34dc28e34c26853a37012c24dde5 | false | 0x000000000000000000000000000000000000cad0 | 23 | 0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014073776170000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000007f5c764cbc14f9669b88837ca1490cca17c31607000000000000000000000000420000000000000000000000000000000000004200000000000000000000000000000000000000000000000000000000001e84800000000000000000000000000000000000000000000000000a2c5373c586b5600000000000000000000000007284a8451d9a0e7dc62b3a71c0593ea2ec5c563831696e63682d7635000000000000000000000000000000000000000000000000 | 76094573 | 2023-02-22T23:18:02.000Z | 0x7284a8451d9a0e7dc62b3a71c0593ea2ec5c5638 | 0xfaec9c128b0e7d3d0e8561e6bf63e21f6ff0edad9369f1b5e82f75385d4ccf1a | 0xd535f68266b56b3cfbfec869f7d56420cd8f2046 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.instadapp_v1_optimism.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 | 3 | 0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e | 28 | 0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000e07472616e73666572000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000060000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000000000000000000000000000001cf890c44910000000000000000000000000000c50dacc2b1bc6a2962215403d4cb3d2dff8be4f | 124431675 | 2024-08-24T01:15:27.000Z | 0x0ea26051f7657d59418da186137141cea90d0652 | 0xdf58fab17823108bc5df1e827dfc5552aa825e20246b2f617bed59655d44a814 | 0x103fc8da44a4ac8981bf4d358d58c6c9702c8470 |
| 0x46978cd477a496028a18c02f07ab7f35edba5a54 | false | 3 | 0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e | 20 | 0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000e07472616e7366657200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000006000000000000000000000000094b008aa00579c1307b0ef2c499ad98a8ce58e58000000000000000000000000000000000000000000000000000000000140106f0000000000000000000000000c50dacc2b1bc6a2962215403d4cb3d2dff8be4f | 124433420 | 2024-08-24T02:13:37.000Z | 0x0ea26051f7657d59418da186137141cea90d0652 | 0x41f05220508b4c366e01e8ff68014e5f9cbe6df0536395b2284e4eefc41739cb | 0x103fc8da44a4ac8981bf4d358d58c6c9702c8470 |
| 0x46978cd477a496028a18c02f07ab7f35edba5a54 | false | 3 | 0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e | 111 | 0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000001806272696467652d76320000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000874ef557a00f0000000000000000000000000000103fc8da44a4ac8981bf4d358d58c6c9702c8470000000000000000000000000da10009cbd5d07dd0cecc66161fc93d7c9000da10000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a06300000000000000000000000000000000000000000000000000000000000000890000000000000000000000000000000000000000000000000000000000000000000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee736f636b65740000000000000000000000000000000000000000000000000000 | 124433694 | 2024-08-24T02:22:45.000Z | 0x0ea26051f7657d59418da186137141cea90d0652 | 0x7487ae5d6ada4755d0ab9b7096413ecffe931438713babc69d19919d73cda784 | 0x103fc8da44a4ac8981bf4d358d58c6c9702c8470 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.instadapp_v1_optimism.AvoForwarderMultisig_Executed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***
### InstaFlashAggregatorOptimism\_LogFlashloan\_event
Flash loan execution events from Instadapp's aggregator contract on Optimism, recording borrowed token amounts, borrower accounts, and routing protocols. Used for analyzing flash loan usage patterns, borrowed asset volumes, and liquidity source selection across different DeFi protocols.
| 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 |
| ------------------------------------------ | ------- | --------- | ----------------------------------------------- | ---------- | ------------------------------------------ | ----------------------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
| 0x84e6b05a089d5677a702cf61dc14335b4be5b282 | false | 9 | \["0xda10009cbd5d07dd0cecc66161fc93d7c9000da1"] | 65 | 0xadcf7106dde05214d90d9094013ab5ceb3a0b1a1 | \["15000000000000000000000"] | 112391753 | 2023-11-19T08:24:43.000Z | 0xd78ae25a115316899c8b02c173a0d36cf4dee1eecdc3640a79279cd7d4d55ece |
| 0x84e6b05a089d5677a702cf61dc14335b4be5b282 | false | 8 | \["0xda10009cbd5d07dd0cecc66161fc93d7c9000da1"] | 25 | 0x2b9bbb1d1fee42a576c57263d39db75a82295e36 | \["311110760400000000001743"] | 21842193 | 2022-09-03T20:07:41.000Z | 0x7db7c99da2f5acdd3bb0f7a058444d855f7bba8f54c6e474efdde35f7e8f7dd9 |
| 0x84e6b05a089d5677a702cf61dc14335b4be5b282 | false | 8 | \["0x4200000000000000000000000000000000000006"] | 46 | 0x34c6f027226120ac5334a00c4ed16169c3ca28f9 | \["63500000000000000"] | 21752196 | 2022-09-03T01:38:50.000Z | 0xbf30fcde7c848ae9e611932b08d280d2724429dece3d8959aa443149051d3136 |
**Query with partition filter**
```sql theme={null}
SELECT *
FROM `tt-contracts.instadapp_v1_optimism.InstaFlashAggregatorOptimism_LogFlashloan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
```
***