1inch_v4_polygon

Tables

AggregationRouterV4_discountedSwap_function

Discounted swap executions from 1inch Aggregation Router V4 on Polygon using CHI gas tokens for reduced transaction costs. Contains swap parameters, token amounts, routing data, and CHI spent for analyzing gas-optimized trading strategies.

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`	`NUMERIC`	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
670687	true	0x00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000007200000000000000000000000000000000000000000000000000000000000000a0080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a4b757fed6000000000000000000000000d32f3139a214034a0f9777c87ee0a064c1ff6ae20000000000000000000000000d500b1d8e8ef31e21c99d1db9a6444d3adf12700000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a0630000000000000000001e84802ec255797fef7669fa243509b7a599121148ffba00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000004c4ad0e7b1a000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000004600000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a06300000000000000000000000000000003000000000000000000000000000000030000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001408000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000064eb5625d90000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a063000000000000000000000000ba12222222228d8ba445958a75a0704d566bf2c8000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000800000000000000000000000ba12222222228d8ba445958a75a0704d566bf2c80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001e452bbbe2900000000000000000000000000000000000000000000000000000000000000e00000000000000000000000002ec255797fef7669fa243509b7a599121148ffba00000000000000000000000000000000000000000000000000000000000000000000000000000000000000002ec255797fef7669fa243509b7a599121148ffba000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000061c9105e0d34e5dd4d8f043557145598e4e2dc286b35fd4f00000000000000000000006800000000000000000000000000000000000000000000000000000000000000000000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a063000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000028000000000000000000000000000000000000000000000000000000000000044800000000000000000000000000000000000000000000000000000000000016400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000024432ce0a7c000000000000000000000000000000000000000000000000000000000000008080000000000000000000000000000000000000000000000000000000000000440000000000000000000000002ec255797fef7669fa243509b7a599121148ffba00000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a405971224000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000100000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004470bdb947000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f00000000000000000000000000000000000000000000000000000000d4087d860000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000018414284aab00000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f00000000000000000000000000000001000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	{“flags”:“12”,“amount”:“1324714855118188838912”,“permit”:“0x”,“dstToken”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“srcToken”:“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“dstReceiver”:“0x15177a71af4dde1e190c6a183a8afcf39ae2224a”,“srcReceiver”:“0xd32f3139a214034a0f9777c87ee0a064c1ff6ae2”,“minReturnAmount”:“3554854549”}	251942	0x2ec255797fef7669fa243509b7a599121148ffba	0x6c4a483e	0x1111111254fb6c44bac0bed2854e76f90643097d	166960	22965672	0x15177a71af4dde1e190c6a183a8afcf39ae2224a	10	2021-12-26T01:01:23.000Z	3557326214	0xcaf07d0c1419ef4e41347b27e3338c35ba556c0297a9b475702dae8d4be77649
834148	true	0x0000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000500000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000000003200000000000000000000000000000000000000000000000000000000000000bc00000000000000000000000000000000000000000000000000000000000000ea080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a4b757fed6000000000000000000000000c4e595acdd7d12fec385e5da5d43160e8a0bac0e0000000000000000000000000d500b1d8e8ef31e21c99d1db9a6444d3adf12700000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000002dc6c0853ee4b2a13f8a742d64c8f088be7ba2131f670d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a4b757fed6000000000000000000000000853ee4b2a13f8a742d64c8f088be7ba2131f670d0000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000000000002791bca1f2de4661ed88a30c99a7a9449aa841740000000000000000002dc6c02ec255797fef7669fa243509b7a599121148ffba0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000804ad0e7b1a000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000007a00000000000000000000000002791bca1f2de4661ed88a30c99a7a9449aa8417400000000000000000000000000000003000000000000000000000000000000030000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001408000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000064eb5625d90000000000000000000000002791bca1f2de4661ed88a30c99a7a9449aa84174000000000000000000000000b707d89d29c189421163515c59e42147371d6857000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000800000000000000000000000b707d89d29c189421163515c59e42147371d6857000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000524f3432b1a00000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000004c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b6d039ccbc000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f0000000000000000000000002791bca1f2de4661ed88a30c99a7a9449aa84174000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000000002800000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000000038000000000000000000000000000000000000000000000000000000000000003e00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000006423b872dd000000000000000000000000e87eb1024eb84d3de7450efc00c76bcc73cc92e80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000072fb2864000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006423b872dd0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e87eb1024eb84d3de7450efc00c76bcc73cc92e8000000000000000000000000000000000000000000000000000000072ff48c79000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000044f4a215c3000000000000000000000000000000000000000000000000000000072fb28640000000000000000000000000000000000000000000000000000000072ff48c79000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000044296637bf000000000000000000000000000000000000000000000000000000072fb28640000000000000000000000000000000000000000000000000000000072ff48c7900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002463592c2b0000000000000000000000000000000000000000000000000000000061c7bab0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000402792de48df3a341419012bc52be1138dc264cb209b6353ff4a769da7f438a92236d1c4c7d01529e549545f80b1099f89143d985e9de1030b846ea05d055d12aa0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000028000000000000000000000000000000000000000000000000000000000000044800000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000024432ce0a7c000000000000000000000000000000000000000000000000000000000000008080000000000000000000000000000000000000000000000000000000000000440000000000000000000000002ec255797fef7669fa243509b7a599121148ffba00000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a405971224000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000100000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004470bdb947000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f00000000000000000000000000000000000000000000000000000000d51e72110000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000018414284aab00000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f00000000000000000000000000000001000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	{“flags”:“12”,“amount”:“1325948241818619478016”,“permit”:“0x”,“dstToken”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“srcToken”:“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“dstReceiver”:“0x15177a71af4dde1e190c6a183a8afcf39ae2224a”,“srcReceiver”:“0xc4e595acdd7d12fec385e5da5d43160e8a0bac0e”,“minReturnAmount”:“3573349469”}	303270	0x2ec255797fef7669fa243509b7a599121148ffba	0x6c4a483e	0x1111111254fb6c44bac0bed2854e76f90643097d	291035	22965017	0x15177a71af4dde1e190c6a183a8afcf39ae2224a	10	2021-12-26T00:38:52.000Z	0	0x54a63de434f464cbf353b1de9429a8a177dc50260ff6ce91822efd0647c321d3
733273	true	0x00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000005e00000000000000000000000000000000000000000000000000000000000000e80000000000000000000000000000000000000000000000000000000000000116080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000004c4ad0e7b1a000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000004600000000000000000000000000d500b1d8e8ef31e21c99d1db9a6444d3adf12700000000000000000000000000000003c0000000000000000000000000000003c0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001408000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000064eb5625d90000000000000000000000000d500b1d8e8ef31e21c99d1db9a6444d3adf1270000000000000000000000000ba12222222228d8ba445958a75a0704d566bf2c8000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000800000000000000000000000ba12222222228d8ba445958a75a0704d566bf2c80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001e452bbbe2900000000000000000000000000000000000000000000000000000000000000e00000000000000000000000002ec255797fef7669fa243509b7a599121148ffba00000000000000000000000000000000000000000000000000000000000000000000000000000000000000002ec255797fef7669fa243509b7a599121148ffba000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000061c90bda0297e37f1873d2dab4487aa67cd56b58e2f2787500010000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000d500b1d8e8ef31e21c99d1db9a6444d3adf12700000000000000000000000002791bca1f2de4661ed88a30c99a7a9449aa84174000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000280000000000000000000000000000000000000000000000000000000000000448000000000000000000000000000000000000000000000000000000000000164000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000804ad0e7b1a000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000007a00000000000000000000000002791bca1f2de4661ed88a30c99a7a9449aa8417400000000000000000000000000000003000000000000000000000000000000030000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000001408000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000064eb5625d90000000000000000000000002791bca1f2de4661ed88a30c99a7a9449aa84174000000000000000000000000b707d89d29c189421163515c59e42147371d6857000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000800000000000000000000000b707d89d29c189421163515c59e42147371d6857000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000524f3432b1a00000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000004c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b6d039ccbc000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f0000000000000000000000002791bca1f2de4661ed88a30c99a7a9449aa84174000000000000000000000000000000000000000000000000000000000000014000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000000002800000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000000000038000000000000000000000000000000000000000000000000000000000000003e00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000006423b872dd000000000000000000000000e87eb1024eb84d3de7450efc00c76bcc73cc92e80000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000072fb2864000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006423b872dd0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e87eb1024eb84d3de7450efc00c76bcc73cc92e8000000000000000000000000000000000000000000000000000000072ff48c79000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000044f4a215c3000000000000000000000000000000000000000000000000000000072fb28640000000000000000000000000000000000000000000000000000000072ff48c79000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000044296637bf000000000000000000000000000000000000000000000000000000072fb28640000000000000000000000000000000000000000000000000000000072ff48c7900000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002463592c2b0000000000000000000000000000000000000000000000000000000061c7bab0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000402792de48df3a341419012bc52be1138dc264cb209b6353ff4a769da7f438a92236d1c4c7d01529e549545f80b1099f89143d985e9de1030b846ea05d055d12aa0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000028000000000000000000000000000000000000000000000000000000000000044800000000000000000000000000000000000000000000000000000000000006400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000024432ce0a7c000000000000000000000000000000000000000000000000000000000000008080000000000000000000000000000000000000000000000000000000000000440000000000000000000000002ec255797fef7669fa243509b7a599121148ffba00000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a405971224000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000100000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004470bdb947000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f00000000000000000000000000000000000000000000000000000000d475b1410000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000018414284aab00000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f00000000000000000000000000000001000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	{“flags”:“12”,“amount”:“1325729554233640091648”,“permit”:“0x”,“dstToken”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“srcToken”:“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“dstReceiver”:“0x15177a71af4dde1e190c6a183a8afcf39ae2224a”,“srcReceiver”:“0x2ec255797fef7669fa243509b7a599121148ffba”,“minReturnAmount”:“3561555464”}	271970	0x2ec255797fef7669fa243509b7a599121148ffba	0x6c4a483e	0x1111111254fb6c44bac0bed2854e76f90643097d	189491	22965113	0x15177a71af4dde1e190c6a183a8afcf39ae2224a	10	2021-12-26T00:42:08.000Z	3562244801	0x37595da3d37ee360c5703552fc860ae97bebf9737c8a39964f249f9fa1b5ff0d

Example Query

Query with partition filter

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

AggregationRouterV4_fillOrderRFQ_function

Request-for-Quote (RFQ) order execution records from 1inch AggregationRouterV4 contract. Contains maker/taker token addresses, exchange amounts, cryptographic signatures, and execution outcomes for peer-to-peer token swaps.

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`	`NUMERIC`	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_order`	`STRUCT<info STRING, makerAsset STRING, takerAsset STRING, maker STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_makingAmount`	`STRING`	Amount of tokens provided by the maker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_takingAmount`	`STRING`	Amount of tokens requested from the taker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon1`	`STRING`	Actual amount of tokens received by the taker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_order	out_anon0	out_anon1	signature	to_address	block_number	from_address	in_signature	trace_address	block_timestamp	in_makingAmount	in_takingAmount	transaction_hash
679519	false	1529				0xd0a3b665	0x1111111254fb6c44bac0bed2854e76f90643097d	27856399	0x2a71693a4d88b4f6ae6697a87b3524c04b92ab38		1,1,1,0,4,2	2022-05-03T01:42:40.000Z			0xcd9631186e3e4a4324cf04470b8b68f99755c85db191ab1dc2760fe83b2410f1
635164	false	1529				0xd0a3b665	0x1111111254fb6c44bac0bed2854e76f90643097d	27884273	0x2a71693a4d88b4f6ae6697a87b3524c04b92ab38		1,2,1,0,1,2	2022-05-03T18:34:22.000Z			0x3353fa35d91ac4e0daa6a5ec8ce635f92ea1cc66e7042679523cb1b1b8672ab0
823619	false	83399	{“info”:“30466479507456500491224070790”,“maker”:“0xb398ffef80144095b8712c70a0c09886c8151feb”,“makerAsset”:“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“takerAsset”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“makingAmount”:“1060401616298296918969”,“takingAmount”:“1169748000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	1060401616298296918969	1169748000	0xd0a3b665	0x1111111254fb6c44bac0bed2854e76f90643097d	27878936	0x2a71693a4d88b4f6ae6697a87b3524c04b92ab38	0x624f4853ca9b45c9d9f3c62e55663eaa15850053e84a4126a42b66099d7b871228531c02970a15565f93eab6d6f13b09c29133fb1db243e01a1bf55afcbd337d1b	1,1,1,0,2	2022-05-03T15:18:01.000Z	0	1169748000	0xd3d74c7bd9e1b25c7b7c9adad5b2099f820a04efc56379cb53e8d4623b7dfec3

Example Query

Query with partition filter

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

AggregationRouterV4_fillOrderRFQTo_function

Decoded function call data for fillOrderRFQTo on 1inch AggregationRouter V4 contract, which executes Request-for-Quote (RFQ) orders with a specified recipient address. Contains maker-signed order parameters including asset addresses, amounts, and cryptographic signature, with execution outputs showing actual transferred quantities.

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`	`NUMERIC`	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_order`	`STRUCT<info STRING, makerAsset STRING, takerAsset STRING, maker STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_makingAmount`	`STRING`	Amount of tokens provided by the maker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_takingAmount`	`STRING`	Amount of tokens requested from the taker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon1`	`STRING`	Actual amount of tokens received by the taker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_order	in_target	out_anon0	out_anon1	signature	to_address	block_number	from_address	in_signature	block_timestamp	in_takingAmount	transaction_hash
166924	true	132188	{“info”:“30457896742177714361554492958”,“maker”:“0xb398ffef80144095b8712c70a0c09886c8151feb”,“makerAsset”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“takerAsset”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“makingAmount”:“14641996”,“takingAmount”:“5082597039939950”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x978e77107050b6834303ef298919d2aa866468f0	14641996	5082597039939950	0xbaba5855	0x1111111254fb6c44bac0bed2854e76f90643097d	27665968	0x77facc92de85669a65d13198c1d34b4a0a80737c	0x4a78050799b7775db8217a6554101e7bb9a6211992430c9f34dfb5469d64993f0b637dc049f050de1976be362fdd963519322e1938f725c287dc3dd72807cb9a1b	2022-04-28T06:02:07.000Z	5082597039939950	0x49c53a2b33243bca3815ca922e6a85c468caf655266b6327227cd0fe42562f39
141284	true	106548	{“info”:“30439416162381672512242890226”,“maker”:“0xb398ffef80144095b8712c70a0c09886c8151feb”,“makerAsset”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“takerAsset”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“makingAmount”:“48568869”,“takingAmount”:“16100000000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x6068bb934920f81fb55f2300265a5083270b413a	48568869	16100000000000000	0xbaba5855	0x1111111254fb6c44bac0bed2854e76f90643097d	27210292	0x31b1901b2d1b83fd07c979a490e2a769af2298de	0x54270c6d39f8a38f6e64771812bfbaceeaff224abb38aaa5cc2fa98b9fd922d42f552885d48b3a3c20e2cdfb28e277dcc70ca7face3cd2d45fbd3cb666067ef71b	2022-04-16T15:44:46.000Z	16100000000000000	0x509537c82cc1a1364c8eb9a5a226c2c8ac621cf869965c947d9a08b0e2fc2781
141284	true	106548	{“info”:“30439412967155662432062898012”,“maker”:“0xb398ffef80144095b8712c70a0c09886c8151feb”,“makerAsset”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“takerAsset”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“makingAmount”:“40392764”,“takingAmount”:“13387500000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x6068bb934920f81fb55f2300265a5083270b413a	40392764	13387500000000000	0xbaba5855	0x1111111254fb6c44bac0bed2854e76f90643097d	27210208	0x012a6cf8345d0ffb29c7b41c917ddac76c809b95	0xb04cb4096041f1c80c3b6eb0f0641ca7fdbcd0c70bc07dada4ad204c13c261331fcbbfb49c589e4afeca1af0e95bea3a3a2496da102f5fda33972ecbe80e2e471b	2022-04-16T15:41:54.000Z	13387500000000000	0x1a67d92afa7b46652d16a1896176161671bfb418447a88cb8bd4f549a19316ed

Example Query

Query with partition filter

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

AggregationRouterV4_fillOrderRFQToWithPermit_function

1inch AggregationRouterV4 function call data for executing Request-for-Quote (RFQ) orders with EIP-2612 permit-based token approvals to a specified recipient address. Contains order parameters, maker/taker amounts, cryptographic signatures, and execution outcomes for gasless token swaps.

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`	`NUMERIC`	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_order`	`STRUCT<info STRING, makerAsset STRING, takerAsset STRING, maker STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_makingAmount`	`STRING`	Amount of tokens provided by the maker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_takingAmount`	`STRING`	Amount of tokens requested from the taker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`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_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon1`	`STRING`	Actual amount of tokens received by the taker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_order	in_permit	in_target	out_anon0	out_anon1	signature	to_address	block_number	from_address	in_signature	block_timestamp	in_takingAmount	transaction_hash
303196	true	186196	{“info”:“30682795209014476261980252569”,“maker”:“0xb398ffef80144095b8712c70a0c09886c8151feb”,“makerAsset”:“0x7ceb23fd6bc0add59e62ac25578270cff1b9f619”,“takerAsset”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“makingAmount”:“20607226267344419”,“takingAmount”:“30000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x00000000000000000000000023a324e6b2188e9a49600cffc96c027fd54e7c280000000000000000000000001111111254fb6c44bac0bed2854e76f90643097dffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000006324e58b000000000000000000000000000000000000000000000000000000000000001b0996d1e4803c6209413b3094d8429262f8e1241f8ca8e13cbf3dd85b3d4cdafc383bd8245402683306d725a78db3e28f0ef07bdca1bd8994f6e27e1f91c545fd	0x23a324e6b2188e9a49600cffc96c027fd54e7c28	20607226267344419	30000000	0x4cc4a27b	0x1111111254fb6c44bac0bed2854e76f90643097d	33171371	0x23a324e6b2188e9a49600cffc96c027fd54e7c28	0xeac52cd0d24c4da1d1272c5168bc100fc7020cce8e116ec7a96370f013c879f13d89bd072958604c61554033fbe88991c19feca10fc2085150b6612fac1e6b20	2022-09-16T08:38:26.000Z	30000000	0x467435de74184448a2284062e9d96aaef5d997378a00b1cbaec20b2b779d59f0
229760	true	191239	{“info”:“30743865734548368777246135158”,“maker”:“0x902f98d63a7717fcf8069b80c5a1b4d132a5d776”,“makerAsset”:“0x53e0bca35ec356bd5dddfebbd1fc0fd03fabad39”,“takerAsset”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“makingAmount”:“500479487534046248960”,“takingAmount”:“3443986071”,“allowedSender”:“0x4b753eabe477ee22324c21a5a9d7457586861f22”}	0x0000000000000000000000004b753eabe477ee22324c21a5a9d7457586861f220000000000000000000000001111111254fb6c44bac0bed2854e76f90643097dffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000063576a4c000000000000000000000000000000000000000000000000000000000000001cc5e4cdf50be0dd51f69addd129a761d82f47d15a0f2e7e920bbe39da028fac437f16215d71886251fecc7eded3f031de50e94ebd7bf52877c2108c9d64cfac2c	0x4b753eabe477ee22324c21a5a9d7457586861f22	500479487534046248960	3443986071	0x4cc4a27b	0x1111111254fb6c44bac0bed2854e76f90643097d	34747813	0x4b753eabe477ee22324c21a5a9d7457586861f22	0x9df43d9ee6d4f57e16e5c6ea094c2f3de2a53183630d86646c83d34df92171b772967c9cbc8bd56af1681cdc2f8fa5c66bf38be3990d1b16f58595b7859cf3001b	2022-10-24T16:17:52.000Z	3443986071	0x8ba5bbe44cb6c5c606ac06465febe88b76e29c95dd314399b2ee9e9c028b3b4b
227593	true	184272	{“info”:“30663825607160449874084043608”,“maker”:“0x00000000ae347930bd1e7b0f35588b92280f9e75”,“makerAsset”:“0x1bfd67037b42cf73acf2047067bd4f2c47d9bfd6”,“takerAsset”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“makingAmount”:“37288783”,“takingAmount”:“7382084938”,“allowedSender”:“0x2ae55c67ac4333dc8d4c6b061db63e4749b47169”}	0x0000000000000000000000002ae55c67ac4333dc8d4c6b061db63e4749b471690000000000000000000000001111111254fb6c44bac0bed2854e76f90643097dffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000631534f8000000000000000000000000000000000000000000000000000000000000001c38b16c3355cae084fd1873b6aafd7b703e298bad0887df7304bfcd281f3ba97e336472d1d4429d4c7edc77fe53ff0cd89599ee69133c5a7bd448f636c65909cc	0x2ae55c67ac4333dc8d4c6b061db63e4749b47169	37288783	7382084938	0x4cc4a27b	0x1111111254fb6c44bac0bed2854e76f90643097d	32677356	0x2ae55c67ac4333dc8d4c6b061db63e4749b47169	0x1cd09bdcf13b6bf3845def4d121207048b7959f08dd60efa309ac3abb0c091ce8632acf1e71c1e813b744f4604c288cf36622b0aa87fbfcb05b45f3b3baee7269c	2022-09-04T11:00:43.000Z	7382084938	0x3136301c51906209c7c2947547db5be982c449e1cdced681dec8dc9ffbdc76e7

Example Query

Query with partition filter

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

AggregationRouterV4_OrderFilledRFQ_event

Request-for-quote (RFQ) order execution events emitted by 1inch AggregationRouterV4 contracts when off-chain quoted orders are filled. Contains order hash, maker token amount, and standard event metadata for tracking peer-to-peer swap settlements.

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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_makingAmount`	`STRING`	Amount of tokens provided by the maker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

address	removed	log_index	block_number	in_orderHash	block_timestamp	in_makingAmount	transaction_hash
0x1111111254fb6c44bac0bed2854e76f90643097d	false	249	26901432	0xa5e1aee72ffa36499f3bda64719aa8741427fb3aec88a91837ec9305bdc74bab	2022-04-08T19:09:01.000Z	22024800	0x7f4d4290f3b5fd42d8c148457aa0c5b0ae5ad6a52f538eb7d1f611a6551224a1
0x1111111254fb6c44bac0bed2854e76f90643097d	false	8	28913741	0x8adbc35e2fa9bf7cf2b4959db2830928f09e1d358afc91ddf77af2fb595c9634	2022-05-29T13:26:59.000Z	13777292817070624	0x406140c1ce41bace32d3cb4387ebc6edbc50a4071e319f98ac6872eba615f3c4
0x1111111254fb6c44bac0bed2854e76f90643097d	false	9	28908955	0x84ac2c0af395215a5c5ddf906e82911efc4ebbf12dcbac01984cc88c2797966a	2022-05-29T10:35:16.000Z	895860000	0x77f1bf564e5edf997f1cf61260d0fa7d3ea3939c06823f8ac4a38b224090b77a

Example Query

Query with partition filter

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

AggregationRouterV4_swap_function

Decoded function call data for the swap function on 1inch AggregationRouterV4 contracts. Records token swap executions including source and destination token addresses, amounts, minimum return thresholds, execution flags, and actual amounts spent and returned.

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`	`NUMERIC`	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	status	in_data	in_desc	gas_used	in_caller	signature	to_address	out_gasLeft	block_number	from_address	trace_address	block_timestamp	out_returnAmount	transaction_hash
316569	true	0x00000000000000000000000000000000000000000000000000000000006300a0fbb7cd068042942cdec85078cf0e28e9cb5acd40cb53997ed6000000000000000000000bea4ed141110f6eeeaba9a1df36d8c26f684d2475dcf2f77fe7b8e66571e0fca7104c4d670bf1c8d7221111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000000000000000000000000001137eeaea68f7280000	{“flags”:“4”,“amount”:“5082000000000000000000”,“permit”:“0x”,“dstToken”:“0xf2f77fe7b8e66571e0fca7104c4d670bf1c8d722”,“srcToken”:“0x4ed141110f6eeeaba9a1df36d8c26f684d2475dc”,“dstReceiver”:“0x0987494ee3a9ee1f3c9d64f680d8aead05eb28b5”,“srcReceiver”:“0xe37e799d5077682fa0a244d46e5649f71457bd09”,“minReturnAmount”:“5073481805192041688227”}	220273	0xe37e799d5077682fa0a244d46e5649f71457bd09	0x7c025200	0x1111111254fb6c44bac0bed2854e76f90643097d	41358	48612367	0x0987494ee3a9ee1f3c9d64f680d8aead05eb28b5		2023-10-12T02:09:19.000Z	5073989204112452933521	0xf2bcfc133d3fae0d56800a2ee8da58c30ab23d231694e10c10aaada627be87af
205874	true	0x00000000000000000000000000000000000000000000000000000000006302a0000000000000000000000000000000000000000000000000000000000b2e27c1ee63c1e58111bcc5b9fbcd882952fec8ae95214036a981797b43c73b90e0c2a355784dcf0da12f477729b31e771111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000000000000000000000000044ad5a60d5c71f0000	{“flags”:“4”,“amount”:“1266870000000000000000”,“permit”:“0x”,“dstToken”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“srcToken”:“0x43c73b90e0c2a355784dcf0da12f477729b31e77”,“dstReceiver”:“0x45abc42a92017e941a04fc3e04c099a5f5d337c7”,“srcReceiver”:“0xe37e799d5077682fa0a244d46e5649f71457bd09”,“minReturnAmount”:“187574209”}	141972	0xe37e799d5077682fa0a244d46e5649f71457bd09	0x7c025200	0x1111111254fb6c44bac0bed2854e76f90643097d	64032	48613690	0xa1fb1f1e5382844ee2d1bd69ef07d5a6abcbd388	0,1,0,3	2023-10-12T02:57:47.000Z	189468898	0x024f040191ed5102680475d260a5648a1a93705653b2f247a9a48c3bca756efb
1441384	true	0x00000000000000000000000000000000000000000000000000000000006302a0000000000000000000000000000000000000000000000006006bc0658e8f3700ee63c1e58105bfe97bf794a4db69d3059091f064ea0a5e538e0d500b1d8e8ef31e21c99d1db9a6444d3adf12701111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000000000000000000000000000068fdc8a54f115eebd	{“flags”:“4”,“amount”:“121046776981983981245”,“permit”:“0x”,“dstToken”:“0xfa68fb4628dff1028cfec22b4162fccd0d45efb6”,“srcToken”:“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“dstReceiver”:“0x43d4edc13d2a4ba9f3ac8e00a980a9704fe6bcd6”,“srcReceiver”:“0xe37e799d5077682fa0a244d46e5649f71457bd09”,“minReturnAmount”:“111773170111391656072”}	338754	0xe37e799d5077682fa0a244d46e5649f71457bd09	0x7c025200	0x1111111254fb6c44bac0bed2854e76f90643097d	1102760	48637824	0x43d4edc13d2a4ba9f3ac8e00a980a9704fe6bcd6	2,0,3,1,0,4,0	2023-10-12T17:49:54.000Z	111829084653718515330	0x798409716054ef6c8948937e19ee87fa23e07d950aeaba21ecaca609a50bb3a3

Example Query

Query with partition filter

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

AggregationRouterV4_Swapped_event

Swap execution events from 1inch V4 aggregation router on Polygon, capturing source/destination tokens, amounts spent/received, and participant addresses. Used for analyzing DEX aggregation trade flow, routing efficiency, and token pair liquidity across the 1inch protocol.

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
0x1111111254fb6c44bac0bed2854e76f90643097d	false	0xc590175e458b83680867afd273527ff58f74c02b	544	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x00e5646f60ac6fb446f621d146b6e1886f002905	27442681	0xc590175e458b83680867afd273527ff58f74c02b	1982500000000000000	2022-04-22T12:51:43.000Z	4101742307086327679	0x56db51b32f30b8078b5472c6650cc4c73372ca5a0c32611edaaed280f05c5284
0x1111111254fb6c44bac0bed2854e76f90643097d	false	0x7b7ebf21e88b17778cec91e1867902db41f0af2b	348	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x0169ec1f8f639b32eec6d923e24c2a2ff45b9dd6	27431046	0x7b7ebf21e88b17778cec91e1867902db41f0af2b	13792104448563017408427	2022-04-22T05:53:56.000Z	134464967085413323346	0xda4943f53d08136b900095303f37c3a3f0c9c32b3b4cd2306b827b072ab10a6c
0x1111111254fb6c44bac0bed2854e76f90643097d	false	0x7b7ebf21e88b17778cec91e1867902db41f0af2b	578	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	0x0169ec1f8f639b32eec6d923e24c2a2ff45b9dd6	27422173	0x7b7ebf21e88b17778cec91e1867902db41f0af2b	15884331684958248245215	2022-04-22T00:41:04.000Z	156350895887523577336	0x72801dda336bbd1d92b774905c668386247babb94eb7d4f92b42ab0ee718fd88

Example Query

Query with partition filter

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

AggregationRouterV4_uniswapV3Swap_function

Decoded function calls to the 1inch AggregationRouterV4 contract’s uniswapV3Swap method, which routes token swaps through Uniswap V3 liquidity pools. Contains input amounts, minimum return thresholds, encoded pool routing paths, and actual return amounts for DEX aggregation analysis.

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`	`NUMERIC`	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_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.
`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	signature	to_address	block_number	from_address	in_minReturn	block_timestamp	out_returnAmount	transaction_hash
252245	true	109168	[“72370055773322622139731865631362609382438276038622151427857862998483797182277”]	40103023546629679654	0xe449022e	0x1111111254fb6c44bac0bed2854e76f90643097d	46842487	0x02704220687510919c40fa7a7edcd437b3082686	39384294450003407320	2023-08-28T04:15:58.000Z	39782068049743692756	0xa9e32cc1dcc1fa0e507dd98bcdd74f307391bdee26b7e84c0d6848468c273d65
267587	true	140063	[“289065304999231361997893066009613468775921363661”]	56409577	0xe449022e	0x1111111254fb6c44bac0bed2854e76f90643097d	46852464	0x05bbc353afe7dd120440df1c1ba9e0933d79c2ba	16339667160910693216	2023-08-28T10:09:56.000Z	16421776041116274589	0x42896c034f949a371e0ab64afa973e166c6966b0eb7c0d939a8b07b6c76a3a83
185447	true	127283	[“692119560751711236793273905081026732848614781523”]	2742000000000000000000	0xe449022e	0x1111111254fb6c44bac0bed2854e76f90643097d	46865110	0x0987494ee3a9ee1f3c9d64f680d8aead05eb28b5	557254172	2023-08-28T17:39:21.000Z	557309903	0xcf1d417b528c63473e6670f437ab51e36dbe8e49006531d30a41e05e432ea5f1

Example Query

Query with partition filter

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

AggregationRouterV4_uniswapV3SwapCallback_function

Callback function invocations from 1inch Aggregation Router V4 to Uniswap V3 pools during swap execution. Contains token amount deltas and contextual data passed during the callback, enabling analysis of V3 liquidity pool interactions within 1inch aggregated swaps.

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`	`NUMERIC`	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_amount0Delta`	`STRING`	Change in amount for the first token in a Uniswap V3 liquidity pool swap. Positive values indicate tokens owed to the pool, negative values indicate tokens owed to the recipient.
`in_amount1Delta`	`STRING`	Change in amount for the second token in a Uniswap V3 liquidity pool swap. Positive values indicate tokens owed to the pool, negative values indicate tokens owed to the recipient.
`in_anon2`	`STRING`	Third parameter passed to the Uniswap V3 swap callback function. Hex-encoded, 0x-prefixed, 66-character string representing contextual data for the swap operation.

Sample Data

gas	status	gas_used	in_anon2	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_amount0Delta	in_amount1Delta	transaction_hash
59631	true	10237	0x0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d	0xfa461e33	0x1111111254fb6c44bac0bed2854e76f90643097d	27344231	0x017e2b71e70537c95ab5a58aecb793323ab0b154	0,0,0,2,2	2022-04-20T01:12:20.000Z	41956845496020812	-702908019544664657510	0xa554de0189bf32632217c18fa93827fc0ee2c0783941349a06f521ebe74a9c12
60098	true	15951	0x000000000000000000000000c590175e458b83680867afd273527ff58f74c02b	0xfa461e33	0x1111111254fb6c44bac0bed2854e76f90643097d	27380599	0x017e2b71e70537c95ab5a58aecb793323ab0b154	1,0,1,0,2	2022-04-20T23:56:10.000Z	39650000000000000	-471343885763828045704	0x468ca46448a7e4ca3a2a204cffe6a2da34f0e9e2e2cb480161d4264257d0c271
161830	true	15975	0x000000000000000000000000c590175e458b83680867afd273527ff58f74c02b	0xfa461e33	0x1111111254fb6c44bac0bed2854e76f90643097d	27347662	0x017e2b71e70537c95ab5a58aecb793323ab0b154	1,0,1,0,2	2022-04-20T03:34:47.000Z	-34231208328837683	496489370000000048722	0xe3bd3d85be9f8321fc66ccf4c697aa41ae0d1f44134310599ed6d9274b351cc5

Example Query

Query with partition filter

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

AggregationRouterV4_uniswapV3SwapTo_function

1inch AggregationRouterV4 function calls routing token swaps through Uniswap V3 pools with slippage protection. Contains input amounts, minimum return thresholds, encoded pool routing paths, and actual swap output amounts.

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`	`NUMERIC`	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_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. 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.
`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	signature	to_address	block_number	from_address	in_minReturn	in_recipient	block_timestamp	out_returnAmount	transaction_hash
166093	false	111710	[]		0xbc80f1a8	0x1111111254fb6c44bac0bed2854e76f90643097d	27572493	0x44b24cee4aa040b858ade16a7e013c6078bdf327			2022-04-25T21:30:06.000Z		0x86978dfda6267ff7059a7a965d25f6f7b0b3169fcb4df0bdfbf863cf2695159c
186768	true	130004	[“72370055773322622139731865631363095597924122766500691413170753007076743867698”]	108757774	0xbc80f1a8	0x1111111254fb6c44bac0bed2854e76f90643097d	27559480	0x2ed0127c4fbbd28b231af02db9df6e982a6831c4	82967689680066054116	0x8358c52cc3ceefd8151766802b1008e3257fdf9d	2022-04-25T13:21:13.000Z	83792385385754082664	0x3296f3d40537c0b072a7bee87a8b675abfd64ce129c777f8e03ffc165e4306ad
173955	true	136349	[“398863619094379921518073707639585685671628834312”]	400000000	0xbc80f1a8	0x1111111254fb6c44bac0bed2854e76f90643097d	27552216	0xda7fc04e24fee7d61efb0c6cf90c38ff5438f8a8	140661545391723121	0xa4c01e85de0d875177a5fdca053143b60c99cfb5	2022-04-25T08:50:11.000Z	142084740661306260	0x795066550d3e95030b6fb6da76ec690c420cb64e0715120f04ac9aedb8dc1741

Example Query

Query with partition filter

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

AggregationRouterV4_uniswapV3SwapToWithPermit_function

1inch AggregationRouterV4 function calls executing Uniswap V3 token swaps with EIP-2612 permit signatures for gasless token approvals. Contains source token, routing pools, swap amounts, recipient addresses, and permit signature data for analyzing DEX aggregation trades with meta-transaction support.

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`	`NUMERIC`	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_recipient`	`STRING`	Address designated to receive the output tokens from a swap 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_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	in_recipient	block_timestamp	out_returnAmount	transaction_hash
292869	true	161380	[“14474011154664524427946373126994836142224040241638561183483741227421623491012”]	20000000000000000000000	0x0000000000000000000000000f8c148a4854c9647e894699584b31c7b0459e200000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000043c33c193756480000000000000000000000000000000000000000000000000000000000000632c3689000000000000000000000000000000000000000000000000000000000000001b388f5105351c53d4e75dd32b50e0d02a285cc71595ecee6aac7c3295efe21d1e06d1995cac0517f5da9b2f67a5eb7a104fa9e438ab8df42d3ce7fbd50bb539e6	0x2521b930	0x1111111254fb6c44bac0bed2854e76f90643097d	0x0d0b8488222f7f83b23e365320a4021b12ead608	33399207	0x0f8c148a4854c9647e894699584b31c7b0459e20	54149627890859486040	0x0f8c148a4854c9647e894699584b31c7b0459e20	2022-09-21T21:48:55.000Z	54696593829150996001	0x175b497d4e4e681d8b66afbb271fb09b25dbf0f382250c3c1ae251d2e552cb6c
297554	true	180813	[“1030916556513996499805551833252256949148953573737”]	90000000000000000000	0x00000000000000000000000016bf4ed3fcca47d1de23acefa83aebcfa63999960000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000000000000000000000000004e1003b28d928000000000000000000000000000000000000000000000000000000000000632c20e7000000000000000000000000000000000000000000000000000000000000001ce8224328bb76cd17bbe187578c0b49112e883451c34879fc01ab79bb7432ec292e44d965abf121f1b259c25673390f5bc04b49356f6e4bfca84633535972d2a3	0x2521b930	0x1111111254fb6c44bac0bed2854e76f90643097d	0x16eccfdbb4ee1a85a33f3a9b21175cd7ae753db4	33396525	0x16bf4ed3fcca47d1de23acefa83aebcfa6399996	248571571	0x16bf4ed3fcca47d1de23acefa83aebcfa6399996	2022-09-21T20:16:42.000Z	251082395	0x0ce745dcc1147576b6a3f596077f2aa6e331520d00bcae41fe2e91278b17dbd8
260955	true	190951	[“57896044618658097711785492505708082959046637244631119356157239282997854012360”]	90035018	0x000000000000000000000000fd24584caeffc8e6d0cdc30bc58e0e13c157f27f0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097dffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000632c36bc000000000000000000000000000000000000000000000000000000000000001cd66d9e09cdae187a5947c7fd31c36f0e248c9fcb2045e5b3828f5ce0b6508ff50c041f969b420b94d053840c4e13d324737bf401e1e431b713770a2c8744a553	0x2521b930	0x1111111254fb6c44bac0bed2854e76f90643097d	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	33399399	0xfd24584caeffc8e6d0cdc30bc58e0e13c157f27f	482382	0xfd24584caeffc8e6d0cdc30bc58e0e13c157f27f	2022-09-21T21:55:31.000Z	487687	0x3edccbd566f087dc456effd51a8211d378e273e34c1a3a3ee3ea8f6d783432eb

Example Query

Query with partition filter

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

AggregationRouterV4_unoswap_function

1inch AggregationRouterV4 unoswap function call data capturing single-route token swap executions. Contains source token, input amount, minimum return threshold, encoded pool routing parameters, and actual return amount for slippage analysis.

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`	`NUMERIC`	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.
`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	signature	to_address	in_srcToken	block_number	from_address	in_minReturn	trace_address	block_timestamp	out_returnAmount	transaction_hash
1000000	false	28882	[]		0x2e95b6c8	0x1111111254fb6c44bac0bed2854e76f90643097d		31749727	0xa7ac344527fbf97ed357f7a7b52cbe40b132eeb6			2022-08-11T00:59:07.000Z		0x9aaaf736251d29cf0d4c6f8d3b3c50367c4c0e170c0b737d0c883399cfee2988
534832	false	122578	[“0x20000000000000003b6d03408fcb93c0d9fa361c57c1d31bbf1c4d8c61af7d3d”,“0x80000000000000003b6d0340304e57c752e854e9a233ae82fcc42f7568b81180”]	80358136589710502952	0x2e95b6c8	0x1111111254fb6c44bac0bed2854e76f90643097d	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	31771772	0xe79f6adcac55bfb8bd04a6059e846c24c1096c35	1	1,3,1,4	2022-08-11T14:39:17.000Z	74692853	0xb352d0490e2a319d90178170b7b54066dbcba417e70563445883d05970ba4796
350170	false	79483	[“0x20000000000000003b6d0340eef611894ceae652979c9d0dae1deb597790c6ee”]	80096591570571145696	0x2e95b6c8	0x1111111254fb6c44bac0bed2854e76f90643097d	0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270	31771693	0xe79f6adcac55bfb8bd04a6059e846c24c1096c35	1	1,3,1,4	2022-08-11T14:36:34.000Z	74883775596445771395	0x93d8ae5345ee2b0290578dd40fa61da4c5322cd93513cf38aab558ee934229a2

Example Query

Query with partition filter

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

AggregationRouterV4_unoswapWithPermit_function

Token swap function calls on 1inch AggregationRouter V4 using EIP-2612 permit signatures for gasless approvals. Contains source token, input amount, minimum return threshold, permit signature data, and routing pool identifiers for executing single-path swaps without prior token approval transactions.

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

No sample data available.

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AggregationRouterV4_discountedSwap_function

AggregationRouterV4_fillOrderRFQ_function

AggregationRouterV4_fillOrderRFQTo_function

AggregationRouterV4_fillOrderRFQToWithPermit_function

AggregationRouterV4_OrderFilledRFQ_event

AggregationRouterV4_swap_function

AggregationRouterV4_Swapped_event

AggregationRouterV4_uniswapV3Swap_function

AggregationRouterV4_uniswapV3SwapCallback_function

AggregationRouterV4_uniswapV3SwapTo_function

AggregationRouterV4_uniswapV3SwapToWithPermit_function

AggregationRouterV4_unoswap_function

AggregationRouterV4_unoswapWithPermit_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​AggregationRouterV4_discountedSwap_function

​AggregationRouterV4_fillOrderRFQ_function

​AggregationRouterV4_fillOrderRFQTo_function

​AggregationRouterV4_fillOrderRFQToWithPermit_function

​AggregationRouterV4_OrderFilledRFQ_event

​AggregationRouterV4_swap_function

​AggregationRouterV4_Swapped_event

​AggregationRouterV4_uniswapV3Swap_function

​AggregationRouterV4_uniswapV3SwapCallback_function

​AggregationRouterV4_uniswapV3SwapTo_function

​AggregationRouterV4_uniswapV3SwapToWithPermit_function

​AggregationRouterV4_unoswap_function

​AggregationRouterV4_unoswapWithPermit_function

Tables

AggregationRouterV4_discountedSwap_function

AggregationRouterV4_fillOrderRFQ_function

AggregationRouterV4_fillOrderRFQTo_function

AggregationRouterV4_fillOrderRFQToWithPermit_function

AggregationRouterV4_OrderFilledRFQ_event

AggregationRouterV4_swap_function

AggregationRouterV4_Swapped_event

AggregationRouterV4_uniswapV3Swap_function

AggregationRouterV4_uniswapV3SwapCallback_function

AggregationRouterV4_uniswapV3SwapTo_function

AggregationRouterV4_uniswapV3SwapToWithPermit_function

AggregationRouterV4_unoswap_function

AggregationRouterV4_unoswapWithPermit_function