instadapp_v1_gnosis

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	3	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000806465706c6f790000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000000	30365588	2023-10-09T01:53:00.000Z	0xa37a6ab480373a42c1c7db3adbf932a4f4906dbf	0x28d4fcc6f5f7f2cc8afceb86ad3514f2bfc363d532ed6d905665ead0030d09c2	0x63ff6ef657083dfc0d905b7624a7d434faf469dc
0x375f6b0cd12b34dc28e34c26853a37012c24dde5	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	10	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014073776170000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000ddafbb505ad214d7b80b1f830fccc89b60fb7a83000000000000000000000000000000000000000000000002b5e41c3a5ee780000000000000000000000000000000000000000000000000000000000002fadcfd0000000000000000000000002588253cc1daac3e7d823b9190ec87e75c67f2c431696e63682d7635000000000000000000000000000000000000000000000000	29146793	2023-07-26T16:40:30.000Z	0x2588253cc1daac3e7d823b9190ec87e75c67f2c4	0x3cd6382adb96af1aeb367eb3d8a2e2f6e3445540eef2468030c60d21b2f6218f	0xdc6aef90f498879034721bdd6dbbc1b328f25984
0x375f6b0cd12b34dc28e34c26853a37012c24dde5	false	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	26	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000014073776170000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000ddafbb505ad214d7b80b1f830fccc89b60fb7a83000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000000000000002faf080000000000000000000000000000000000000000000000002b5e41cb15f09322d0000000000000000000000002588253cc1daac3e7d823b9190ec87e75c67f2c431696e63682d7635000000000000000000000000000000000000000000000000	29146571	2023-07-26T16:21:25.000Z	0x2588253cc1daac3e7d823b9190ec87e75c67f2c4	0x2324e1de7b5a22c76f1c124fad488f687d7b95670808b74c6f38f4daad07180d	0xdc6aef90f498879034721bdd6dbbc1b328f25984

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.instadapp_v1_gnosis.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	17	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000001606164642d7369676e6572730000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000050000000000000000000000000d3dd943e752d66363ace488501f0a76e9b89bbc0000000000000000000000005ab0fdc6f0ca9ea178c95ceccf944a4ce1aedddd0000000000000000000000005f2b5f9f0cd8ecd8118ee1ccb0e3d8b4e11b9a86000000000000000000000000a68450b019ab4fb94397365784dabf75ab2a7002000000000000000000000000fce8baabf07d2220541e9c8dd771ac7fe1fdc68a00000000000000000000000000000000000000000000000000000000000000a06368616e67652d7468726573686f6c64000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000002	36649021	2024-10-23T09:17:25.000Z	0x64ac396c1ec8d0a16428346467f2b07f6434a690	0x1fe6d170001284f6db67a626215435e1df9874af541bf12b628faff09f7478ad	0x3bc4bc1aba27b4f3d05e50a5c015556e333f0075
0x46978cd477a496028a18c02f07ab7f35edba5a54	false	0	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	498	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000c07570677261646500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000040312e302e31000000000000000000000000000000000000000000000000000000000000000000000000000000f9baba169f15a0be151aba8801d456afa9ba1249	32270757	2024-02-03T16:14:40.000Z	0xc20a57e29f5333871d985da6b0b230ac8816d9b5	0x94b97b89d60106bd8a38b4b9b149ba646a494c4677a7ec6559f0917467ac9ff1	0xe0fed2ef337a0f910fc5f6949c294e04f7a7e18e
0x46978cd477a496028a18c02f07ab7f35edba5a54	false	0	0xe8385fb3a5f15ded06eb5e20e5a81bf43115eb8e	3016	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000e07472616e73666572000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000060000000000000000000000000fadc59d012ba3c110b08a15b7755a5cb7cbe77d7000000000000000000000000000000000000000000000174f88f6ba0791f8000000000000000000000000000d3d9eae9e730b686aa29f06963680f2ad7cd7741	32269525	2024-02-03T14:26:40.000Z	0xd3d9eae9e730b686aa29f06963680f2ad7cd7741	0xc80d5e1927eb64669fd2805bde93980c519e45da088c05edf67a44d17427489d	0xc126608611a424a1a8967e4bda6e52a5664cd9ad

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AvoForwarder_Executed_event

AvoForwarderMultisig_Executed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AvoForwarder_Executed_event

​AvoForwarderMultisig_Executed_event

Tables

AvoForwarder_Executed_event

AvoForwarderMultisig_Executed_event