1inch_v3_ethereum

Tables

AggregationRouterV3_discountedSwap_function

Swap transactions executed through 1inch v3 Aggregation Router with CHI gas token discounts on Ethereum. Captures token exchange details including source/destination tokens, amounts, slippage parameters, and CHI tokens spent for gas optimization.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_desc`	`STRUCT<srcToken STRING, dstToken STRING, srcReceiver STRING, dstReceiver STRING, amount STRING, minReturnAmount STRING, flags STRING, permit STRING>`	Swap operation parameters struct containing source and destination token addresses, receiver addresses, token amounts, minimum return amount, execution flags, and permit signature data.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.
`out_gasLeft`	`STRING`	Amount of gas remaining after the function execution. Numeric string representation of unspent gas units from the allocated gas limit.
`out_chiSpent`	`STRING`	Amount of CHI token consumed for gas optimization. Numeric string representation of CHI tokens burned during transaction execution.

Sample Data

gas	status	in_data	in_desc	gas_used	in_caller	signature	to_address	out_gasLeft	block_number	from_address	out_chiSpent	block_timestamp	out_returnAmount	transaction_hash
553166	true	0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000320000000000000000000000000000000000000000000000000000000000000048000000000000000000000000000000000000000000000000000000000000006e000000000000000000000000000000000000000000000000000000000000008400000000000000000000000000000000000000000000000000000000000000b40000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a4b3af37c000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000000000e6000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a00000000000000000000000070ec2fa6eccf4010eaf572d1c1a7bcbc72dec98300000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a4b757fed600000000000000000000000070ec2fa6eccf4010eaf572d1c1a7bcbc72dec983000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000002dc6c0fd3dfb524b2da40c8a6d703c62be36b5d8540626000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a4b3af37c000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a0000000000000000000000000000010e0000000000000000000000000000010e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000f13eef1c6485348b9c9fa0d5df2d89accc5b014700000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a4b757fed6000000000000000000000000f13eef1c6485348b9c9fa0d5df2d89accc5b0147000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000002dc6c0fd3dfb524b2da40c8a6d703c62be36b5d854062600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000244b3af37c000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000320000000000000000000000000000003280000000000000000000000088e6a0c2ddd26feeb64f039a2c41296fcb3f56400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000104128acb080000000000000000000000000d1495c20f96009528bac93722e1518e3575991e00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000fffd8963efd1fc6a506488495d951d5263988d2500000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000002647f8fe7a000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000fd3dfb524b2da40c8a6d703c62be36b5d854062600000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a405971224000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000010000000000000000000000000000000100000000000000000000000000000000000000000000000000000000007a105c00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004470bdb947000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48000000000000000000000000000000000000000000000000000000011cd3e17b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	{“flags”:“12”,“amount”:“35031575050000000000”,“permit”:“0x”,“dstToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“srcToken”:“0xfa5047c9c78b8877af97bdcb85db743fd7313d4a”,“dstReceiver”:“0x0d1495c20f96009528bac93722e1518e3575991e”,“srcReceiver”:“0xfd3dfb524b2da40c8a6d703c62be36b5d8540626”,“minReturnAmount”:“4773836547”}	233321	0xfd3dfb524b2da40c8a6d703c62be36b5d8540626	0x6c4a483e	0x11111112542d85b3ef69ae05771c2dccff4faa26	86681	12746636	0x0d1495c20f96009528bac93722e1518e3575991e	9	2021-07-02T06:39:30.000Z	4778206808	0x0e749123a12bd30ac6461044f9d756ddb39242b13e6ccd776f4214d31bf0cdac
607609	true	0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000066000000000000000000000000000000000000000000000000000000000000007c00000000000000000000000000000000000000000000000000000000000000a200000000000000000000000000000000000000000000000000000000000000b800000000000000000000000000000000000000000000000000000000000000da000000000000000000000000000000000000000000000000000000000000010c000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000244b3af37c000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a0000000000000000000000000000005a000000000000000000000000000001f40000000000000000000000000ede8afc34e7f092f27eef121acb4de4f2e010cb0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000104128acb08000000000000000000000000fd3dfb524b2da40c8a6d703c62be36b5d854062600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000fffd8963efd1fc6a506488495d951d5263988d2500000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a4b3af37c000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000000000c80000000000000000000000000000019a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000f13eef1c6485348b9c9fa0d5df2d89accc5b014700000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a4b757fed6000000000000000000000000f13eef1c6485348b9c9fa0d5df2d89accc5b0147000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000002dc6c0fd3dfb524b2da40c8a6d703c62be36b5d8540626000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a4b3af37c000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000000000d2000000000000000000000000000000d200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a00000000000000000000000070ec2fa6eccf4010eaf572d1c1a7bcbc72dec98300000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a4b757fed600000000000000000000000070ec2fa6eccf4010eaf572d1c1a7bcbc72dec983000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000002dc6c0fd3dfb524b2da40c8a6d703c62be36b5d854062600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000164b3af37c000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000004000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000000000003200000000000000000000000000000032000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000242e1a7d4d00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000002647f8fe7a000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000fd3dfb524b2da40c8a6d703c62be36b5d854062600000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a405971224000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000100000000000000000000000000000001000000000000000000000000000000000000000000000000000e07c5ae95e2a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004470bdb947000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000000000000000000000000000044d8cd18ec8c74880000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a4b3af37c000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000000000010000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000d1495c20f96009528bac93722e1518e3575991e00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	{“flags”:“12”,“amount”:“73265858850000000000”,“permit”:“0x”,“dstToken”:“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”,“srcToken”:“0xfa5047c9c78b8877af97bdcb85db743fd7313d4a”,“dstReceiver”:“0x0d1495c20f96009528bac93722e1518e3575991e”,“srcReceiver”:“0xfd3dfb524b2da40c8a6d703c62be36b5d8540626”,“minReturnAmount”:“4955979555983658237”}	258681	0xfd3dfb524b2da40c8a6d703c62be36b5d8540626	0x6c4a483e	0x11111112542d85b3ef69ae05771c2dccff4faa26	90404	12746560	0x0d1495c20f96009528bac93722e1518e3575991e	10	2021-07-02T06:21:29.000Z	4960940496480138376	0x2fbc19f65ba277d76d45be0a2e1651bebdd504cad0d276d303a14da5342a9050
673391	true	0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000066000000000000000000000000000000000000000000000000000000000000007c00000000000000000000000000000000000000000000000000000000000000a200000000000000000000000000000000000000000000000000000000000000b800000000000000000000000000000000000000000000000000000000000000e8000000000000000000000000000000000000000000000000000000000000011a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000244b3af37c000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a00000000000000000000000000000082000000000000000000000000000001f40000000000000000000000000ede8afc34e7f092f27eef121acb4de4f2e010cb0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000104128acb08000000000000000000000000fd3dfb524b2da40c8a6d703c62be36b5d854062600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000fffd8963efd1fc6a506488495d951d5263988d2500000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a4b3af37c000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000000000b40000000000000000000000000000017200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000f13eef1c6485348b9c9fa0d5df2d89accc5b014700000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a4b757fed6000000000000000000000000f13eef1c6485348b9c9fa0d5df2d89accc5b0147000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000002dc6c0fd3dfb524b2da40c8a6d703c62be36b5d8540626000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a4b3af37c000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000000000be000000000000000000000000000000be00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a00000000000000000000000070ec2fa6eccf4010eaf572d1c1a7bcbc72dec98300000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a4b757fed600000000000000000000000070ec2fa6eccf4010eaf572d1c1a7bcbc72dec983000000000000000000000000fa5047c9c78b8877af97bdcb85db743fd7313d4a000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000002dc6c0fd3dfb524b2da40c8a6d703c62be36b5d854062600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000244b3af37c000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000320000000000000000000000000000003280000000000000000000000088e6a0c2ddd26feeb64f039a2c41296fcb3f56400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000104128acb08000000000000000000000000fd3dfb524b2da40c8a6d703c62be36b5d854062600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000fffd8963efd1fc6a506488495d951d5263988d2500000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000002647f8fe7a000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000fd3dfb524b2da40c8a6d703c62be36b5d854062600000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a405971224000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb4800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000010000000000000000000000000000000100000000000000000000000000000000000000000000000000000000007a195f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004470bdb947000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48000000000000000000000000000000000000000000000000000000012c134000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000184b3af37c000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000024000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480000000000000000000000000000000100000000000000000000000000000001000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000044a9059cbb0000000000000000000000000d1495c20f96009528bac93722e1518e3575991e00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	{“flags”:“12”,“amount”:“38024174050000000000”,“permit”:“0x”,“dstToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“srcToken”:“0xfa5047c9c78b8877af97bdcb85db743fd7313d4a”,“dstReceiver”:“0x0d1495c20f96009528bac93722e1518e3575991e”,“srcReceiver”:“0xfd3dfb524b2da40c8a6d703c62be36b5d8540626”,“minReturnAmount”:“5029391941”}	287887	0xfd3dfb524b2da40c8a6d703c62be36b5d8540626	0x6c4a483e	0x11111112542d85b3ef69ae05771c2dccff4faa26	97774	12747734	0x0d1495c20f96009528bac93722e1518e3575991e	11	2021-07-02T10:48:50.000Z	5033877345	0xc5690cc0d135b16f49b40e0054eda3b865f5444d18bdd39bc9079164628c5b31

Example Query

Query with partition filter

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

AggregationRouterV3_swap_function

Failed swap transaction attempts from 1inch V3 AggregationRouter on Ethereum. All sample rows show reverted swaps (status: false) with null return amounts, useful for analyzing failed trade patterns and gas consumption on unsuccessful routing attempts.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_desc`	`STRUCT<srcToken STRING, dstToken STRING, srcReceiver STRING, dstReceiver STRING, amount STRING, minReturnAmount STRING, flags STRING, permit STRING>`	Swap operation parameters struct containing source and destination token addresses, receiver addresses, token amounts, minimum return amount, execution flags, and permit signature data.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.
`out_gasLeft`	`STRING`	Amount of gas remaining after the function execution. Numeric string representation of unspent gas units from the allocated gas limit.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
529437	0	false	247073	0x7c025200	0x11111112542d85b3ef69ae05771c2dccff4faa26	14915355	0xaf06f206ec32783bf4ef1123e12ab0dcddfed199	2022-06-06T14:04:14.000Z	0x57be8143f51f0d845d4b1e0b7fba0d5f0f01ca1405b8b28e854fd749a3e2ff60
300148	0	false	186368	0x7c025200	0x11111112542d85b3ef69ae05771c2dccff4faa26	14912305	0xab1939cf4c78ea9d154bbdd0c33cc4091a8ca359	2022-06-06T01:37:58.000Z	0x2fcf7f3a51c990643754a2ac038996522dbd366b104e4569f202955d39d6cd21
392743	17100000000000000000	false	227117	0x7c025200	0x11111112542d85b3ef69ae05771c2dccff4faa26	14915653	0x47603c304bb54dfeffc1eed175e80481e64ae722	2022-06-06T15:21:07.000Z	0x635dc61df54ccf1a05e35ea0d4adf3426f65c0aace045682aca026fb88da743c

