1inch_v5_base

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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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	trace_address	in_inputAmount	block_timestamp	in_outputAmount	out_returnAmount	transaction_hash	in_clipperExchange
110133	0x000000000000000000000000000000000000000000000000000003d28c7c8c5d	0x000000000000000000000000000000000000000000000000000003d28c7c8c5d	0	false	11455	0x84bd6d29	0x1111111254eeb25477b68fb85ed929f73a960582	0x4200000000000000000000000000000000000006	0x000000000095862d00e512bd9f51005fffcf7c3c	25059076	0x000000000095862d00e512bd9f51005fffcf7c3c	4202834988125	0	4202834988125	2025-01-15T02:18:19.000Z	4202834988125		0x6125664b8b94a3ef263d9f9d8721039703b511891ca6b300f646cd3420ea8e0d	0x000000000095862d00e512bd9f51005fffcf7c3c
218935	0xb1a8ae939a47262ff312ecef994619f3737b56212accf463194cb8f32bbd02dc	0x3be3919b4583e3259d5d333c3aafbb282a162ef9cf5f18b71b7bbe42d466aeb1	20000000000000	true	179286	0x84bd6d29	0x1111111254eeb25477b68fb85ed929f73a960582	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0x0000000000000000000000000000000000000000	12971737	0x23b43a66cbc42fcc74760e292dd6051029b05f5e	2222428583849381100482615931628464818440965791301362955574010585692884		20000000000000	2024-04-10T07:07:01.000Z	70787	70787	0xce09b5b54720f84ae4e7c6e95dacb3ccca25df0dae17c7906cc2d9c8ad46071d	0xb32d856cad3d2ef07c94867a800035e37241247c
303677	0x5517ec205f4b94d297bfb83bb588869599e1dae48938c9279a05e4d98bb67d8e	0x13f57624acf9428c3814b8ca5c69cd7a1cf03b024bc98b8b0ad2755e6ae274fb	258281164638304	true	196230	0x84bd6d29	0x1111111254eeb25477b68fb85ed929f73a960582	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	0x0000000000000000000000000000000000000000	12979656	0x1f57aacc4b9068d93c776866c122959b1423e52c	2209817822436551557883926039552188499892818714969409176704450490169507		258281164638304	2024-04-10T11:30:59.000Z	908757	908757	0x00634809be8ef5aec733da83f2e1c5dc89f02f4ccceaf3ea83548fe8d5be4aa3	0xb32d856cad3d2ef07c94867a800035e37241247c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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	status	gas_used	signature	to_address	in_dstToken	in_srcToken	block_number	from_address	in_goodUntil	in_recipient	trace_address	in_inputAmount	block_timestamp	in_outputAmount	out_returnAmount	transaction_hash	in_clipperExchange
276070	0x7acc83ea4e48bcb7f54b180212c0be7fa92f7bc3ad0b06b492833b993b88e3af	0x75138abc06e7ae284349f738a872d75031d9f9e6a00ba17aa24de6ab491e9a0a	true	148957	0x093d4fa5	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	36737590	0x3a23f943181408eac424116af7b7790c94cb97a5	627396318451898872382762401035557016334294209781401522200566792590	0x5e1c93534875286b5c2e44b95bea136b926a4e08	0,2	5000000	2025-10-12T10:22:07.000Z	1308225694444332	1308225694444332	0x46aac4dd726c83ed5eff9a0a611e651069d3e302787f3c29f9a49c57a2e1aad1	0xb32d856cad3d2ef07c94867a800035e37241247c
362749	0xd96b8489a8542246e70d2e1a4dab068efd6d06a9d2ec9d63c9e0e4dccf88fc9c	0x029a3a3560ddf9b7572275756b29b7cc1d916078eca876643899d9f4c5dcf850	true	208000	0x093d4fa5	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	37214978	0x3a23f943181408eac424116af7b7790c94cb97a5	627082620292672924689215804616050931925932646667424891375011369762	0xaebaab8bfb0a567a823a93036ea5a907d5cb2786	0,2	50568244	2025-10-23T11:35:03.000Z	13055838391856866	13055838391856866	0x3a739427c209cf3674aaaecdf4401c34a7b80f2b1b7dc0b9875eba52957a4176	0x663fa8731045765067e2b5b6acb19be2ce974c7f
110448	0x0000000000000000000000000000000000000000000000000000369e9082a26b	0x0000000000000000000000000000000000000000000000000000369e9082a26b	true	43367	0x093d4fa5	0x1111111254eeb25477b68fb85ed929f73a960582	0x4200000000000000000000000000000000000006	0x000000000095862d00e512bd9f51005fffcf7c3c	23402788	0x000000000095862d00e512bd9f51005fffcf7c3c	60054657213035	0x000000000095862d00e512bd9f51005fffcf7c3c	0	60054657213035	2024-12-07T18:08:43.000Z	60054657213035	60054657213035	0x9bf573fc3caf76c1708a7909fb2ba16263668733ba0522afe37173b43e68dd29	0x000000000095862d00e512bd9f51005fffcf7c3c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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	value	status	gas_used	in_order	out_anon0	out_anon1	out_anon2	signature	to_address	block_number	from_address	in_signature	trace_address	in_interaction	block_timestamp	in_takingAmount	transaction_hash	in_skipPermitAndThresholdAmount
121663	0	true	92227	{“salt”:“435195386914”,“maker”:“0x56047f7f1d3b986de220f00f94612282c1eb7e61”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x4200000000000000000000000000000000000006”,“takerAsset”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“interactions”:“0xbf15fcd8000000000000000000000000d9cc0a957cac93135596f98c20fbaca8bf515909000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d00764fd9220000000002000056047f7f1d3b986de220f00f94612282c1eb7e6100000000000000000000000000000000000000000000000000000000”,“makingAmount”:“426264487914282154”,“takingAmount”:“6723335569”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	16728023483551565	263845848	0x3160ddc76a56e979fce5af7198c2edf14619f4fec90dbc2299c0a9b39cce6807	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	17862749	0xe37e799d5077682fa0a244d46e5649f71457bd09	0x299b8da918883558b8a75cb7a96d7234fb21ce7cd26a4351ad68da77fc8e5e3cf8413a5303fb5240fbf391f3558ac6722b57b83ceb944a67cf9138a52355468e	0,2,0,2,1,1	0x	2024-08-01T12:20:45.000Z	263845848	0x05bf417e230dacb5a28bc7b7b57b11701fcc2d2133e18ba9d4294322c9041a4b	57896044618658097711785492504343953926634992332820282019728808230139343864986
108074	0	true	89171	{“salt”:“296490579645”,“maker”:“0x6827c36ff9e2207124d8264966d914df7f48d8aa”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“takerAsset”:“0xe8ce40ebbb844142400d21558a2f1c9683d69139”,“interactions”:“0xbf15fcd8000000000000000000000000d9cc0a957cac93135596f98c20fbaca8bf515909000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d00664fa1af000000000000006827c36ff9e2207124d8264966d914df7f48d8aa00000000000000000000000000000000000000000000000000000000”,“makingAmount”:“100000000000”,“takingAmount”:“102986611740”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	645936330	665227941	0xba000a9fa5ed80606596d14ce86f33c69cdab6efe6747502cea0db25b8373975	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	11993101	0x7161f940d3ca88e4035d7b7fbde2a2870d176f87	0x4968da1f6ecf3f9165c175a6dc067489e03c2a5f7350c84bffac06c06a2e08066e27d6d7358503f41674d695ce11828b5409e84548bc9a694175760f7042283b1b	0,3,3,2	0x	2024-03-18T15:25:49.000Z	665227941	0xd6b046df0f38353f3f53ae0a531ceca3d1df42ceb727329c6f7870eee8e51934	57896044618658097711785492504343953926634992332820282019728792003956564819968
144773	21000000000000	true	104336	{“salt”:“1272435971097”,“maker”:“0x8c8868c77e0546b34f196595f0e727bc1add2e4d”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x23ee2343b892b1bb63503a4fabc840e0e2c6810f”,“takerAsset”:“0x4200000000000000000000000000000000000006”,“interactions”:“0xbf15fcd8000000000000000000000000d9cc0a957cac93135596f98c20fbaca8bf515909000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d0066584b8d000000000000008c8868c77e0546b34f196595f0e727bc1add2e4d00000000000000000000000000000000000000000000000000000000”,“makingAmount”:“21425164”,“takingAmount”:“1530368857142857000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	294	21000000000000	0xf913280c8089e2a1882f462fb0de47268b8797b784b6f4946e6ce2a1005af6b3	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	11984804	0xb7d7fa81bfa39273bfff9864ceef944948003d0f	0x695e3d52589c4cf404a559477acddee8e9ffdc4cc6e6e94f1f468cb3b3c3d83926eb8197dd04cdc0049bc07c9b7c87d14405885fd93e9794792c4eda18a8c1281c		0x	2024-03-18T10:49:15.000Z	21000000000000	0xa3e9002b0873afca867d36a48276645c6788374f953fb5d86c840b979e6f3ed0	57896044618658097711785492504343953926634992332820282019728792003956564820260

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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	value	status	gas_used	in_order	out_anon0	out_anon1	out_anon2	signature	to_address	block_number	from_address	in_signature	block_timestamp	transaction_hash	in_flagsAndAmount
102744	241417867960336	true	99366	{“info”:“32149178579944249779403405816”,“maker”:“0xbf67503abc1ee7e00eceffa7e35dce5d8a197fef”,“makerAsset”:“0x50c5725949a6f0c72e6c4a641f24049a917db0cb”,“takerAsset”:“0x4200000000000000000000000000000000000006”,“makingAmount”:“1”,“takingAmount”:“241417867960336”,“allowedSender”:“0x339aba9a98ba45bf1fb138154f7edf95176ebbc0”}	1	241417867960336	0xade851c29be43bea95f0d7e67cea5b0ef5171371edc11252fa9713cdd842e2c2	0x3eca9c0a	0x1111111254eeb25477b68fb85ed929f73a960582	25380564	0x339aba9a98ba45bf1fb138154f7edf95176ebbc0	0x3a06e9f680a5f18a52e2e63c8dafc589a296c592962a2f2b906ffa1e7c7998e3393a249f424138219c09f5d84cf45c8e7bf501abcf1f231cae0221aa008769cb1c	2025-01-22T12:54:35.000Z	0x5a8dee39ce05170f4631696fc48e0fcbb862535b645a00930e14438e3342a1dd	57896044618658097711785492504343953926634992332820282019728792003956564819969
119992	1759000000000000	true	116478	{“info”:“32147881755389123924215222290”,“maker”:“0xbf67503abc1ee7e00eceffa7e35dce5d8a197fef”,“makerAsset”:“0x50c5725949a6f0c72e6c4a641f24049a917db0cb”,“takerAsset”:“0x4200000000000000000000000000000000000006”,“makingAmount”:“1”,“takingAmount”:“1759000000000000”,“allowedSender”:“0x339aba9a98ba45bf1fb138154f7edf95176ebbc0”}	1	1759000000000000	0x13f5b8958cf085c5f70d7e0900e00ecefd3aa9f586b6b1c0244e8bd84b490c2f	0x3eca9c0a	0x1111111254eeb25477b68fb85ed929f73a960582	25345411	0x339aba9a98ba45bf1fb138154f7edf95176ebbc0	0xe82c5c47f1ac8ccfdb1d902791ad3ff489181cdcf575c1a2c0d4cbe7f045e82a75c49c0ca4ab32f2eb7c8d1bbfc3a351b0a1c87eaafcdd261124cc1788e6491b1c	2025-01-21T17:22:49.000Z	0xca456b1ed9a3850fcfeb98add836153ca910ea6e8544180c173bc04c1ab3e2a0	57896044618658097711785492504343953926634992332820282019728792003956564819969
102768	2126363017794773	true	99390	{“info”:“32147787953695509111145293359”,“maker”:“0xbf67503abc1ee7e00eceffa7e35dce5d8a197fef”,“makerAsset”:“0x50c5725949a6f0c72e6c4a641f24049a917db0cb”,“takerAsset”:“0x4200000000000000000000000000000000000006”,“makingAmount”:“1”,“takingAmount”:“2126363017794773”,“allowedSender”:“0xe0c771c8ad0b3e96db3d95a0f8beeddbd06ee7a0”}	1	2126363017794773	0x10b05e1dfbf3656c71efc1fa47507658dae491d64627357761e245a867dbaa01	0x3eca9c0a	0x1111111254eeb25477b68fb85ed929f73a960582	25342894	0xe0c771c8ad0b3e96db3d95a0f8beeddbd06ee7a0	0x5c6ea3b256c4e9d27545b8c9bc37ddd47c6f88e2d7bb6feaaeb0ccdf062a9d596fc6be3e10732102fd45ac462e2e712b740d1270173da216dbfd36848e3e38e01c	2025-01-21T15:58:55.000Z	0x7565c9f29f2686b754dac8ddd2e7f41aeee408a52ed4fd580687d74873aa4e62	57896044618658097711785492504343953926634992332820282019728792003956564819969

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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_makingAmount	transaction_hash	out_actualMakingAmount	out_actualTakingAmount	in_skipPermitAndThresholdAmount
2618964	true	98971	{“salt”:“247617913765”,“maker”:“0xe947cd067495f08ac00bbaf5616ec2eac154c912”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0xe947cd067495f08ac00bbaf5616ec2eac154c912”,“makerAsset”:“0x56c80aa1af0265a75d475420dcf8c1d063627199”,“takerAsset”:“0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca”,“interactions”:“0xbf15fcd8000000000000000000000000d9cc0a957cac93135596f98c20fbaca8bf515909000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d006be1354100000000000000e947cd067495f08ac00bbaf5616ec2eac154c91200000000000000000000000000000000000000000000000000000000”,“makingAmount”:“3465447170166288171934576925”,“takingAmount”:“34654500000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x3e4c7d0c624cc4c66a561f8383d9eb58ba810789	0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	34481012	0xf4cd829526070c2c0af9e6dce2c9255130f7ec68	0x2ffb230d19d1279677284c4aa8cb711d8cf4b408e2a275c3c64a0c4daec47a667b69b612cdbf86433d55cfbe92a73ec1e7804743d751d543cfa3f0b7271250661b	0xd2a86624d68e45db48f3dd9508348e44ce94c911334bc20f4573bac7a8d95344	4,1,2	0x	2025-08-21T04:42:51.000Z	499999591707612023	0xa5a57f892c9b105d137330f6cf11b176786826eb638d78f518c6ddcac5d8fe18	499999591707612023	5	6
1075930	true	525182	{“salt”:“46484498460148038570691115993313347471691788729508517494236664996337212012226”,“maker”:“0x75f73eceb03dc6279d440d832b154567279d2827”,“offsets”:“970558080243398695134547109586957793750899628853613079895592438595584”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x4200000000000000000000000000000000000006”,“takerAsset”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“interactions”:“0x63592c2b0000000000000000000000000000000000000000000000000000000066c54bd80075007b7b0006018aff00000000f1ceb16d94083606db7f4d98400554f17125483b00000000c1b19a08c2798c6930b8f3a44b7b0d08f4e198b800000000000000000000000000000000000000000000000000000000ad3b67bca8935cb510c8d18bd45f0b94f54a968f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a9048585166f4f7c4589ade19567bb538035ed360000000076c20c628a025bcbc2fc62e5cb8ecfbac5932086ffffffff5a”,“makingAmount”:“19000000000000000”,“takingAmount”:“48714701”,“allowedSender”:“0x7f069df72b7a39bce9806e3afaf579e54d8cf2b9”}	0x5eac749f86df56d2232835a00496be23a7f1c684	0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	18708300	0x7f069df72b7a39bce9806e3afaf579e54d8cf2b9	0x9c141fa4c385e4e18c67854b101a7c9b8e37a70652ef4d3bd774d8585f62a688a138f82b6c35a5c850bcddbb38f7cfe864307483667af85a80f3ff070689cbbe	0x4e2d37eb11004622224a298a13d4792f0b406c1eca6e57b8bb6c7da13d798300	0,0,1	0x7f069df72b7a39bce9806e3afaf579e54d8cf2b901f1ceb16d94083606db7f4d98400554f17125483b000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000200000000000000000000000042000000000000000000000000000000000000060000000000000000000000006131b5fae19ea4f9d964eac0408e4408b66337b50000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000044095ea7b30000000000000000000000006131b5fae19ea4f9d964eac0408e4408b66337b5ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000644e21fd0e9000000000000000000000000000000000000000000000000000000000000002000000000000000000000000011ddd59c33c73c44733b4123a86ea5ce57f6e854000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000003c000000000000000000000000000000000000000000000000000000000000000c00101000000290200000072ab388e2e2f6facef59e3c3fa2c4e29011c2d380000000000000000004380663abb8000010a4200000000000000000000000000000000000006833589fcd6edb6e08f4c7c32d4f71b54bda029135eac749f86df56d2232835a00496be23a7f1c68400000000000000000000000066c550280000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003100000000000000000000000002eead4b0000000000000000000000004200000000000000000000000000000000000006000000000000000000000000833589fcd6edb6e08f4c7c32d4f71b54bda02913000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000000002000000000000000000000000005eac749f86df56d2232835a00496be23a7f1c684000000000000000000000000000000000000000000000000004380663abb80000000000000000000000000000000000000000000000000000000000002c924a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000220000000000000000000000000000000000000000000000000000000000000000100000000000000000000000011ddd59c33c73c44733b4123a86ea5ce57f6e8540000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000004380663abb800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002267b22536f75726365223a22726f7361746f636f7270222c22416d6f756e74496e555344223a2234392e31303833323730393339363637222c22416d6f756e744f7574555344223a2234392e3038343136343232363533333034222c22526566657272616c223a22222c22466c616773223a302c22416d6f756e744f7574223a223439313936333633222c2254696d657374616d70223a313732343230353934342c22496e74656772697479496e666f223a7b224b65794944223a2231222c225369676e6174757265223a22552f6b6c696a684c41766238364e73397a4e382b4a525930577167565a427a6b737234686742465a4b6c454653776c4578534e344d6e3148643348567a363744486b356f67787638373458754e43733661593973677564767068317668645a4873765837673677476c69776c67614c4a4950312f6d74564c782f66595664374f36374c696e6233625263776e786b6171565575586162474b574d594c3937717646722f454e356e56476e476133454456674b54364c4b4e72646345704e466e6b4d357a4d57454878755057444d714d5a7a7137536772793358535a716b3642757178437030763275554867474a5735326f587352426742614c6a494d72786b76472b70513937374479536e3042553651314c2f5a2f67456841366a31734b366b614f6f754b373575693851565159316b424f7a6a71796e6d4c59503146743842534a574234776b594855345a383342757979324a73413d3d227d7d0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000f1ceb16d94083606db7f4d98400554f17125483b000000000000000000000000833589fcd6edb6e08f4c7c32d4f71b54bda02913000000000000000000000000000000000000000000000000000000000000f42700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	2024-08-21T02:05:47.000Z	19000000000000000	0x63c73886431675bcc17e1de36e83cf94bfc6fb8b3ab5095573890917786e2c4d	19000000000000000	49019182	48714701
943677	true	436758	{“salt”:“46484663455021641532741614744013182369420693838894683554412983579380985973385”,“maker”:“0xbb1127d92c44aa4bacedf1cca6d65ccd0f2905fe”,“offsets”:“970558080243398695134547109586957793750899628853613079895592438595584”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x4200000000000000000000000000000000000006”,“takerAsset”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“interactions”:“0x63592c2b0000000000000000000000000000000000000000000000000000000066c563c00075005ccf0006018b0d00000000f1ceb16d94083606db7f4d98400554f17125483b00000000c1b19a08c2798c6930b8f3a44b7b0d08f4e198b800000000000000000000000000000000000000000000000000000000ad3b67bca8935cb510c8d18bd45f0b94f54a968f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a9048585166f4f7c4589ade19567bb538035ed360000000076c20c628a025bcbc2fc62e5cb8ecfbac5932086ffffffff5a”,“makingAmount”:“19000000000000000”,“takingAmount”:“48670331”,“allowedSender”:“0x7f069df72b7a39bce9806e3afaf579e54d8cf2b9”}	0x5eac749f86df56d2232835a00496be23a7f1c684	0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	18711348	0x7f069df72b7a39bce9806e3afaf579e54d8cf2b9	0xf8f3401bc347ba427b53bdec8ce42120446f6414d739d2304ec6a255cc64228c75339c86744d170fb7d10b96630c927c1bdcc9e9b9c79a13b308824e519df06d	0x79b86c8f93e638f54cd6bb9325035c2a2e4efbb3b73106bb862c64caef0202b7	0,0,1	0x7f069df72b7a39bce9806e3afaf579e54d8cf2b901f1ceb16d94083606db7f4d98400554f17125483b000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000200000000000000000000000042000000000000000000000000000000000000060000000000000000000000006131b5fae19ea4f9d964eac0408e4408b66337b50000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000044095ea7b30000000000000000000000006131b5fae19ea4f9d964eac0408e4408b66337b5ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000644e21fd0e9000000000000000000000000000000000000000000000000000000000000002000000000000000000000000011ddd59c33c73c44733b4123a86ea5ce57f6e854000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000003c000000000000000000000000000000000000000000000000000000000000000c001010000002902000000b4cb800910b228ed3d0834cf79d697127bbb00e50000000000000000004380663abb8000010a4200000000000000000000000000000000000006833589fcd6edb6e08f4c7c32d4f71b54bda029135eac749f86df56d2232835a00496be23a7f1c68400000000000000000000000066c567f70000004000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003100000000000000000000000002ef17540000000000000000000000004200000000000000000000000000000000000006000000000000000000000000833589fcd6edb6e08f4c7c32d4f71b54bda02913000000000000000000000000000000000000000000000000000000000000016000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000001e000000000000000000000000000000000000000000000000000000000000002000000000000000000000000005eac749f86df56d2232835a00496be23a7f1c684000000000000000000000000000000000000000000000000004380663abb80000000000000000000000000000000000000000000000000000000000002c9895c00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000220000000000000000000000000000000000000000000000000000000000000000100000000000000000000000011ddd59c33c73c44733b4123a86ea5ce57f6e8540000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000004380663abb800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002257b22536f75726365223a22726f7361746f636f7270222c22416d6f756e74496e555344223a2234392e313837383331353137343231222c22416d6f756e744f7574555344223a2234392e3139363735343339383431353938222c22526566657272616c223a22222c22466c616773223a302c22416d6f756e744f7574223a223439323233353038222c2254696d657374616d70223a313732343231323033392c22496e74656772697479496e666f223a7b224b65794944223a2231222c225369676e6174757265223a225a5a416a4f554442636643323973716f377a505a46777a684b6f4767303630396f41446854544f76685a2f474f4a73452b696e78375439456338366f654a356d5852676a424967786f742b2b574d4839503377666e3069684c655148526f4d4c4638412f3069654f586b3471356470734f2b6e466b493261566747426a69533349524d484d43574b4f76784233412b6966362f735841787a547a6b6e4448726837314d67534a786a3058497a37616e5a6d4b7a6d6872334533713151395950444c734759687a3931454c686a4375673867642f35783852443934794270476f5758482f6b4f50787030432f3874496e6a724356724f4266536c344437337a65613864446259744a4379467574416e536c70335465515a784d6b2b4a4b6e36624b676f4b5a3273644f71374f547345386269396849756149366a6f3178776634396951696c324239544949744d344b415a77344b7750513d3d227d7d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000f1ceb16d94083606db7f4d98400554f17125483b000000000000000000000000833589fcd6edb6e08f4c7c32d4f71b54bda02913000000000000000000000000000000000000000000000000000000000001212300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	2024-08-21T03:47:23.000Z	19000000000000000	0x85366355d3a56bf6b30869a1bbb3c501b2d28a640dbcbbb282d833efa3251a55	19000000000000000	49030583	48670331

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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	block_number	in_orderHash	block_timestamp	transaction_hash
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x4f3e9494802d10f856c0ab57f6b5dc91afde0d82	10577649	0xa1248044702877d33a4dfd9063d75f9f77dac20157b840475e2fca4cdbc59fd0	2024-02-14T21:04:05.000Z	0x7388a0ba0493f3b1eadc80a11b14c5e8a5b5ed92242f1429ac0d8073a97f4c21
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x1632895fca6c91d3333c53a5f97f3bd29f3d4d97	10571165	0xbdfd0e811abdb4d57a4a0c1b413780ca82cfb3dd36f66ed76bbe28f6ce3f8413	2024-02-14T17:27:57.000Z	0xcc863784e7b879cc75df23ee07db8a567be8be667de2c3ac14914b4a2647a219
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x60389f28dd928e79f3db12552e12aec6852850af	10544677	0xb3dfe65f9c450abe73bd34908ba494191901716cd1de2f81c647ac6eb3d519cf	2024-02-14T02:45:01.000Z	0x8346e5d676855788cf764e4cb20f790e560e2091477a6dbc1016adad00a41799

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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	167	25340680	0xd101daad96ffa7f7e9101a26b90c09b00b55befcb7022c951f2cf7419febf4cc	2025-01-21T14:45:07.000Z	1	0xde14669c7097dfd63ae66227e81d415c7cc5ee77a7b0f422ceb0b74ad59332a7
0x1111111254eeb25477b68fb85ed929f73a960582	false	249	25345935	0x93ad845546dc6565c991bc4e8c55350c8808731994c8d6b32e179d0e61f0cd8d	2025-01-21T17:40:17.000Z	1	0x4d4908ea25a1b81f1cdcc6bc1c43ed3ba409715fbeb416e751f940dec1c8dff6
0x1111111254eeb25477b68fb85ed929f73a960582	false	235	25339919	0x5b28d4a064773cbe47c7848c97dcbd0ba49fb355a47cb8fb97a52e6148641856	2025-01-21T14:19:45.000Z	1	0xfb7cd58f9737b41b6cae28c62f81569c479e9a3b9de77d75c71e2a617a7b12c7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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
400000	0	false	286678	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	28462600	0x6947f763a87e2c0ceb1e0bc7c2f8e0bd96e88ec9	2025-04-03T21:09:07.000Z	0x62341b9560a7d6b15ca31000d7c5fd03c5005e350738589148cad39003d75f5f
796400	0	false	652266	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	28443639	0xd9adcdcd082a62d739086ecf8db57b324b69c25f	2025-04-03T10:37:05.000Z	0xb3e35e44c3ac2f0dd36ac614638129899d5feee9032ec20daa58a12ae763ce0b
400000	261634808664699000	false	182330	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	28455283	0x865e68baa8c7df7d71327a4ebd6a0cb7b0646387	2025-04-03T17:05:13.000Z	0x2dbdc47962877a88e0068d1e3a4c475c41b8e7c09160afa7d821abee954b2588

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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	transaction_hash
500000	100000000000000	false	42874	[“407183240616297097019375327704868567378367261988”]	100000000000000	0xe449022e	0x1111111254eeb25477b68fb85ed929f73a960582	21592813	0x67cb9a01ffde3ce38b0d0e9c6ee0a6d7e7aedace	95000000000000	2024-10-26T20:36:13.000Z	0x386172ecfbee8c4347b1e2f1e6a0d4ad1af753e24df143055e69ec26daf0e1aa
500000	100000000000000	false	42874	[“407183240616297097019375327704868567378367261988”]	100000000000000	0xe449022e	0x1111111254eeb25477b68fb85ed929f73a960582	21592807	0x67cb9a01ffde3ce38b0d0e9c6ee0a6d7e7aedace	95000000000000	2024-10-26T20:36:01.000Z	0x2c8b1db58b06a3af1acb4637a5c59a685feeb9a234eb3c857bebd74e083b5dd4
1111405	0	true	22236	[“14474011154664524427946373127049322521152360952151454300159750850495218463753”]	116328919845020389611	0xe449022e	0x1111111254eeb25477b68fb85ed929f73a960582	2323419	0xd07d0ba552bb656b000d60c2ccf87caf53cb26f8	39464739104765441	2023-08-07T19:23:05.000Z	0x0d842cf7c4d3a4e6664e94888959a3313453d06984f86c0d5ae208cedaaa8b5b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_minReturn`	`STRING`	Minimum acceptable output amount for the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_pools`	`ARRAY<STRING>`	Array of encoded pool identifiers for routing token swaps through decentralized exchanges. Elements are numeric strings representing packed pool addresses and swap parameters.
`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
112718	2200000000000	true	94980	[“1457117132465268392155012350446698550098007602087041820911”]	2200000000000	0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	22140687	0x85ff3f7e373677952ea57dc7f485aa6477e4162b	4493160835409460	2024-11-08T12:58:41.000Z	4531677320011668	0xc25ef77eef2676bd29929587345ff3476743bb4a921c6869f687300fc335194b
125416	2560000000000	true	94980	[“1457117132465268392155012350446698550098007602087041820911”]	2560000000000	0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	22141882	0xf33242fa20240db6626e2737c3006b13f4f12abb	5206675392705118	2024-11-08T13:38:31.000Z	5259268073439514	0x92cadb6f9b2659535af8a17d08f3d4ae0e0d7b2c559d19f45c6f033e3dd382c1
125430	2590000000000	true	94992	[“1457117132465268392155012350446698550098007602087041820911”]	2590000000000	0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	22138239	0xb680fff02bc846e41dd1fd10e3ee95baa891004b	5231691369013018	2024-11-08T11:37:05.000Z	5284536736376786	0x71b81455f90938b84859a1605e44994454e32353227bb4d171e0ea47cb0476a9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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	value	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
130125	5090000000000	true	93215	[“1457847884221550172874853599682230344371158361999054654248”]	5090000000000	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	5785287	0xc629bf86f02ef13e8f1f5f75ade8a8165587998f	1169652063902384	0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f	2,0	2023-10-26T22:38:41.000Z	1181466731214530	0xb9ca08ca0d716dbfb483af67a10b6277da6b0458af94ee09dd8128f6cbe0702d
130125	6490000000000	true	93215	[“1457847884221550172874853599682230344371158361999054654248”]	6490000000000	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	5786486	0xc629bf86f02ef13e8f1f5f75ade8a8165587998f	1493353592922730	0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f	2,0	2023-10-26T23:18:39.000Z	1508437972649223	0x94ac366c03b47d491e99deb957026bbc96af7268e09a1f4e95fa5d2319615027
146695	4860000000000	true	93215	[“1457847884221550172874853599682230344371158361999054654248”]	4860000000000	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	5766996	0xc629bf86f02ef13e8f1f5f75ade8a8165587998f	1109639637708319	0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f	2,0	2023-10-26T12:28:59.000Z	1120848118897292	0x763fb73d90f7e4a6ee9d9d4840f0949601f46fd2cf6195e4f5c26765352c7a59

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_base.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`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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

No sample data available.

Example Query

Query with partition filter

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

Overview

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

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