1inch_v5_polygon

Tables

AggregationRouterV5_clipperSwap_function

Decoded function calls to the clipperSwap method on 1inch AggregationRouterV5 contracts. Contains token swap parameters including source/destination tokens, input/output amounts, Clipper DEX router address, signature expiration timestamp, and ECDSA signature components (r, vs) for validating signed swap orders.

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_clipperExchange`	`STRING`	Contract address of the Clipper decentralized exchange router handling the swap execution. 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_inputAmount`	`STRING`	Amount of source tokens being swapped or deposited. Numeric string representation of token quantity in smallest denomination.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_goodUntil`	`STRING`	Expiration timestamp for the Clipper swap signature validity. Numeric string representing the deadline after which the signed swap parameters become invalid.
`in_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_vs`	`STRING`	ECDSA signature component vs, which combines the recovery identifier v with the signature component s for compact signature representation. 66-character hex string including 0x prefix.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	in_r	in_vs	value	status	gas_used	signature	to_address	in_dstToken	in_srcToken	block_number	from_address	in_goodUntil	in_inputAmount	block_timestamp	in_outputAmount	out_returnAmount	transaction_hash	in_clipperExchange
230231			2000000000000000000	false	123632	0x84bd6d29	0x1111111254eeb25477b68fb85ed929f73a960582			48530858	0x618f9095b1e669a4c4640fdd430ca02235a72efa			2023-10-09T23:54:50.000Z			0xd7e6faddd57ea2feae5ed2d4ede3254ebc85a2c94f71872531b6504be7190462
219423			0	false	126135	0x84bd6d29	0x1111111254eeb25477b68fb85ed929f73a960582			48492418	0xabd10f0a61270d6977c5bfd9d4ec74d6d3bc96ab			2023-10-09T00:23:03.000Z			0x7b74428edaecbbc9b0a4d480734fdc831a5ee5d8a42b55b1916732881f52ddc5
227198	0x5df59fdee72296ff95ebe93fd10ffdbe37dabe617d31c461041e871708edc7f3	0x29b34a23b723131449a68c9e055745a07682ac562d3cb4cbaef71fe30df7e9e3	0	true	185672	0x84bd6d29	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	48505222	0xfc7f8cc9ec8b3a6a5f0790d56ae7616f68c1fa2f	627082620292672792992986136046496401065719370115706755801191528179	690229	2023-10-09T08:16:00.000Z	1249581415606371584	1249581415606371584	0xb0c53bedb7b5ef497792c7a4690e2762d8b6eea6a3cd67b0ca349324bf1d7cee	0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8

Example Query

Query with partition filter

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

AggregationRouterV5_clipperSwapTo_function

Decoded function calls to the clipperSwapTo method on 1inch AggregationRouter V5 contracts, executing token swaps through Clipper DEX with cryptographically signed swap parameters. Contains source/destination tokens, swap amounts, recipient addresses, ECDSA signature components (r, vs), and expiration timestamps for signature validation.

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_clipperExchange`	`STRING`	Contract address of the Clipper decentralized exchange router handling the swap execution. Hex-encoded, 0x-prefixed, 42-character string.
`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_dstToken`	`STRING`	Contract address of the destination token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_inputAmount`	`STRING`	Amount of source tokens being swapped or deposited. Numeric string representation of token quantity in smallest denomination.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_goodUntil`	`STRING`	Expiration timestamp for the Clipper swap signature validity. Numeric string representing the deadline after which the signed swap parameters become invalid.
`in_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_vs`	`STRING`	ECDSA signature component vs, which combines the recovery identifier v with the signature component s for compact signature representation. 66-character hex string including 0x prefix.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	in_r	in_vs	value	status	gas_used	signature	to_address	in_dstToken	in_srcToken	block_number	from_address	in_goodUntil	in_recipient	in_inputAmount	block_timestamp	in_outputAmount	out_returnAmount	transaction_hash	in_clipperExchange
283635			26000000000000000000	false	125760	0x093d4fa5	0x1111111254eeb25477b68fb85ed929f73a960582			38314602	0x315571087daee11f7c7b7d6ebfd52a3a8d915487				2023-01-20T15:42:55.000Z			0x499945596590730ec4954d5cfee8908b4c1bad1f9a9cad603a6cbed0f4cbe90b
283702			6476200000000000000	false	117134	0x093d4fa5	0x1111111254eeb25477b68fb85ed929f73a960582			38313987	0x8cc1a294567fb16182ae2945150f55d631718d67				2023-01-20T15:20:31.000Z			0x0d4d1ab1dfcfe6635971f5376a141b6bdb1c51e877f2f2adb22674129459c1c8
286881	0x6f423efe07a6f5b35a12ade5b6bc16324bd1cc09b0ba03fdf845f7ff480f9250	0x0d2954bf5f30fc5ddb8433e7a4a53c1183d7a5f1d68daf9f1b56db7ae4d9537e	42000000000000000000	true	180864	0x093d4fa5	0x1111111254eeb25477b68fb85ed929f73a960582	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	0x0000000000000000000000000000000000000000	38289552	0xb87428320dfb401b631adc9c7aff2f6e454c2476	595292445698164216040261547013966780321161288562569693371199774495	0x81ab6fd4a68d0addfad65f9f97bc1427dcd40c8e	42000000000000000000	2023-01-20T00:23:01.000Z	39830649	39830649	0x3cdf1934978aef93cc8698e08047815bf2efc220de3c949ecc84b81525bcf07a	0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8

Example Query

Query with partition filter

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

AggregationRouterV5_clipperSwapToWithPermit_function

Token swap function calls executed through 1inch AggregationRouterV5 using Clipper DEX (Decentralized Exchange) with EIP-2612 permit signatures for gasless approvals. Contains swap parameters including source/destination tokens, amounts, recipient addresses, ECDSA signature components, and execution outcomes for tracking permit-based swap 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_clipperExchange`	`STRING`	Contract address of the Clipper decentralized exchange router handling the swap execution. Hex-encoded, 0x-prefixed, 42-character string.
`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_dstToken`	`STRING`	Contract address of the destination token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_inputAmount`	`STRING`	Amount of source tokens being swapped or deposited. Numeric string representation of token quantity in smallest denomination.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_goodUntil`	`STRING`	Expiration timestamp for the Clipper swap signature validity. Numeric string representing the deadline after which the signed swap parameters become invalid.
`in_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_vs`	`STRING`	ECDSA signature component vs, which combines the recovery identifier v with the signature component s for compact signature representation. 66-character hex string including 0x prefix.
`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	in_r	in_vs	status	gas_used	in_permit	signature	to_address	in_dstToken	in_srcToken	block_number	from_address	in_goodUntil	in_recipient	in_inputAmount	block_timestamp	in_outputAmount	out_returnAmount	transaction_hash	in_clipperExchange
272713	0x00f3b4fe9bd5b7d07a10b5dee030c8440b828e251869d05e9670a3bfb84c9e9c	0xba6a31b0af6610fcbe5e8b13adff5fb1cf827d419db0a40aea2f445c1c04b70d	true	231182	0x000000000000000000000000bdaec068708ea16d7dc9be8f94125d3648e6d2c10000000000000000000000001111111254eeb25477b68fb85ed929f73a9605820000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006677d5a40000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000001b67ba76435f80ad3594d34c97637966eec3038bbd11538ce365c8ecb9f7533a27566e15a451e04d7ec4e6e4548e1e2cc12ff785bff3cc3846bf133091a56fdf74	0xc805a666	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	0x8f3cf7ad23cd3cadbd9735aff958023239c6a063	58461775	0xbdaec068708ea16d7dc9be8f94125d3648e6d2c1	627396318451898742364659725265368618646448313105763674931582108789	0xbdaec068708ea16d7dc9be8f94125d3648e6d2c1	1658281143135291129	2024-06-22T07:58:46.000Z	2923821020893228544	2923821020893228544	0x4c4590ca52c086296cbadb3c4e3a426fd1d3900e5b807181892fc1116f078e54	0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8
280534			false	187453		0xc805a666	0x1111111254eeb25477b68fb85ed929f73a960582			45240952	0x09da51b81ab40b2e0825e60e0838ba72409fc5d3				2023-07-18T22:04:41.000Z			0xe7c540c6f663e8c638211d366b3ae52f6b2f0aab13f8f18e083889ccd7d59fa9
280731	0x91cd2c0aabcc11a617ee2dc32fa329bbb929cc85469e6fce7b0b41084c24293c	0x860acd8727c1b748d8d1c49c9da1eceeff0313f0238438253ebb06f463e0044c	true	244014	0x0000000000000000000000008064a470273a5fdc22d9629dfc37f9d5b3cebc4e0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064b73171000000000000000000000000000000000000000000000000000000000000001b7f44d08ac33e1642f4cec09a9bc0a8d3bce6648598b2158a920feff7c25606541f42fbca6bd54b385403cc0cb999cf9210c04830758a349f061b70ab9723a823	0xc805a666	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	45207464	0x8064a470273a5fdc22d9629dfc37f9d5b3cebc4e	627396318451898742371927816341816449093090747717078545961718243405	0x8064a470273a5fdc22d9629dfc37f9d5b3cebc4e	1780177	2023-07-18T00:42:57.000Z	2280720284383278336	2280720284383278336	0xbde4c9c77fce158cb94e1dfc48b7144a2f4b413aa60fd480c25bdf085e04f198	0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrder_function

