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.

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

Example Query

Query with partition filter

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.

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_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

Example Query

Query with partition filter

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.

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

Example Query

Query with partition filter

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

InstaFlashAggregatorOptimism_LogFlashloan_event

​Tables

​AvoForwarder_Executed_event

​AvoForwarderMultisig_Executed_event

​InstaFlashAggregatorOptimism_LogFlashloan_event

Tables

AvoForwarder_Executed_event

AvoForwarderMultisig_Executed_event

InstaFlashAggregatorOptimism_LogFlashloan_event