Example Query

Query with partition filter

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

AggregationRouterV3_Swapped_event

Completed swap events from 1inch AggregationRouterV3 on Ethereum, capturing source and destination tokens, spent and received amounts, sender and receiver addresses. Used for analyzing DEX aggregator trading volume, token pair flows, and user swap behavior.

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_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_dstToken`	`STRING`	Contract address of the destination token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_dstReceiver`	`STRING`	Address that receives the destination tokens from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_spentAmount`	`STRING`	Actual amount of source tokens spent in the swap. Numeric string representation of token quantity in smallest denomination.
`in_returnAmount`	`STRING`	Actual amount of destination tokens received from the swap. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_dstToken	in_srcToken	block_number	in_dstReceiver	in_spentAmount	block_timestamp	in_returnAmount	transaction_hash
0x11111112542d85b3ef69ae05771c2dccff4faa26	false	0x4c09818ce9da8ea89c392a2d3dad0273613d7f61	29	0x57ab1ec28d129707052df4df418d58a2d46d5f51	0x0000000000085d4780b73119b644ae5ecd22b376	14167903	0x4c09818ce9da8ea89c392a2d3dad0273613d7f61	3091053562307488996452	2022-02-08T21:43:35.000Z	3083200220331867679302	0x3e7e78216d98987e56a5602a92f5bd7211b3958187995c782885eb7a273774ff
0x11111112542d85b3ef69ae05771c2dccff4faa26	false	0x7a42c31aef3e716bf2cf9713a9552020d05ee731	239	0xe53ec727dbdeb9e2d5456c3be40cff031ab40a55	0x0000000000085d4780b73119b644ae5ecd22b376	14162688	0x7a42c31aef3e716bf2cf9713a9552020d05ee731	31358421302159789440644	2022-02-08T02:10:08.000Z	30201734566847825134400	0x2b49e433df71b8060d15cdaf2b36fc4084ec6677be42a5918a54e76e6fcc3a19
0x11111112542d85b3ef69ae05771c2dccff4faa26	false	0x7a42c31aef3e716bf2cf9713a9552020d05ee731	684	0xe53ec727dbdeb9e2d5456c3be40cff031ab40a55	0x0000000000085d4780b73119b644ae5ecd22b376	14162733	0x7a42c31aef3e716bf2cf9713a9552020d05ee731	12298147351380157919517	2022-02-08T02:18:35.000Z	11525517597003480760809	0x16e6aaba42b7d36424855ef0437d282342247197603714709b5ce780fcf8416d

Example Query

Query with partition filter

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

AggregationRouterV3_unoswap_function

Unoswap function calls from 1inch Aggregation Router V3 on Ethereum, capturing single-pool swap attempts with source token, amounts, and minimum return parameters. Notable that sample rows show failed transactions (status: false) with null input parameters, useful for analyzing failed swap attempts and gas consumption 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_minReturn`	`STRING`	Minimum acceptable output amount for the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_anon3`	`ARRAY<STRING>`	Sequential counter tracking the total number of pairs created by the factory contract.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	status	gas_used	in_anon3	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
132459	false	28629	[]	0x2e95b6c8	0x11111112542d85b3ef69ae05771c2dccff4faa26	13121176	0x6a936d26e64eae237d22defc0fcdab95a326b20f	2021-08-29T15:28:02.000Z	0x80d42e81c9838aa9f5096838927a68c33f9116194c6ce6a54cfa06df48a8adae
147759	false	29211	[]	0x2e95b6c8	0x11111112542d85b3ef69ae05771c2dccff4faa26	13123264	0x0b284bb2700f5d545fe6792c803885c46b866568	2021-08-29T23:05:40.000Z	0x49d5d701b141612feb174576f80f5c89a58bc9d744d7ce06d5c5e5dc69829c2f
107699	false	29282	[]	0x2e95b6c8	0x11111112542d85b3ef69ae05771c2dccff4faa26	13122866	0x2767beb4eff722333675e0c1a837051597745ef9	2021-08-29T21:43:51.000Z	0xd1492eb3503efd57061b57fe646b62a85047eae7a2103c0a6b3c96ed8cc8a850

Example Query

Query with partition filter

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

AggregationRouterV3_unoswapWithPermit_function

1inch AggregationRouterV3 unoswapWithPermit function calls on Ethereum, enabling gasless token swaps through EIP-2612 permit signatures. Captures swap parameters including input/output amounts, liquidity pool routes, and permit data for analyzing single-path DEX (decentralized exchange) trades with off-chain approvals.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_minReturn`	`STRING`	Minimum acceptable output amount for the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_pools`	`ARRAY<STRING>`	Array of encoded pool identifiers for routing token swaps through decentralized exchanges. Elements are numeric strings representing packed pool addresses and swap parameters.
`in_permit`	`STRING`	EIP-2612 permit signature data enabling gasless token approvals for the swap operation. Hex-encoded byte string containing owner address, spender address, value, deadline, and ECDSA signature components (v, r, s).
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	status	gas_used	in_pools	in_amount	in_permit	signature	to_address	in_srcToken	block_number	from_address	in_minReturn	block_timestamp	out_returnAmount	transaction_hash
238219	true	198792	[“0x00000000000000003b6d034026aad2da94c59524ac0d93f6d6cbf9071d7086f2”,“0x80000000000000003b6d034055d5c232d921b9eaa6b37b5845e439acd04b4dba”]	184266200000000000000	0x0000000000000000000000000e10dd174e8906d13ec2e96afd6667503842f19700000000000000000000000011111112542d85b3ef69ae05771c2dccff4faa26ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000061038a1d000000000000000000000000000000000000000000000000000000000000001b1d2962c37a09b5975f598a202be06bbec8081d2bbd2ddaffcb5e57fc0c19034d66f564e42e585573a3a8ef8afaa45603b7fdee82dcc2050c7476e86d721bb587	0xa1251d75	0x11111112542d85b3ef69ae05771c2dccff4faa26	0x111111111117dc0aa78b770fa6a738034120c302	12924831	0x0e10dd174e8906d13ec2e96afd6667503842f197	330994623515	2021-07-30T04:15:59.000Z	334338003551	0x4f31191bbbe4569b2217a2cb36d09fb2aa4d186da31c011088bd9ca7e8d375c2
194702	true	161596	[“0x40000000000000003b6d034086f518368e0d49d5916e2bd9eb162e9952b7b04d”]	19549500000000000000	0x0000000000000000000000006b3de9b20455f4cc16d3f82798c0f3d1f5382ff700000000000000000000000011111112542d85b3ef69ae05771c2dccff4faa26ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000061039810000000000000000000000000000000000000000000000000000000000000001bcc510b36798e2e518b957fea07bd2f176c36b31ae3f754991bbf8821cae106342ed591846583dd5cd014347ef7b419b2ed5fe22cac6aec80f68284bfe952c16c	0xa1251d75	0x11111112542d85b3ef69ae05771c2dccff4faa26	0x111111111117dc0aa78b770fa6a738034120c302	12925076	0x6b3de9b20455f4cc16d3f82798c0f3d1f5382ff7	18105514235719916	2021-07-30T05:11:39.000Z	18288398217898906	0x88fed5b328e4fd1d1e49c9dabecd1d7d7feaa2741cc46fce56a21ba136ce030d
194258	true	146210	[“0x40000000000000003b6d034026aad2da94c59524ac0d93f6d6cbf9071d7086f2”]	714350000000000000000	0x000000000000000000000000adeb99da5761f20996609ca52e9ca7c4cb4b911500000000000000000000000011111112542d85b3ef69ae05771c2dccff4faa26ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000061040732000000000000000000000000000000000000000000000000000000000000001bff6b311d97c487685634b1385b83ef84887209c5a7f3463391f41ff2b9f7af4c7e8e692b5e0eb44701ac7f221385c2d7f8b35039894772169005ade839bf70a5	0xa1251d75	0x11111112542d85b3ef69ae05771c2dccff4faa26	0x111111111117dc0aa78b770fa6a738034120c302	12927144	0xadeb99da5761f20996609ca52e9ca7c4cb4b9115	660643941939395057	2021-07-30T13:06:38.000Z	667317113070096018	0x58bf88e8cde78f110b08c87580d7a539bc227009a5a0a042ee267eb3c67825f1

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AggregationRouterV3_discountedSwap_function

AggregationRouterV3_swap_function

AggregationRouterV3_Swapped_event

AggregationRouterV3_unoswap_function

AggregationRouterV3_unoswapWithPermit_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​AggregationRouterV3_discountedSwap_function

​AggregationRouterV3_swap_function

​AggregationRouterV3_Swapped_event

​AggregationRouterV3_unoswap_function

​AggregationRouterV3_unoswapWithPermit_function

Tables

AggregationRouterV3_discountedSwap_function

AggregationRouterV3_swap_function

AggregationRouterV3_Swapped_event

AggregationRouterV3_unoswap_function

AggregationRouterV3_unoswapWithPermit_function