Decoded function call data from 1inch AggregationRouterV5 contract’s fillOrder method executing Request-for-Quote (RFQ) orders. Contains maker/taker addresses, token pair details, amounts, cryptographic signatures, and execution results including actual filled quantities and order hash identifiers.

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<salt STRING, makerAsset STRING, takerAsset STRING, maker STRING, receiver STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING, offsets STRING, interactions 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_interaction`	`STRING`	Encoded data for custom interactions executed during order fulfillment. Hex-encoded byte string, typically 0x-prefixed.
`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_skipPermitAndThresholdAmount`	`STRING`	Bitfield parameter combining permit-skipping flag and minimum threshold amount for order execution. Numeric string encoding both a boolean flag (in the highest bit) to skip EIP-2612 permit processing and a threshold amount (in remaining bits) specifying the minimum acceptable taking amount.
`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.
`out_anon2`	`STRING`	Unique identifier hash for the executed order. 66-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
1618860	false	46793	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	39258011	0x100860244e0a0e703306b8d5f4f4054eed98290a	0,0,0,1,2	2023-02-13T20:47:59.000Z	0x15e5ebb6cb4b53170fcde6ce783af94f38a4ac4b95832d6a240478c65b516fd2
1662997	false	114967	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	39258011	0x100860244e0a0e703306b8d5f4f4054eed98290a	0,0,0,1,2	2023-02-13T20:47:59.000Z	0x87545aab743fe26815d8988d36dfee9888f58d327adc382d5ee9258e2e0c83dd
154102	false	23590	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	39245595	0x366fe681a8dbdb2b5716eb33ea71f5b4e170499e	0,3,1,1,0,0,1	2023-02-13T12:40:27.000Z	0x631f93c6bc9e1aff68e640a30c320330cafa2771b1292933c8a9c996631c2316

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrderRFQ_function

Decoded function calls to the 1inch AggregationRouterV5 fillOrderRFQ method, which executes Request-for-Quote (RFQ) orders between maker and taker. Contains order details including asset addresses, amounts, maker signature, execution flags, and returned fill amounts 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_flagsAndAmount`	`STRING`	Encoded integer combining order execution flags and token amount for RFQ (Request-for-Quote) orders. Numeric string representing a packed value where higher-order bits contain execution flags and lower-order bits contain the taking amount in the token’s 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.
`out_anon2`	`STRING`	Unique identifier hash for the executed order. 66-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	in_order	out_anon0	out_anon1	out_anon2	signature	to_address	block_number	from_address	in_signature	trace_address	block_timestamp	transaction_hash	in_flagsAndAmount
490413	true	66433	{“info”:“31125306752188027863469925983”,“maker”:“0x0b3337b3274584208231c689e2c454d79b37b0f3”,“makerAsset”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“takerAsset”:“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“makingAmount”:“198685”,“takingAmount”:“316867000000000000”,“allowedSender”:“0xd8121433a2b8653b8eb62bd76273eaf104f9be09”}	198486	316550000000000000	0x9cad0abaf40fea9d5ac33fbf97ee3f395174f6cad1d83c8386d105ff7aeed8de	0x3eca9c0a	0x1111111254eeb25477b68fb85ed929f73a960582	44148011	0xd8121433a2b8653b8eb62bd76273eaf104f9be09	0x1cd4ab096d2caad789670f69121136bc44de2a7a87474437c8ea06bfccb08d3b05527c6b94b4c5d94f27c3c5da7a303dcd5f84494ff9b0b0df1a0c257ac30db64464923f9c	0,1,1,1	2023-06-21T00:09:08.000Z	0x28a0ad13836a9969fc3e8ab5c856c150c88e283d961fd3d7ffe42ddd8499b527	316550000000000000
831158	true	66433	{“info”:“31126565760917802614077269683”,“maker”:“0x0b3337b3274584208231c689e2c454d79b37b0f3”,“makerAsset”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“takerAsset”:“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“makingAmount”:“199373”,“takingAmount”:“301912000000000000”,“allowedSender”:“0xd8121433a2b8653b8eb62bd76273eaf104f9be09”}	199173	301610000000000000	0x836ed1cf47640a278932f3a44d2f64a0bd66721281697ede90c27919da90a14e	0x3eca9c0a	0x1111111254eeb25477b68fb85ed929f73a960582	44178360	0xd8121433a2b8653b8eb62bd76273eaf104f9be09	0x1c15f9d7da8d9aba55efc678085dceec61e599640ec6f60be3808d331efd85190052573803e47be1ee09fc441cc90533b65abf090e189f4b366e2c9e31d3c869a264934a37	0,1,1,1	2023-06-21T19:06:36.000Z	0xbee160d25305d49b784fd30cd10ed71106648d60a71dccb5679724cf3a11cee2	301610000000000000
831159	true	66433	{“info”:“31126464193144932769286071965”,“maker”:“0x0b3337b3274584208231c689e2c454d79b37b0f3”,“makerAsset”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“takerAsset”:“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“makingAmount”:“198757”,“takingAmount”:“302582000000000000”,“allowedSender”:“0xd8121433a2b8653b8eb62bd76273eaf104f9be09”}	198558	302280000000000000	0xd4239f02d7ac7f913e4b5213f04dbb70732746ecdb629cb1f2d2eb8d30407975	0x3eca9c0a	0x1111111254eeb25477b68fb85ed929f73a960582	44175920	0xd8121433a2b8653b8eb62bd76273eaf104f9be09	0x1c0ebde41db9d074bde55f01000ca55f78c5fe5485d810ebb9b2f30d1e2310f4da6f63f77ef1598e8988c937d57b21baf5a263a29a2fbe839bc2d7a31a756b1f38649334b5	0,1,1,1	2023-06-21T17:34:53.000Z	0x202c0c22a6d69e85a061e7d31291b6d0a13177985c0bb2ee24a3223560085dc7	302280000000000000

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrderRFQCompact_function

1inch AggregationRouterV5 function call records for executing RFQ (Request-For-Quote) orders with compact signature format. Contains order parameters including maker/taker assets and amounts, ECDSA signature components (r, vs), execution flags, and filled amounts for DEX aggregation trade tracking.

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_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_vs`	`STRING`	ECDSA signature component vs, which combines the recovery identifier v with the signature component s for compact signature representation. 66-character hex string including 0x prefix.
`in_flagsAndAmount`	`STRING`	Encoded integer combining order execution flags and token amount for RFQ (Request-for-Quote) orders. Numeric string representing a packed value where higher-order bits contain execution flags and lower-order bits contain the taking amount in the token’s smallest denomination.
`out_filledMakingAmount`	`STRING`	Amount of maker tokens actually filled in the RFQ (Request-for-Quote) order execution. Numeric string representing the quantity in the token’s smallest denomination.
`out_filledTakingAmount`	`STRING`	Amount of taker tokens actually filled in the RFQ (Request-for-Quote) order execution. Numeric string representing the quantity in the token’s smallest denomination.
`out_orderHash`	`STRING`	Unique identifier hash for the order being filled. 66-character hex string including 0x prefix.

Sample Data

gas	in_r	in_vs	value	status	gas_used	in_order	signature	to_address	block_number	from_address	out_orderHash	block_timestamp	transaction_hash	in_flagsAndAmount	out_filledMakingAmount	out_filledTakingAmount
163680			7321000000000000	false	29566		0x9570eeee	0x1111111254eeb25477b68fb85ed929f73a960582	52996462	0x7cb1768a4a123d7b3f381979c6720f18a919dd0e		2024-02-01T10:42:33.000Z	0xcd117bb435a27d4ace9a445375dd8a54e641560d1c5ca46e94a390e691a9754e
163692			500000000000000000	false	29578		0x9570eeee	0x1111111254eeb25477b68fb85ed929f73a960582	53016638	0x5246c4c384c791e30cd40a786ca5ca7612ccd6b1		2024-02-01T23:20:58.000Z	0x2c2ca3772d46fb079e9212f90fac624c2149498d425f9e055fb2b62db35574f2
146568	0xb1345a8eade66da4264675e997c22f082c5c7d1bc96e1a80f84d07699edd548e	0x53283c03ccf80fa635d37adb7172489169656e348cf5893be1ce001d9b259414	6321000000000000	true	113832	{“info”:“31484611824513189784215367896”,“maker”:“0xff8ba4d1fc3762f6154cc942ccf30049a2a0cec6”,“makerAsset”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“takerAsset”:“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“makingAmount”:“4935”,“takingAmount”:“6321000000000000”,“allowedSender”:“0x7cb1768a4a123d7b3f381979c6720f18a919dd0e”}	0x9570eeee	0x1111111254eeb25477b68fb85ed929f73a960582	52996486	0x7cb1768a4a123d7b3f381979c6720f18a919dd0e	0xbc16bc8c07ab6ec5f0e51c761a0add67d2be3acb4bfa69d9bd7818f5ef9126b3	2024-02-01T10:43:39.000Z	0x1dd2959a5439beb82504f0c6e49ac28cbc7c4d7b26e46d690c3b911cca73fe61	7237005577332262213973186563042994240829374041602535252466105321494570602496	4935	6321000000000000

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrderRFQTo_function

1inch AggregationRouterV5 function call data for executing RFQ (Request-for-Quote) orders with a specified recipient address. Records maker/taker asset pairs, token amounts, cryptographic signatures, and execution results for decentralized exchange limit orders.

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_flagsAndAmount`	`STRING`	Encoded integer combining order execution flags and token amount for RFQ (Request-for-Quote) orders. Numeric string representing a packed value where higher-order bits contain execution flags and lower-order bits contain the taking amount in the token’s smallest denomination.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`out_filledMakingAmount`	`STRING`	Amount of maker tokens actually filled in the RFQ (Request-for-Quote) order execution. Numeric string representing the quantity in the token’s smallest denomination.
`out_filledTakingAmount`	`STRING`	Amount of taker tokens actually filled in the RFQ (Request-for-Quote) order execution. Numeric string representing the quantity in the token’s smallest denomination.
`out_orderHash`	`STRING`	Unique identifier hash for the order being filled. 66-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	in_order	in_target	signature	to_address	block_number	from_address	in_signature	out_orderHash	trace_address	block_timestamp	transaction_hash	in_flagsAndAmount	out_filledMakingAmount	out_filledTakingAmount
1526244	true	48877	{“info”:“31371606830509970406007375336”,“maker”:“0xbad9ada0e9633ed27fa183dbdeceef76712a6ee1”,“makerAsset”:“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“takerAsset”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“makingAmount”:“3197145737141816918016”,“takingAmount”:“2448864182”,“allowedSender”:“0xce9cc1fa6df298854f77e92042fd2a3e7fb27eff”}	0xad3b67bca8935cb510c8d18bd45f0b94f54a968f	0x5a099843	0x1111111254eeb25477b68fb85ed929f73a960582	50252936	0xce9cc1fa6df298854f77e92042fd2a3e7fb27eff	0x1b7084456a98dc8cd8278f085b878146b5842b50afd1d8c87a68c34507571287841dfeaf59dc10265ca82d85161f3e4a8e2a01c31f1506e1ae23636fc73fe2d888	0x9a13e7b427591bfa162d5ea99849c8d103ce8260eb0aec3ce593477ab51fc69c	1,1,2,0,0,1,1,2,0,1	2023-11-22T13:01:39.000Z	0x71307a788d2d8b2044ad7c3d9927ebfad61daf9b5ffd7e92adbdd4a5b6e1b42e	2448864182	3197145737141816918016	2448864182
234463	true	83558	{“info”:“31032367130264011461978230052”,“maker”:“0x0b3337b3274584208231c689e2c454d79b37b0f3”,“makerAsset”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“takerAsset”:“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“makingAmount”:“20231837”,“takingAmount”:“20020000000000000000”,“allowedSender”:“0x56f9c3982925f3867b1636d4aeb9ca63c9f7b2e3”}	0x5ce7c6533c6a74842386ba744b1278640460d6f8	0x5a099843	0x1111111254eeb25477b68fb85ed929f73a960582	41871126	0x56f9c3982925f3867b1636d4aeb9ca63c9f7b2e3	0x1b134e8fbbd1897c36b2bdac567803c18299e11ea868d9f16455bb5e4fbfe0913629d0adbfad95813a16fde4371e94e62793e0ab843ddfdd80e44f2d313e47f0d664455ee1	0x3f7307132fe299a314f5ec79f57ddd4115d7d6e5c7d23d2c343fe75e3430bb4f	0,1,1,1	2023-04-23T16:38:06.000Z	0x16c0ebd89244fc5d1c6910d04e7088bf3e6e716759eefbfb318fccb6a8e7c18e	20000000000000000000	20211625	20000000000000000000
235724	true	57458	{“info”:“31032197364878301112974705179”,“maker”:“0x0b3337b3274584208231c689e2c454d79b37b0f3”,“makerAsset”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“takerAsset”:“0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270”,“makingAmount”:“1229475”,“takingAmount”:“1207136000000000000”,“allowedSender”:“0xb97cd69145e5a9357b2acd6af6c5076380f17afb”}	0x8acdb3bcc5101b1ba8a5070f003a77a2da376fe8	0x5a099843	0x1111111254eeb25477b68fb85ed929f73a960582	41866994	0xb97cd69145e5a9357b2acd6af6c5076380f17afb	0x1cc62e84bd2c8adac61fbd148ee70148f26e4390164d357ed8dbd05e54de49621f74923d75a00432b8a5c6fa14ffdd5b08b49c444e1ed69785992af4d77173fd3a64453aee	0x757dd0f4ea3ed8e2b434a07d03f389422df67ad6260c13bc694a8f55f53efb25	1,1,2,0,0,1,1,1	2023-04-23T14:04:35.000Z	0x819448f680e74732b7d78dcc66b93a4c7b3817e1b1eb9dd1b4e484c2461496d0	1184499559586170097	1206419	1184499559586170097

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrderRFQToWithPermit_function

1inch Aggregation Router V5 function call data for executing Request-for-Quote (RFQ) orders with EIP-2612 permit signatures and custom recipient addresses. Records token swap executions including maker/taker asset details, amounts, execution flags, and cryptographic signatures authorizing gasless approvals and order settlement.

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_flagsAndAmount`	`STRING`	Encoded integer combining order execution flags and token amount for RFQ (Request-for-Quote) orders. Numeric string representing a packed value where higher-order bits contain execution flags and lower-order bits contain the taking amount in the token’s 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.
`out_anon2`	`STRING`	Unique identifier hash for the executed order. 66-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	in_order	in_permit	in_target	out_anon0	out_anon1	out_anon2	signature	to_address	block_number	from_address	in_signature	block_timestamp	transaction_hash	in_flagsAndAmount
213931	true	170260	{“info”:“31085307035252780887865693591”,“maker”:“0xce8bfa6d1084b09d1765342974539cbaf0d761cc”,“makerAsset”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“takerAsset”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“makingAmount”:“43608662”,“takingAmount”:“43622870”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x000000000000000000000000d064fa13b828e335171fb43252b65d4f657e9da40000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064727aa2000000000000000000000000000000000000000000000000000000000000001c4930bc72f0c6efdf59b0e15eb96cd0ec6c067ea7fd5f242e1221e5aca6fbccce66d568d5ecf242fa9ab162d3bc2ae940eb175253f05ba1785c5fdaa666d36dfd	0xd064fa13b828e335171fb43252b65d4f657e9da4	43608662	43622870	0xadd2d7ffd1aa245424c43070da92f8aeef3de774e97b1164083fc8f9681ffb8e	0x70ccbd31	0x1111111254eeb25477b68fb85ed929f73a960582	43185761	0xd064fa13b828e335171fb43252b65d4f657e9da4	0x6da2f47a345a752d42979e49fcd64152378088a93a365893119b7e9e226d88254fad538568378df5852c9f25052e80b9569235935767b57c104fecb89462aadf1b	2023-05-26T21:48:52.000Z	0xd38387b01f5b7a76adfa1cdbd56b6f901d3db1070c68d63dd454d86441b25193	43622870
213911	true	170240	{“info”:“31097508578780103904690620209”,“maker”:“0xce8bfa6d1084b09d1765342974539cbaf0d761cc”,“makerAsset”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“takerAsset”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“makingAmount”:“54089649”,“takingAmount”:“54105881”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x000000000000000000000000215132e91ab203fa263cb831cfa0be1555049f250000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000647c927b000000000000000000000000000000000000000000000000000000000000001b4a59dba9919ffbae127e279380ac4ec629e7bfdff6aa257abd534e70c370a8eb30eb0f31eb32fa9d956403d6f5d7fa1e901f8528164b621c826a82efd7ec85dd	0x215132e91ab203fa263cb831cfa0be1555049f25	54089649	54105881	0x384fd561cfc6fd4810f9f221277a9c7197e7c691c815bd2a6d8f33d351dc5c3f	0x70ccbd31	0x1111111254eeb25477b68fb85ed929f73a960582	43482453	0x215132e91ab203fa263cb831cfa0be1555049f25	0xc5f6d20ea326dc39f2e0f25175cd37246d250d1bf209687a02d0b4c5df9e9c585a50df8fb8e028d72b130a5232323c20a77df801a3225d25a697c86333ab68e11b	2023-06-03T13:32:56.000Z	0x49316f1b1047dcd3a30b068b2eae5f718de77a3d56b83477b3a1965374d8b036	54105881
213895	true	170224	{“info”:“31081562918054884157825225691”,“maker”:“0xce8bfa6d1084b09d1765342974539cbaf0d761cc”,“makerAsset”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“takerAsset”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“makingAmount”:“27450086”,“takingAmount”:“27455578”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x0000000000000000000000000e51447bd39e54dad100f119dbb8ff15be541af20000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000646f61ea000000000000000000000000000000000000000000000000000000000000001c267541c96b51c33f9f6686b7295868398bd9f85f8ea76189ffba88dfbc75409b2c2e9d052c9b7ef48858c9cf22a1f5cbf53bf6d31d7f5a06aa837e4d31dfc269	0x0e51447bd39e54dad100f119dbb8ff15be541af2	27450086	27455578	0xcc27a0aeea5f23f610edad02038b118cba757404e2542bc6ca898aaad3512974	0x70ccbd31	0x1111111254eeb25477b68fb85ed929f73a960582	43092264	0x0e51447bd39e54dad100f119dbb8ff15be541af2	0x2e859ecd31a38ba2f2bba79a2b8827090c0340fae696b7b8bbcf0547d73773b8101cc9008e015cd73409459be10a567824ddc36969f071ffae19de56b48f86381b	2023-05-24T13:26:07.000Z	0x59f347604fb53233e8ccb5614ce47f2451a37490cfea75ba0013c1d6a7707259	27455578

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrderTo_function

Decoded function calls to the 1inch AggregationRouter V5 fillOrderTo method, which executes Request-For-Quote (RFQ) limit orders by matching maker and taker positions with cryptographic signature verification. Contains order parameters including token pairs, amounts, recipients, and settlement data for DEX aggregation analytics.

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<salt STRING, makerAsset STRING, takerAsset STRING, maker STRING, receiver STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING, offsets STRING, interactions STRING>`	Structured order parameters defining the maker-taker exchange agreement in 1inch RFQ orders. Contains salt for uniqueness, maker and taker asset addresses, participant addresses (maker, receiver, allowedSender), token amounts (makingAmount, takingAmount), offsets for bitfield encoding, and interactions for custom execution logic.
`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_interaction`	`STRING`	Encoded data for custom interactions executed during order fulfillment. Hex-encoded byte string, typically 0x-prefixed.
`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_skipPermitAndThresholdAmount`	`STRING`	Bitfield parameter combining permit-skipping flag and minimum threshold amount for order execution. Numeric string encoding both a boolean flag (in the highest bit) to skip EIP-2612 permit processing and a threshold amount (in remaining bits) specifying the minimum acceptable taking amount.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`out_actualMakingAmount`	`STRING`	Actual amount of maker tokens transferred in the order execution. Numeric string representing the token quantity in its smallest denomination.
`out_actualTakingAmount`	`STRING`	Actual amount of taker tokens transferred in the order execution. Numeric string representing the token quantity in its smallest denomination.
`out_orderHash`	`STRING`	Unique identifier hash for the order being filled. 66-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	in_order_	in_target	signature	to_address	block_number	from_address	in_signature	out_orderHash	trace_address	in_interaction	block_timestamp	in_takingAmount	transaction_hash	out_actualMakingAmount	out_actualTakingAmount	in_skipPermitAndThresholdAmount
268180	true	69476	{“salt”:“1434653700543”,“maker”:“0x44034e2261ede365b20eb18b109ca3698c19ddc9”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x2791bca1f2de4661ed88a30c99a7a9449aa84174”,“takerAsset”:“0x263fa8f30351472a1363902318098befad3b440e”,“interactions”:“0xbf15fcd8000000000000000000000000a5eb255ef45dfb48b5d133d08833def69871691d000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d00652d25170000000000000044034e2261ede365b20eb18b109ca3698c19ddc900000000000000000000000000000000000000000000000000000000”,“makingAmount”:“20000000”,“takingAmount”:“50000000000000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x6bfce69d1df30fd2b2c8e478edec9daa643ae3b8	0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	48713661	0x5f515f6c524b18ca30f7783fb58dd4be2e9904ec	0x382f4aaf4f37dbafa31fafd2d41fd243e8c1059defcf26c67556dbded9558df2e71b74a0ec8951fc6ad038ec43c3e53535076efe02c460e6cc0c915ff5e11bf6	0x7181cd5a38500e98d3abc8fa926408b2a7f8ea9bd07158b74b4ad3e9289b89c3	1,1,1	0x	2023-10-14T16:12:21.000Z	971877467872500000	0xc10562dc9c73568b381c5b8a3a3a476f37cf41deb8cb6031c3be51086de87369	388750	971877467872500000	57896044618658097711785492504343953926634992332820282019728792003956565204830
740683	true	102927	{“salt”:“136807925170”,“maker”:“0x9b418ca3c64d8f16f6e2101cf96becd9aa0a61a4”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“takerAsset”:“0x13efaa3d5e2c86e7aba168f925fef9827648cff4”,“interactions”:“0xbf15fcd8000000000000000000000000a5eb255ef45dfb48b5d133d08833def69871691d000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d00652d4644000000000100009b418ca3c64d8f16f6e2101cf96becd9aa0a61a400000000000000000000000000000000000000000000000000000000”,“makingAmount”:“683473124”,“takingAmount”:“48507673811213620000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x4db1087154cd5b33fa275a88b183619f1a6f6614	0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	48691415	0xe37e799d5077682fa0a244d46e5649f71457bd09	0x868136d98d2cce38f720fcd784308a408f04880ac5f657d6f71be992932d43acc04f86b7f82f3e4e9963fcc9f5f12bcf0a2f934e6c4d3c38095ef9709b84c9da	0xa46ef1e4be94ba5cf2f03a05a44fed4ecbcedd3aac3994b1df247c08c32ee3d7	1,0,1,1,0,1	0x	2023-10-14T02:25:06.000Z	100000000000000000000	0x1e3a8ddb457052f8a115ff0ade18a587b5e71b25ee81a2d1b7c02ea2b382e07f	1409000	100000000000000000000	57896044618658097711785492504343953926634992332820282019728792003956566200788
205499	true	62438	{“salt”:“294748004431”,“maker”:“0xb0d0b2d1f7edbe7b591bdd58dd869ccf6c1a5112”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“takerAsset”:“0x431d5dff03120afa4bdf332c61a6e1766ef37bdb”,“interactions”:“0xbf15fcd8000000000000000000000000a5eb255ef45dfb48b5d133d08833def69871691d000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d006532759200000000210000b0d0b2d1f7edbe7b591bdd58dd869ccf6c1a511200000000000000000000000000000000000000000000000000000000”,“makingAmount”:“2000000000”,“takingAmount”:“301600000000000000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x690a87ed8972e451e755b8f2dc1fc2b28e3c6566	0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	48687654	0xe37e799d5077682fa0a244d46e5649f71457bd09	0x035588f184d65f73e60da72b79f59df95fc5e50bbde25efff12c774ddf0e2f3ce02b7124eddb3d7de3239643790e748e66168a173172d8c05dd0a985aeee7c46	0x3abc10466690c776a223aa019c2351148699bdd74749bf2a208246a4c84efd54	1,0,1,1,0,1	0x	2023-10-14T00:05:24.000Z	200000000000000000000	0x3d728bf69603a3a705202be25e6dc253d29eb9cff19dac580a0882e1347d5014	1326259	200000000000000000000	57896044618658097711785492504343953926634992332820282019728792003956566119701

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrderToWithPermit_function

1inch AggregationRouterV5 function calls for executing Request-for-Quote (RFQ) orders with EIP-2612 permit signatures for gasless token approvals. Contains order parameters, maker/taker token amounts, and custom interaction data for decentralized exchange order fulfillment.

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<salt STRING, makerAsset STRING, takerAsset STRING, maker STRING, receiver STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING, offsets STRING, interactions 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_interaction`	`STRING`	Encoded data for custom interactions executed during order fulfillment. Hex-encoded byte string, typically 0x-prefixed.
`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_skipPermitAndThresholdAmount`	`STRING`	Bitfield parameter combining permit-skipping flag and minimum threshold amount for order execution. Numeric string encoding both a boolean flag (in the highest bit) to skip EIP-2612 permit processing and a threshold amount (in remaining bits) specifying the minimum acceptable taking amount.
`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.
`out_anon2`	`STRING`	Unique identifier hash for the executed order. 66-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	in_order	in_permit	in_target	out_anon0	out_anon1	out_anon2	signature	to_address	block_number	from_address	in_signature	in_interaction	block_timestamp	in_takingAmount	transaction_hash	in_skipPermitAndThresholdAmount
243811	true	209000	{“salt”:“164861784439”,“maker”:“0x69f4df8be69d78e58c891515e3cc4f21dac4a12f”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0xc2132d05d31c914a87c6611c10748aeb04b58e8f”,“takerAsset”:“0x4e78011ce80ee02d2c3e649fb657e45898257815”,“interactions”:“0xbf15fcd8000000000000000000000000a5eb255ef45dfb48b5d133d08833def69871691d000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d006b4c50f4000000000b000069f4df8be69d78e58c891515e3cc4f21dac4a12f00000000000000000000000000000000000000000000000000000000”,“makingAmount”:“5000000”,“takingAmount”:“28089887640”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x4e78011ce80ee02d2c3e649fb657e4589825781500000000000000000000000062ea37684ad11de12f52711270eca8947ac1810b0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000065bf47ba000000000000000000000000000000000000000000000000000000000000001cc3696c301afb45a84a83d6fd573aa1b8372bfe440ec5fcb07899c56aa61efa702f9da05f009b97e9fe6b179adca50162809dcb0c7e531257245cdc5197022467	0x62ea37684ad11de12f52711270eca8947ac1810b	2118	11902160	0xf095d56f23172e7849bbb5cda5a671f47d8bef92d0eaed7d3560eb2e1b1c847f	0xd365c695	0x1111111254eeb25477b68fb85ed929f73a960582	53068687	0x62ea37684ad11de12f52711270eca8947ac1810b	0xe01b431333f13f48cae189693e10ddee2669cd91d59743e56ac2953f928a7ca419087c9a23d0d1df95f8b391af07a97e9dcf114d05aa7fa08a6a2022a05d54a01c	0x	2024-02-03T08:16:48.000Z	11902160	0xcbe638c1e4e7b92adb55a70140bdfabf46a1ae56c853366e612db1c01a8ec23f	57896044618658097711785492504343953926634992332820282019728792003956564822075
259226	true	229215	{“salt”:“1094264207032”,“maker”:“0x23fb3bcaac118f982148d6c10e1df21ef8707323”,“offsets”:“10999658242758518544858200575235826098314820141922551501270029527154688”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x2bc07124d8dac638e290f401046ad584546bc47b”,“takerAsset”:“0x4e78011ce80ee02d2c3e649fb657e45898257815”,“interactions”:“0xbf15fcd8000000000000000000000000a5eb255ef45dfb48b5d133d08833def69871691d000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d0064cf93e50000000019000023fb3bcaac118f982148d6c10e1df21ef8707323000000000000000000000000000000000000000000000000000000002bc07124d8dac638e290f401046ad584546bc47b00000000000000000000000023fb3bcaac118f982148d6c10e1df21ef87073230000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064cf93e1000000000000000000000000000000000000000000000000000000000000001bead7c151476880496d7c59d2494f3a55b4d3bc42b2b259aa7537fa80387fe2d76914b8ac602308017ea5e0c9b34c090283fa82c3608c77e619b379abb617c2fd”,“makingAmount”:“2000000000000000000”,“takingAmount”:“2000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x4e78011ce80ee02d2c3e649fb657e45898257815000000000000000000000000633a626e57939810033358a5fcc0768f44457f410000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064c7ab94000000000000000000000000000000000000000000000000000000000000001c0ab3d2f3512dcd8405d52a9227f10af22be075aad50b712d225bac3777229ec734faec9e9d93b89b1335e2bb496675e2948055a430127c8671a13bb26ee43c17	0x633a626e57939810033358a5fcc0768f44457f41	2000000000000000000	2000000000	0x97a7562fcb3382bc7841bd80939974ba68e988c0f1965d7b57ae52452cfcddf6	0xd365c695	0x1111111254eeb25477b68fb85ed929f73a960582	45700247	0x633a626e57939810033358a5fcc0768f44457f41	0xbb8f16ecd4e20c84e0e0750e125f50aa1d0fa301f22502f0251474878b788430152ba8a73bf43403248f8030d6cf42c2c9adb8b642d2defd4548738088087b721b	0x	2023-07-30T12:40:06.000Z	2000000000	0xe634110d57e712574df8067c2cd804f901c5b00a9a00acdc7b92f4ecc9b5d226	1990000000000000000
402799	true	367079	{“salt”:“322227078528”,“maker”:“0x3b608c5243732903152e38f1dab1056a4a79b980”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x29f1e986fca02b7e54138c04c4f503dddd250558”,“takerAsset”:“0x1a13f4ca1d028320a707d99520abfefca3998b7f”,“interactions”:“0xbf15fcd8000000000000000000000000a5eb255ef45dfb48b5d133d08833def69871691d000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d0064cf8835000000000b00003b608c5243732903152e38f1dab1056a4a79b98000000000000000000000000000000000000000000000000000000000”,“makingAmount”:“5000000000”,“takingAmount”:“5000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x1a13f4ca1d028320a707d99520abfefca3998b7f000000000000000000000000633a626e57939810033358a5fcc0768f44457f410000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064c79f60000000000000000000000000000000000000000000000000000000000000001c992fc07240c6eb3f3679652ad477ba077b7de4f64a7939b38e5d4ce46ee7ee5c5e8d3ab9793b5e26b12e12e47a4e64bcad7b5371259922c3984d44f4809d02cc	0x633a626e57939810033358a5fcc0768f44457f41	5000000000	5000000	0x9c8b935cdec5766103f6d4f9caad2da689de5863c325db62defaf67ec64db625	0xd365c695	0x1111111254eeb25477b68fb85ed929f73a960582	45698777	0x633a626e57939810033358a5fcc0768f44457f41	0xbf4745c2ceee28c38ea1fdaedd96d030a582ec371b84299ecce6c7d198e6304e30d1ad4a17a990a84be969fa73dd4c3a46ed7617bf1a24a38d1a54ebdf07bedb1c	0x	2023-07-30T11:48:02.000Z	5000000	0x0249c854ed00216d79d3fffe98b6df71280bb1504c5253408f596a3eab39c48f	57896044618658097711785492504343953926634992332820282019728792003961539819968

Example Query

Query with partition filter

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

AggregationRouterV5_OrderFilled_event

Order execution events from 1inch AggregationRouterV5 contracts containing maker address, order hash, and remaining unfilled amount. Used for tracking limit order fills and partial order completion across decentralized exchange aggregation.

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_maker`	`STRING`	Address of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
`in_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_remaining`	`STRING`	Remaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.

Sample Data

address	removed	in_maker	log_index	block_number	in_orderHash	in_remaining	block_timestamp	transaction_hash
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x01dabe7354db4d0c8ae8442a48f2cb3757d14a70	240	45305514	0x5e767ba180ac8c8725e5bd1d911cb930aaabd833e004748ff1bf07a11f081750	168775106877000000000	2023-07-20T13:38:06.000Z	0x009cabdfd03804eca0cb21f98dca8243299ee16f716f57ed2c5b0da646e88bfb
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x01dabe7354db4d0c8ae8442a48f2cb3757d14a70	65	45305525	0x5e767ba180ac8c8725e5bd1d911cb930aaabd833e004748ff1bf07a11f081750	0	2023-07-20T13:38:30.000Z	0xc7a7d125e3bafabe83797a4320d0c7aee093651df2ada588cc7e389cf6d72bec
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x01dabe7354db4d0c8ae8442a48f2cb3757d14a70	397	45295681	0x5d66211604e6783cf065f9bbefadf20309664edf474b914df98111daea00c019	0	2023-07-20T07:42:25.000Z	0x9b8e849adac31c44383f10941ac45bae4bda2d8b44631a6ddeecf107016c0f26

Example Query

Query with partition filter

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

AggregationRouterV5_OrderFilledRFQ_event

RFQ (Request for Quote) order execution events emitted by 1inch AggregationRouterV5 contracts. Records order hash and maker token amount for off-chain quoted orders filled on-chain.

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
0x1111111254eeb25477b68fb85ed929f73a960582	false	6	52458173	0x052037a1136e249f2bb4276d11dced934e451a84d876e51c8d91ac677d47bd19	2024-01-18T06:08:18.000Z	200043	0xbbe931200b74c3f7b897bdaa7e8631c6a519b9ac07b27f3394a8be0d02f8aaa6
0x1111111254eeb25477b68fb85ed929f73a960582	false	6	52472346	0x862869292ea687d4b89826241001cddd7eaac93a30ad24b1c036fba272197144	2024-01-18T15:05:40.000Z	769845900	0x1fc518d3bc33a6cb7951713888923a08921ceaf646e0af32e9cbac72b49a081e
0x1111111254eeb25477b68fb85ed929f73a960582	false	6	52484696	0xd66457a18ebcf288eed85bd618251ff6fbdd1e45dad9a0f01482bad6c944a3ae	2024-01-18T23:08:24.000Z	563350945	0xb479143a3b78d430c3a886595bd0bc4bcee7bd6c455c4633c1eb59e6913ab0cf

Example Query

Query with partition filter

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

AggregationRouterV5_swap_function

Decoded function calls to the 1inch AggregationRouterV5 swap method containing source and destination token addresses, swap amounts, executor contract, and optional EIP-2612 permit signatures. Used for tracking token swap executions and analyzing DEX aggregator routing efficiency.

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_executor`	`STRING`	Address of the executor contract responsible for processing cross-chain message delivery. Hex-encoded, 0x-prefixed, 42-character string.
`in_desc`	`STRUCT<srcToken STRING, dstToken STRING, srcReceiver STRING, dstReceiver STRING, amount STRING, minReturnAmount STRING, flags 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_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).
`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_spentAmount`	`STRING`	Amount of source tokens consumed by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
613130	0	false	151349	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	60908081	0xb80d90fcf2ed0e4febe02d2a209109bf1f62df95	2024-08-22T16:47:03.000Z	0x175521926f9dc3fe7b2a88cf8bcf2b7c630753d192d51e0e2384648623dfd637
400000	4021312958681009000	false	247783	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	60883352	0x0fab48b45635a0376f1a8c5cc16c445842e13f05	2024-08-22T02:09:35.000Z	0x4ffe520dc49a3ac027e302e5abeb7ab569d3aa4fdb4925e8dfa2d275e88b4df7
783244	0	false	348232	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	60910426	0xb80d90fcf2ed0e4febe02d2a209109bf1f62df95	2024-08-22T18:10:40.000Z	0x27eee00f97a5bafe6ca5706627653c97b70103d801215eef99aefdfa7ec00dd0

Example Query

Query with partition filter

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

AggregationRouterV5_uniswapV3Swap_function

Decoded function calls to 1inch AggregationRouterV5’s uniswapV3Swap method, which executes token swaps routed through Uniswap V3 pools. Contains input amounts, minimum return thresholds, encoded pool routing data, and actual return amounts for analyzing 1inch swap execution and slippage.

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	value	status	gas_used	in_pools	in_amount	signature	to_address	block_number	from_address	in_minReturn	block_timestamp	out_returnAmount	transaction_hash
133358	0	true	116288	[“57896044618658097711785492504649377906813852248189387887312022063541786289596”]	2205517525518656091	0xe449022e	0x1111111254eeb25477b68fb85ed929f73a960582	48695544	0xedfdfe82233953fe2af3983167303814a1bc7bde	5613349923183168	2023-10-14T04:52:21.000Z	5727908084880784	0xc3da0343126ec2c176b120c422b3dcd16d01a2bc8a983bcd68d0e1302b1276f4
182439	98472986228166850000	true	121805	[“28948022309329048855892746253057052470967361465366573038368047514100529879223”]	98472986228166857882	0xe449022e	0x1111111254eeb25477b68fb85ed929f73a960582	48688753	0xccf00d91b1a87df4372ac0b63ec730275f02e603	50803258	2023-10-14T00:46:05.000Z	51058551	0x1c9a5d033f3a42487efb2f2b8686938998a5caae8661f7205cf31d7bbf7385b0
141273	0	true	110062	[“57896044618658097711785492505114352005170927192396598604866737469034229799136”]	1288884019771480832	0xe449022e	0x1111111254eeb25477b68fb85ed929f73a960582	48712494	0x3f343211f0487eb43af2e0e773ba012015e6651a	3852104947689132654592	2023-10-14T15:27:23.000Z	3853355896193762182257	0x65c2f17969752f0959c90f7af765bfb34cb6ca6c8f6d065e37ea7c023472ef3c

Example Query

Query with partition filter

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

AggregationRouterV5_uniswapV3SwapCallback_function

Decoded function calls to the Uniswap V3 swap callback handler within the 1inch AggregationRouterV5 contract, containing token delta amounts and contextual swap data. Used for tracking DEX aggregator interactions with Uniswap V3 liquidity pools.

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
92296	false	4617		0xfa461e33	0x1111111254eeb25477b68fb85ed929f73a960582	38421871	0x59db5ea66958b19641b6891fc373b44b567ea15c	0,6,0,2	2023-01-23T08:21:05.000Z			0x1cbd9b5c66212da02033409006942f5b078f4b71ed7177fc323beb6ed14c9909
72860	true	8536	0x0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582	0xfa461e33	0x1111111254eeb25477b68fb85ed929f73a960582	38433350	0xe6c36eed27c2e8ecb9a233bf12da06c9730b5955	0,0,0,1,2	2023-01-23T15:08:22.000Z	1982500000000000000	-11188334112003815395	0x2aa8a9e02925422ff59a27cbd5127e106d296b2f24ebb855ed893e7aec8057c1
73317	true	8536	0x0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582	0xfa461e33	0x1111111254eeb25477b68fb85ed929f73a960582	38434162	0xe6c36eed27c2e8ecb9a233bf12da06c9730b5955	0,0,0,1,2	2023-01-23T15:37:11.000Z	29737500000000000000	-166827064230691242142	0x7aba72319741f23efa242bdf62d6c40ceceb2af3024c1a0b8a1c7d15a51f1376

Example Query

Query with partition filter

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

AggregationRouterV5_uniswapV3SwapTo_function

Decoded function calls to the 1inch AggregationRouterV5 contract’s uniswapV3SwapTo method, which executes token swaps through Uniswap V3 pools. Contains input parameters including swap amounts, minimum return thresholds, encoded pool routing data, and recipient addresses, along with transaction execution metadata and actual return 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
420241	true	264105	[“72370055773322622139731865630489446853753925406754960381812139178713403901427”]	1693629	0xbc80f1a8	0x1111111254eeb25477b68fb85ed929f73a960582	37895184	0x81ab6fd4a68d0addfad65f9f97bc1427dcd40c8e	1938111911878325534	0x10a4ba988936117e86188f4b42e8bc00fb12b552	2023-01-10T08:44:04.000Z	1998259523536782694	0x98a8ef018d1c973b99a92df9c0b24d04d258f69d6fa39651ce0e84fab977bcbf
254994	true	158316	[“72370055773322622139731865631363095597924122766500691413170753007076743867698”]	4403365	0xbc80f1a8	0x1111111254eeb25477b68fb85ed929f73a960582	37915013	0x81ab6fd4a68d0addfad65f9f97bc1427dcd40c8e	4998008427347680885	0x398c31171cf651de44cfed05b840188ff8f30cf9	2023-01-10T20:09:28.000Z	5152039755471151044	0x853b3a9bde6158d844c1a75f98a6459134268b8079c9435ef08876f94609ce17
214441	true	132393	[“72370055773322622139731865631363095597924122766500691413170753007076743867698”]	5562746	0xbc80f1a8	0x1111111254eeb25477b68fb85ed929f73a960582	37915944	0x81ab6fd4a68d0addfad65f9f97bc1427dcd40c8e	6301417827372717174	0xb67e954446f03f6df2c5c83edb0e2cd0e1977c0c	2023-01-10T20:41:26.000Z	6496976829954342896	0xcda98a736a69949691bbbb272a27d7a5d3915797981f12253efdde28667d1b2f

Example Query

Query with partition filter

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

AggregationRouterV5_uniswapV3SwapToWithPermit_function

1inch AggregationRouterV5 function calls that execute Uniswap V3 swaps with EIP-2612 permit signatures for gasless token approvals. Records source token, swap amounts, minimum return thresholds, routing pool identifiers, recipient addresses, and permit signature data for multi-hop DEX aggregation trades.

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
913252	true	228313	[“57896044618658097711785492504446695284574665124387967726599110745426416475047”,“72370055773322622139731865631363095597924122766500691413170753007076743867698”]	93000000000000000000	0x0000000000000000000000008bb5e5f6799245cb129e430b5e84680933903ed30000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064357195000000000000000000000000000000000000000000000000000000000000001ca290fddddcdf8b8b3e10d8d6a224be02ddb8437b5a42ccba2a15c860318c7fa71ac4d57695f420fe676546398438293f4665295ccf57863c0706809c6309115d	0x2521b930	0x1111111254eeb25477b68fb85ed929f73a960582	0x4e3decbb3645551b8a19f0ea1678079fcb33fb4c	41371181	0x8bb5e5f6799245cb129e430b5e84680933903ed3	91861925697772482585	0x8bb5e5f6799245cb129e430b5e84680933903ed3	2023-04-10T14:42:54.000Z	91953865216305780941	0x5d51f0da9c63e8983bd837f80f385e7567724f087cad663117a03ef08ba9762f
238027	true	175273	[“977918666274170476906436560178185763027389093881”]	625517398245018392715	0x000000000000000000000000d0b53c43d3e0b58909c38487aa0c3af7dfa2d8c00000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064785c84000000000000000000000000000000000000000000000000000000000000001ba83442961d7ce0d0ebe9e465303ae5fa1d64a3f3cda5c13642809922ebc61f1408712281ced0cc5a11dc8c926c7f153e4c8c32db6536a9c9c0c59e54f19841d9	0x2521b930	0x1111111254eeb25477b68fb85ed929f73a960582	0xb0b195aefa3650a6908f15cdac7d92f8a5791b0b	43361630	0xd0b53c43d3e0b58909c38487aa0c3af7dfa2d8c0	622158874	0xd0b53c43d3e0b58909c38487aa0c3af7dfa2d8c0	2023-05-31T08:53:52.000Z	625285302	0x9880d7251b2827ab7439105560fd3254fa4d333656bfd61b5c206ba0ea1c495b
244450	true	184607	[“72370055773322622139731865631363095597924122766500691413170753007076743867698”]	10000000	0x000000000000000000000000730a35d2d7dfc04926ee8d86d578222ef33aec670000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000006477e29c000000000000000000000000000000000000000000000000000000000000001cdef1c37afedd75fa89f7c23803555a51b9e85de92623dd2f3464bdc6dc0123b40c336362e89a58fa635a424c790dfb41a40c037d1e77d99252cb718c2291c7b5	0x2521b930	0x1111111254eeb25477b68fb85ed929f73a960582	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	43347146	0x730a35d2d7dfc04926ee8d86d578222ef33aec67	11054970649481774164	0x730a35d2d7dfc04926ee8d86d578222ef33aec67	2023-05-31T00:13:50.000Z	11110523265810828306	0xdcecefe2e9f0e4ac6a9be216d5a11a5939cd243ac9179ff86d07a3ec62c8c13e

Example Query

Query with partition filter

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

AggregationRouterV5_unoswap_function

Function calls to the unoswap method on 1inch AggregationRouterV5 contracts, containing swap parameters including source token, input amount, minimum return requirements, and encoded pool routing paths. Records both successful and failed token swap executions across DEX aggregation routes.

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	value	status	gas_used	in_pools	in_amount	signature	to_address	in_srcToken	block_number	from_address	in_minReturn	block_timestamp	out_returnAmount	transaction_hash
160691	272339872090126700	false	23152	[]		0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582		55962146	0xdbcc17a164f9b057cd95a756ddd8254d35c0885b		2024-04-18T09:34:58.000Z		0x581b2f4a43018d7496f4717d93030aff683ac99ab9530b3cff87af516414b878
160691	300988411780980740	false	23152	[]		0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582		55973682	0xdbcc17a164f9b057cd95a756ddd8254d35c0885b		2024-04-18T16:34:59.000Z		0x59cddc53315371df47fe8ccb7c8033c7a7c6c344cfa80abfa45dc94e8dfcb1e3
132994	13838865630756512	true	91919	[“1457117132968448812760543383986736523738438067856978444739”]	13838865630756512	0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	55964073	0x9b56ce59fb178c742a53946158b0bf4db25d312b	9035	2024-04-18T10:43:12.000Z	9204	0x86979de38dd24afa71dec610a31b784e94dd58fca8a185cf83dbd279470638a1

Example Query

Query with partition filter

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

AggregationRouterV5_unoswapTo_function

Decoded function call data for the unoswapTo method on 1inch AggregationRouterV5 contracts. Captures token swap executions including source token, input amount, slippage parameters (minimum return), routing path through liquidity pools, recipient address, and actual output amount returned from the swap.

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.
`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	in_recipient	trace_address	block_timestamp	out_returnAmount	transaction_hash
137595	true	76780	[“1457117132675617326391136372226590131013224018030117562152”]	994116	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	48612762	0xa2a42b7203b2dc0199b81039c6c4e1ef900e82a4	963982	0x4247551ed839a7ba4890f76b2b272b46572c186e	2	2023-10-12T02:23:51.000Z	993796	0xc70a1cd0efb4cc759260d450e91593668aa12f5002d59c21d3e5ceccf624e3e8
145957	true	85725	[“57896044618658097713245532641085327046022125181259692863194413228201210557048”]	995654	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	0xc2132d05d31c914a87c6611c10748aeb04b58e8f	48632023	0xa2a42b7203b2dc0199b81039c6c4e1ef900e82a4	965316	0x4247551ed839a7ba4890f76b2b272b46572c186e	2	2023-10-12T14:19:56.000Z	995172	0xf07c7bbae398c43f79e26abc08bc0693a9a5782f2981e25ae13196864b8a60f7
167256	true	113200	[“86844066927987146569136232791041398853266560125931779407737449362079290152572”]	4497821141170268	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	0x7ceb23fd6bc0add59e62ac25578270cff1b9f619	48621692	0xf951789c6a356bfbc3033648aa10b5dd3e9d88c0	13517299394931324516	0x591caf61c68cb47e56d5c30504a39061c79a7f57	0,1,0,2,1	2023-10-12T08:02:07.000Z	13638408462074546489	0x43395abf0962087ac71e4532efba71019f7241de2d01d1fe4dfaf183842da6c2

Example Query

Query with partition filter

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

AggregationRouterV5_unoswapToWithPermit_function

1inch AggregationRouterV5 token swap function calls with EIP-2612 permit signatures. Executes single-path (Uniswap-style) token exchanges with gasless approvals, routing through specified liquidity pools to a designated recipient.

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
191927	true	156013	[“1457117133128854655610460399912897627157812251304247072283”]	14000	0x000000000000000000000000c93023623be1c76453c86132a82407566b765a080000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000006569755a000000000000000000000000000000000000000000000000000000000000001b13173e7184f1e81d03e64341a2fd3310d25cd6f426a8bbbb61149459121f60e7171f2d75a0d3e30ca7001b7de45452e2cd3b7c74e4850a9b2fd45bc89e63aa71	0x3c15fd91	0x1111111254eeb25477b68fb85ed929f73a960582	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	50561520	0xc93023623be1c76453c86132a82407566b765a08	2303443083871394	0xc93023623be1c76453c86132a82407566b765a08	2023-11-30T05:56:12.000Z	2326710185728681	0xfac60386c433b3f54be5a9733fb07f64094b9af9602e9d23738d500f0cda0e20
217399	true	174923	[“86844066927987146569135355889565559110597835926659620375340241175681273251879”]	128388	0x000000000000000000000000e30fa6782ff88eec1bd40ec17c4cd5b80391d9b70000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000656945e0000000000000000000000000000000000000000000000000000000000000001c7dae4285675754050e942cc772b38a29caead00ed59b1505951941f47d1280c97456b7eb813f4900d92c2e245d6d00e114d74d698312f0413e447ea39ba8b194	0x3c15fd91	0x1111111254eeb25477b68fb85ed929f73a960582	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	50555827	0xe30fa6782ff88eec1bd40ec17c4cd5b80391d9b7	168929460332070115	0xe30fa6782ff88eec1bd40ec17c4cd5b80391d9b7	2023-11-30T02:34:19.000Z	169897986355156687	0xb7f5b9b8d2225ca946ba629f52e92ecaa1124fabc39be237619075a42bc41d7c
217423	true	174947	[“86844066927987146569135355889565559110597835926659620375340241175681273251879”]	3993603	0x0000000000000000000000008158458e59cab1daa6400da8f7186a8e53ddca4b0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000656a60a4000000000000000000000000000000000000000000000000000000000000001c5df3583ad24d1ecefd2b46f5c1602d5b302485ada85270bcd5c6313dd597ef530b658f74ed53a14a0b1dcf652ce01d97b16a45f6fa952951a477830f035da142	0x3c15fd91	0x1111111254eeb25477b68fb85ed929f73a960582	0x2791bca1f2de4661ed88a30c99a7a9449aa84174	50589487	0x8158458e59cab1daa6400da8f7186a8e53ddca4b	5190727759395504068	0x8158458e59cab1daa6400da8f7186a8e53ddca4b	2023-11-30T22:40:09.000Z	5216811818487943787	0x9a17e19abe8112b895756bc64ef01acd0b36ac957ffd588987478ae4f27a52fc

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AggregationRouterV5_clipperSwap_function

AggregationRouterV5_clipperSwapTo_function

AggregationRouterV5_clipperSwapToWithPermit_function

AggregationRouterV5_fillOrder_function

AggregationRouterV5_fillOrderRFQ_function

AggregationRouterV5_fillOrderRFQCompact_function

AggregationRouterV5_fillOrderRFQTo_function

AggregationRouterV5_fillOrderRFQToWithPermit_function

AggregationRouterV5_fillOrderTo_function

AggregationRouterV5_fillOrderToWithPermit_function

AggregationRouterV5_OrderFilled_event

AggregationRouterV5_OrderFilledRFQ_event

AggregationRouterV5_swap_function

AggregationRouterV5_uniswapV3Swap_function

AggregationRouterV5_uniswapV3SwapCallback_function

AggregationRouterV5_uniswapV3SwapTo_function

AggregationRouterV5_uniswapV3SwapToWithPermit_function

AggregationRouterV5_unoswap_function

AggregationRouterV5_unoswapTo_function

AggregationRouterV5_unoswapToWithPermit_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​AggregationRouterV5_clipperSwap_function

​AggregationRouterV5_clipperSwapTo_function

​AggregationRouterV5_clipperSwapToWithPermit_function

​AggregationRouterV5_fillOrder_function

​AggregationRouterV5_fillOrderRFQ_function

​AggregationRouterV5_fillOrderRFQCompact_function

​AggregationRouterV5_fillOrderRFQTo_function

​AggregationRouterV5_fillOrderRFQToWithPermit_function

​AggregationRouterV5_fillOrderTo_function

​AggregationRouterV5_fillOrderToWithPermit_function

​AggregationRouterV5_OrderFilled_event

​AggregationRouterV5_OrderFilledRFQ_event

​AggregationRouterV5_swap_function

​AggregationRouterV5_uniswapV3Swap_function

​AggregationRouterV5_uniswapV3SwapCallback_function

​AggregationRouterV5_uniswapV3SwapTo_function

​AggregationRouterV5_uniswapV3SwapToWithPermit_function

​AggregationRouterV5_unoswap_function

​AggregationRouterV5_unoswapTo_function

​AggregationRouterV5_unoswapToWithPermit_function

Tables

AggregationRouterV5_clipperSwap_function

AggregationRouterV5_clipperSwapTo_function

AggregationRouterV5_clipperSwapToWithPermit_function

AggregationRouterV5_fillOrder_function

AggregationRouterV5_fillOrderRFQ_function

AggregationRouterV5_fillOrderRFQCompact_function

AggregationRouterV5_fillOrderRFQTo_function

AggregationRouterV5_fillOrderRFQToWithPermit_function

AggregationRouterV5_fillOrderTo_function

AggregationRouterV5_fillOrderToWithPermit_function

AggregationRouterV5_OrderFilled_event

AggregationRouterV5_OrderFilledRFQ_event

AggregationRouterV5_swap_function

AggregationRouterV5_uniswapV3Swap_function

AggregationRouterV5_uniswapV3SwapCallback_function

AggregationRouterV5_uniswapV3SwapTo_function

AggregationRouterV5_uniswapV3SwapToWithPermit_function

AggregationRouterV5_unoswap_function

AggregationRouterV5_unoswapTo_function

AggregationRouterV5_unoswapToWithPermit_function