1inch_v5_ethereum

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	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
126252	false	30265	0x84bd6d29	0x1111111254eeb25477b68fb85ed929f73a960582	17457480	0x4d04054f0d1f553af6f5e8ed981f5300d9d78877	2023-06-11T14:31:47.000Z	0x993359a954b4ccce318fa568bfcb821198cfe6da0c83a4117dae52b81b389fc4
126276	false	54026	0x84bd6d29	0x1111111254eeb25477b68fb85ed929f73a960582	17457480	0x4d04054f0d1f553af6f5e8ed981f5300d9d78877	2023-06-11T14:31:47.000Z	0x975392b94905814b4cf9b20085e12195b6d21547f4501e509787b377a28b9c70
140986	false	68300	0x84bd6d29	0x1111111254eeb25477b68fb85ed929f73a960582	17457459	0x7da1c719234a9e1702f373a8fca3eb162d3c6f44	2023-06-11T14:27:35.000Z	0xdbe73f8fc2c4b4bdfffcbf7c2b3726c99f3bedafd976393faf4e01cd67b33a6c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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
157690	0xeae0b3e3e395b604758a5455c9595a4ae81a0024028eddede35ce4d066a75409	0x6cde703af99b99bf4735650a9a705dbfb0b28ef4e3fcef787378fe6e49b8ff34	true	64610	0x093d4fa5	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	0x6b175474e89094c44da98b954eedeac495271d0f	22819516	0xad3b67bca8935cb510c8d18bd45f0b94f54a968f	489505882119765514772754352991305016542723356561880558636913349361856145	0x00000011f84b9aa48e5f8aa8b9897600006289be	0,0,2,0,0	300000000000000000000	2025-06-30T20:06:47.000Z	119653244896290560	119653244896290560	0x7179c48c5e0fa69dd386adf2544ea986933ac7d4ec0f5d0c03b2018b0984445e	0x655edce464cc797526600a462a8154650eee4b77
331020	0x69cd819f4ec260121df1e447d0b451b41047825dc95766eadab81c2238a7f667	0x14cdb4486d9c271c375f5e16702490a8bf5090b12e6c1d0dae0ecd6469ddd250	true	55227	0x093d4fa5	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	0xdac17f958d2ee523a2206206994597c13d831ec7	22816760	0xb3445d5413abf63df1112a4a517de2602f249785	401453198052289557142356827117417493480865932986503720496319	0x00000011f84b9aa48e5f8aa8b9897600006289be	1,2,0	100000000	2025-06-30T10:52:47.000Z	40691755208058568	40691755208058568	0x616c808f0dedae39b57dceb3b725aa2ee63707c8600f5b02b9890934c610a88d	0x655edce464cc797526600a462a8154650eee4b77
166132	0xa3a6690bc47a301bc260a14fb7130e666e683e068ce79338f3cf7e907b296dbc	0x90ed44bc8c93d4b0a6dcc13190f924239c8a98a6c5b308f83dbc2793ab0ff0c4	true	130336	0x093d4fa5	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	0xdac17f958d2ee523a2206206994597c13d831ec7	22818270	0x4c2eef75a0549ddc5d760d400d5a4635e4a47cd1	397770532976407616036571672607118038154225405141584019895201	0x261fe4be528bfda58c3292ce5ff2ea3f57e8bf5a		130000000	2025-06-30T15:56:11.000Z	52544885390489072	52544885390489072	0xcf769248fadbf1a22a3975b0ffb9dfebeb84c9ca576cf8600bba56e0d0dafdc8	0x655edce464cc797526600a462a8154650eee4b77

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
200094	false	105060	0xc805a666	0x1111111254eeb25477b68fb85ed929f73a960582	18158623	0x6ddab3519c2191bcf955597735759f284de22b98	2023-09-17T22:13:23.000Z	0x07785923d713f2e8c6427f1a64205f2e686d45f87de1cddf47f5f4a601ca6974
181169	false	108919	0xc805a666	0x1111111254eeb25477b68fb85ed929f73a960582	18158967	0x1b3c1184e81e94fe491a5fb6881ece287b2db06b	2023-09-17T23:23:59.000Z	0xd872e3ae1ae24a8bd20d88595b137a0edfe0482702a6fbdd9f0be7fdd6e743c3
200126	false	127152	0xc805a666	0x1111111254eeb25477b68fb85ed929f73a960582	18154267	0xd155f93f1c642015f313b5259d5d49a62d76a864	2023-09-17T07:23:23.000Z	0x012364fdfcc5bd79e197d18530cec4b52e408f0a684b5e88dcd26a92fc70886a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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	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
160762	true	45788	{“salt”:“191922544850”,“maker”:“0x691ea1290b66ae90a58eb302ff11a888a4940031”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“takerAsset”:“0xe4815ae53b124e7263f08dcdbbb757d41ed658c6”,“interactions”:“0xbf15fcd8000000000000000000000000303389f541ff2d620e42832f180a08e767b28e10000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d006a92b14300000000000000691ea1290b66ae90a58eb302ff11a888a494003100000000000000000000000000000000000000000000000000000000”,“makingAmount”:“500000000000000000”,“takingAmount”:“721117869068888100000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	4369942880506840	6302487795887702369153	0x8ba979847d7e00f8312381d1b957ce2a2b17d300133e842493cbbea2fc18a589	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	23242193	0x00000000000ba9cd9f5175108141a82b6c24d727	0x3bf929740bd459a6b45038a4d858d0944938159f341dd00f6f8b311ee08375c85bc82e79dde391fbde6afb412fcb91ff13ac8e9e2106fca8af96dfd45707ef2f1c	0,3,1,1,0,0,5	0x	2025-08-28T21:06:47.000Z	6302487795887702369153	0x13f972cd7b04d0187eb97ff0d8400d88af269a79fb28ead3b9805cea99a7dc00
158215	true	48588	{“salt”:“191922544850”,“maker”:“0x691ea1290b66ae90a58eb302ff11a888a4940031”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“takerAsset”:“0xe4815ae53b124e7263f08dcdbbb757d41ed658c6”,“interactions”:“0xbf15fcd8000000000000000000000000303389f541ff2d620e42832f180a08e767b28e10000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d006a92b14300000000000000691ea1290b66ae90a58eb302ff11a888a494003100000000000000000000000000000000000000000000000000000000”,“makingAmount”:“500000000000000000”,“takingAmount”:“721117869068888100000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	2048957074806237	2955079119195793177585	0x8ba979847d7e00f8312381d1b957ce2a2b17d300133e842493cbbea2fc18a589	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	23242194	0x00000000000ba9cd9f5175108141a82b6c24d727	0x3bf929740bd459a6b45038a4d858d0944938159f341dd00f6f8b311ee08375c85bc82e79dde391fbde6afb412fcb91ff13ac8e9e2106fca8af96dfd45707ef2f1c	0,3,1,1,0,0,3	0x	2025-08-28T21:06:59.000Z	2955079119195793177585	0xb19f031e0a03c94dd9b6826c10a4dc60e1a73a0a5c39b88c2cb853a2bd7a3bf6
261413	true	67388	{“salt”:“191922544850”,“maker”:“0x691ea1290b66ae90a58eb302ff11a888a4940031”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“takerAsset”:“0xe4815ae53b124e7263f08dcdbbb757d41ed658c6”,“interactions”:“0xbf15fcd8000000000000000000000000303389f541ff2d620e42832f180a08e767b28e10000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d006a92b14300000000000000691ea1290b66ae90a58eb302ff11a888a494003100000000000000000000000000000000000000000000000000000000”,“makingAmount”:“500000000000000000”,“takingAmount”:“721117869068888100000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	3611479112851105	5208604244091974944285	0x8ba979847d7e00f8312381d1b957ce2a2b17d300133e842493cbbea2fc18a589	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	23242194	0xe08d97e151473a848c3d9ca3f323cb720472d015	0x3bf929740bd459a6b45038a4d858d0944938159f341dd00f6f8b311ee08375c85bc82e79dde391fbde6afb412fcb91ff13ac8e9e2106fca8af96dfd45707ef2f1c	0,3,4	0x	2025-08-28T21:06:59.000Z	5208604244091974944285	0x19a915314d4cea2cfb55d3661c56adaf3ab70e035c5d25ac75c408caba35966b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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	status	gas_used	in_order	out_anon0	out_anon1	out_anon2	signature	to_address	block_number	from_address	in_signature	trace_address	block_timestamp	transaction_hash	in_flagsAndAmount
278309	false	5465					0x3eca9c0a	0x1111111254eeb25477b68fb85ed929f73a960582	22451932	0x64f2095cc11e4726078f4a64d4279c7e7fb7e6ec		1,2,1	2025-05-10T08:54:59.000Z	0x85935aad89437ec2d168bce42cc5bbd658bb51c956e61035a40a3e9618f49aeb
356106	false	5465					0x3eca9c0a	0x1111111254eeb25477b68fb85ed929f73a960582	22450886	0x64f2095cc11e4726078f4a64d4279c7e7fb7e6ec		1,2,0,1	2025-05-10T05:22:23.000Z	0xfa24da21f468479935c1294ef0319755d8a44b880b3d56227aa9d23a23b42c6a
272049	true	78403	{“info”:“32224865312624263037758780871”,“maker”:“0xbb289bc97591f70d8216462df40ed713011b968a”,“makerAsset”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“takerAsset”:“0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0”,“makingAmount”:“2049411556164413184”,“takingAmount”:“1940680865836278629136”,“allowedSender”:“0x64f2095cc11e4726078f4a64d4279c7e7fb7e6ec”}	2049411556164413184	1940680865836278629136	0x62098561750415709a5999585b2ce86379cbfc7b0d85f402fda1035e620fa90e	0x3eca9c0a	0x1111111254eeb25477b68fb85ed929f73a960582	22455730	0x64f2095cc11e4726078f4a64d4279c7e7fb7e6ec	0x1ee37004ab3bbda42dba078593dd6ea597e7a672b33f7068be41e7e0fbd726617a21bba0734fc7e6d4a2c824637571c7b6f3fb5488fa5bca195cc56ac306d28a1b	1,2,0,5,1	2025-05-10T21:43:47.000Z	0x6189355d37b6700da90a972e0fc14904e7308b624dd07e0ca69f873e70a2f0ae	1940680865836278629136

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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

gas	in_r	in_vs	status	gas_used	in_order	signature	to_address	block_number	from_address	out_orderHash	trace_address	block_timestamp	transaction_hash	in_flagsAndAmount	out_filledMakingAmount	out_filledTakingAmount
242863	0x04ac7e6f3dff9c9feef888fc3874119d907a3e9e9a4e5ef9aa6b8e21fb255ca7	0x454c344efb698ca4ecb22b0e2886191cc66d5d20ef198c8d6127166c777e8ec0	true	68494	{“info”:“30934668388410987087347339763”,“maker”:“0xb398ffef80144095b8712c70a0c09886c8151feb”,“makerAsset”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“takerAsset”:“0x111111111117dc0aa78b770fa6a738034120c302”,“makingAmount”:“2361969255”,“takingAmount”:“3749402449548725518911”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x9570eeee	0x1111111254eeb25477b68fb85ed929f73a960582	16675972	0x84d99aa569d93a9ca187d83734c8c4a519c4e9b1	0x3fc2b798cbdead2adbb2a07abe244c7278c14f45ae5c6c994214133cc87989c3	1,1,3,0,0	2023-02-21T09:26:11.000Z	0xab66bf96512fec6374fba40613090fa5de96ba04d6e848d1dc25471fef1b65c5	3749402449548725518911	2361969255	3749402449548725518911
190671	0x7648617a9976c653cc1b926d8e391de856c3220cf31ca5cabac2f8d4f87aa6cd	0x452a85ae0c1873742e9ef8d25e5073f93696faa24fb15d5aa35b387478aaa402	true	41789	{“info”:“30935603461400026923017635286”,“maker”:“0xbb289bc97591f70d8216462df40ed713011b968a”,“makerAsset”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“takerAsset”:“0x4d224452801aced8b2f0aebe155379bb5d594381”,“makingAmount”:“3006318973100014080”,“takingAmount”:“894172380484383539200”,“allowedSender”:“0x84d99aa569d93a9ca187d83734c8c4a519c4e9b1”}	0x9570eeee	0x1111111254eeb25477b68fb85ed929f73a960582	16680169	0x84d99aa569d93a9ca187d83734c8c4a519c4e9b1	0x6534b9b505d49d2218b9c72aa8014df5bda84d6322a03a451324795c276b42a4	1,1,1,0,0	2023-02-21T23:33:11.000Z	0x0780b086e8d4e3f4e1c3f4b547fc41a8c4dcfbfc1c7e3b114a25596f4f39810d	894172380484383537588	3006318973100014074	894172380484383537588
153212	0x7e39d7b8e493cb1e05d573c4503e2eafe1eaa34fcea0cebe36e1e1e6bb8333ec	0x21e181b016a3df2c13d56eb85ca8975f845528dc3b9c66769c8459c90c315d67	true	39401	{“info”:“30934212798257798107340407748”,“maker”:“0xbb289bc97591f70d8216462df40ed713011b968a”,“makerAsset”:“0xd533a949740bb3306d119cc777fa900ba034cd52”,“takerAsset”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“makingAmount”:“7369060174630299369472”,“takingAmount”:“5483032500000000000”,“allowedSender”:“0x84d99aa569d93a9ca187d83734c8c4a519c4e9b1”}	0x9570eeee	0x1111111254eeb25477b68fb85ed929f73a960582	16673957	0x84d99aa569d93a9ca187d83734c8c4a519c4e9b1	0xd4849a499fe459f87556557acd5510def8ad541fd3665c0a2eddb3a50b0d7617	1,1,1,0,0	2023-02-21T02:36:47.000Z	0x3895a3b55e22cb1b26b4cae447d3ccfad3b120cd8c4070278e38c73d0a1240fa	5483032500000000000	7369060174630299369472	5483032500000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
97432	false	5534	0x5a099843	0x1111111254eeb25477b68fb85ed929f73a960582	18476117	0x5f515f6c524b18ca30f7783fb58dd4be2e9904ec	1,3,1	2023-11-01T08:38:59.000Z	0x58d9fce79496e90370e617c00bff3ef0613fc36e3beb1b4d1bc91ba493e3a403
97908	false	5534	0x5a099843	0x1111111254eeb25477b68fb85ed929f73a960582	18477005	0x5f515f6c524b18ca30f7783fb58dd4be2e9904ec	0,4,1	2023-11-01T11:38:35.000Z	0x51d75801f4f583b81a690f18135e8309e49447ba5e26ef9d4186d4d2635ac549
484695	false	5494	0x5a099843	0x1111111254eeb25477b68fb85ed929f73a960582	18474158	0xe37e799d5077682fa0a244d46e5649f71457bd09	0,2,0,0,0,1,1,1,0,0,1	2023-11-01T02:04:11.000Z	0x110b5b18dfe51085ee063719e632ca5ffc5499b1801f9071b5040edb382c817a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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

gas	status	gas_used	in_order	in_permit	in_target	out_anon0	out_anon1	out_anon2	signature	to_address	block_number	from_address	in_signature	block_timestamp	transaction_hash	in_flagsAndAmount
394172	true	193262	{“info”:“31218373361498247681517971473”,“maker”:“0xb3c839dbde6b96d37c56ee4f9dad3390d49310aa”,“makerAsset”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“takerAsset”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“makingAmount”:“296264643322727360”,“takingAmount”:“500500000”,“allowedSender”:“0x18406666cae761a86606fad2b730146fc0c260bc”}	0x00000000000000000000000018406666cae761a86606fad2b730146fc0c260bc0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064e08c6b000000000000000000000000000000000000000000000000000000000000001c8c41f22c25d106fd8cf574eeda0f973be6c92b32f50fbe1e0ef26a0cfdf4739a7abd337e82232be8d1906b5576590a5fe1d8798811dbd6d4309794318b88c89a	0x18406666cae761a86606fad2b730146fc0c260bc	295968674648079280	500000000	0xbd06d74fddd5c35b4d70cb53831f696b36ec364f84694cc2df4cf4d40d41c60c	0x70ccbd31	0x1111111254eeb25477b68fb85ed929f73a960582	17940815	0x18406666cae761a86606fad2b730146fc0c260bc	0x1ccbb3fbe3fb3b2bb9e60cd6654a987c28badb1ed2917af3b6205f44a2eb6c43b83494810b79103c7d2268d62e8e06b9cf6c412854fddb71a32c3fd51d71b34f8964df3b3b	2023-08-18T09:35:23.000Z	0x66331b0ffea677282c0151db99c1b345979097909300d1b7a729db0abda4eff0	36185027886661311069865932815214971204146870208012676262330495002473353012480
238992	true	208032	{“info”:“31218089613680905881195012457”,“maker”:“0xb3c839dbde6b96d37c56ee4f9dad3390d49310aa”,“makerAsset”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“takerAsset”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“makingAmount”:“100063964”,“takingAmount”:“100100000”,“allowedSender”:“0x3a58720c1c112e513726c9b31bb78c46b859d040”}	0x0000000000000000000000003a58720c1c112e513726c9b31bb78c46b859d0400000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064e050b6000000000000000000000000000000000000000000000000000000000000001ce874cc6b1e7bc01089f9df385cac665550d839d9c3e13c63a4b090591763fc6044fa00902787eca5aba6e49d4569604afafc2e8701597afd1c37648b2db71746	0x3a58720c1c112e513726c9b31bb78c46b859d040	99964000	100000000	0x38f19c59ddf4b64381f43a1af179d1bd5987f65eb0501f0c2eb60f2f1efda722	0x70ccbd31	0x1111111254eeb25477b68fb85ed929f73a960582	17939549	0x3a58720c1c112e513726c9b31bb78c46b859d040	0x1b6e0724aa10603fae1af60fafd0bbf9f3adc849f2bda1210fb2bc1d2efcac7a2566d1e290489dc3d3ffb69e26c759bf7edcdeea7db68937fd947b65a909f4620b64deff25	2023-08-18T05:19:11.000Z	0xb21db3038a56b8bf3100454c9399ef1ca99a27ea5dbf98bb2e2be7d035793cc6	28948022309329048855892746252171976963317496166410141009864396001978382409984
204828	true	173868	{“info”:“31218692988232812846918823800”,“maker”:“0xb3c839dbde6b96d37c56ee4f9dad3390d49310aa”,“makerAsset”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“takerAsset”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“makingAmount”:“5004129811”,“takingAmount”:“5005000000”,“allowedSender”:“0x86b2ad55abc6f0997560bb7fde88de1256b3ddd0”}	0x00000000000000000000000086b2ad55abc6f0997560bb7fde88de1256b3ddd00000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064e0d05f000000000000000000000000000000000000000000000000000000000000001cbe5cbba50ff174809dfdb6e2404c89462ba596de0f83edca7d1d3c01cc52187d654df837073727e55f3d365e91cd9e8958fc2a59ab58e4ede62523f7a8c4f190	0x86b2ad55abc6f0997560bb7fde88de1256b3ddd0	4999130680	5000000000	0xa6a1d5beac67a2fcdbf2941d18326e8af39a802446b0210798f30c48f5d6ee6b	0x70ccbd31	0x1111111254eeb25477b68fb85ed929f73a960582	17942246	0x86b2ad55abc6f0997560bb7fde88de1256b3ddd0	0x1bf693d9837c2a7a40680392cc7fecd951de0d8fcfd86c0195ad6e8ae7b7e6d3062f48c08eb4210a85a9013973ff1396c4b38d1a935e43579e60a478007ee0dc4364df7eea	2023-08-18T14:23:47.000Z	0x7a6ae867f0de1107109281a860ab8bf2f821c16b28edbc66377113a0da1b71d8	28948022309329048855892746252171976963317496166410141009864396001983282409984

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
430951	false	32877	0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	21051114	0x3451b6b219478037a1ac572706627fc2bda1e812	3,0,2,4,1,0,3	2024-10-26T16:53:35.000Z	0x2c55201867789f7d1c0b28f97d6afcd3ade756882d3a1effc2bff521d54e0de9
295625	false	54375	0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	21051107	0x3451b6b219478037a1ac572706627fc2bda1e812	2,0,2,4,1,0,1,3	2024-10-26T16:52:11.000Z	0xdf29b7b8a481f01453678f7ca2139852db10a81723afb925d07024b64d897d5c
202076	false	54375	0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	21051107	0x3451b6b219478037a1ac572706627fc2bda1e812	2,0,2,4,1,0,1,7	2024-10-26T16:52:11.000Z	0xdf29b7b8a481f01453678f7ca2139852db10a81723afb925d07024b64d897d5c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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

gas	status	gas_used	in_order	in_permit	in_target	out_anon0	out_anon1	out_anon2	signature	to_address	block_number	from_address	in_signature	in_interaction	block_timestamp	in_takingAmount	transaction_hash	in_skipPermitAndThresholdAmount
203241	true	166643	{“salt”:“452017086789”,“maker”:“0x72c6a4624e1dffa724e6d00d64ceae698af892a0”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0xae78736cd615f374d3085123a210448e74fc6393”,“takerAsset”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“interactions”:“0xbf15fcd8000000000000000000000000303389f541ff2d620e42832f180a08e767b28e10000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d006739b6910000000000000072c6a4624e1dffa724e6d00d64ceae698af892a000000000000000000000000000000000000000000000000000000000”,“makingAmount”:“23158665798296536208”,“takingAmount”:“52894392683”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48000000000000000000000000416a9e0b90152095a9f46408130446d8dc5d206a0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000006576f543000000000000000000000000000000000000000000000000000000000000001b804c771d2a4f21a554e6b21fae431d4d7c5c04891d65bde8693c282084f3958802b7d248fb6f34b371c862221f9dee11602cb4d44451b627b0156659e3b5bfff	0x416a9e0b90152095a9f46408130446d8dc5d206a	19535901926559065	44620000	0xab81cee9b0d40a93040d518038962827b2459b795eebaf658885df558e070cae	0xd365c695	0x1111111254eeb25477b68fb85ed929f73a960582	18755585	0x416a9e0b90152095a9f46408130446d8dc5d206a	0x83317c2db8de47f569164ec4677b56a1d559d821ab30d1c2acf21ed1965210761439ca2a8b7e883dd4ebb3544e917097212a0a8e87ce962184d70e39e2633e4c1c	0x	2023-12-10T11:43:11.000Z	44620000	0x57625b535806d8076d51b746fd22c75bb84117a8eb73de04df21de8d9aa4e1d2	57896044618658097711785492504343953926634992332820282019728811344499472113442
213951	true	184015	{“salt”:“934919971473”,“maker”:“0xf3f51072e40c2a9dbc7a79661153d7189e1134f6”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x2b591e99afe9f32eaa6214f7b7629768c40eeb39”,“takerAsset”:“0x6b175474e89094c44da98b954eedeac495271d0f”,“interactions”:“0xbf15fcd8000000000000000000000000303389f541ff2d620e42832f180a08e767b28e10000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d00650eea0300000000010000f3f51072e40c2a9dbc7a79661153d7189e1134f600000000000000000000000000000000000000000000000000000000”,“makingAmount”:“27552406282495”,“takingAmount”:“1019439032452314900000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x6b175474e89094c44da98b954eedeac495271d0f0000000000000000000000007a52ed280b3bdb38d09c2beff72ffc2ed27fe88f0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582000000000000000000000000000000000000000000000000000000000000000300000000000000000000000000000000000000000000000000000000650723680000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000001ca887f3651e1b9112d16435026cdb8f5b8888c432b4516bb9824ed5daa91bb40b0000c19981ba0aef2ad6779c3eaf2d32e3c5a1c43b59de08eaa18c32f1216eb8	0x7a52ed280b3bdb38d09c2beff72ffc2ed27fe88f	3000000000000	111000000000000000000	0x025fa61eb575aafd00b39ef763879c5cfd00ff6440dd207b134728c780bf6c97	0xd365c695	0x1111111254eeb25477b68fb85ed929f73a960582	18149767	0x7a52ed280b3bdb38d09c2beff72ffc2ed27fe88f	0x83961842c832b368ca44cbeb35f6b6a395ba99c7eee797995973938586f14f33631079c157bfbfdc948c488273da3c3edc797680e73d38f704804e64ea3e6d7b1b	0x	2023-09-16T16:05:11.000Z	111000000000000000000	0x028c887deba9f1d5589b04622e52bef469684a72ac658f409b3132618f87440a	57896044618658097711785492504343953926634992332820282019728792006941564819968
201740	true	167004	{“salt”:“1036713908079”,“maker”:“0x8fe0e1205811d5a7e80ee9dc65ae75cafd71ac8d”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“takerAsset”:“0x956f47f50a910163d8bf957cf5846d573e7f87ca”,“interactions”:“0xbf15fcd8000000000000000000000000303389f541ff2d620e42832f180a08e767b28e10000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d0065064faa000000000000008fe0e1205811d5a7e80ee9dc65ae75cafd71ac8d00000000000000000000000000000000000000000000000000000000”,“makingAmount”:“50000000000”,“takingAmount”:“50020008003201280000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x956f47f50a910163d8bf957cf5846d573e7f87ca0000000000000000000000002bb8ab3c2a9837de97a83c228a07e16928b4f07f0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000065072f13000000000000000000000000000000000000000000000000000000000000001b31eb215ff82fcfe5d98c00279310367e3c0c6ba66de60b9cb665e36fded6b7e278d94c031de757d62e11df073410ef4c92c9b3740da29750d6faec0bfa8a3b5e	0x2bb8ab3c2a9837de97a83c228a07e16928b4f07f	241284244	241380797227181598226	0xe0bb84ccf9269484972949b9ae01c1413e948b5e07aeffb61a26f58d8d6f82a0	0xd365c695	0x1111111254eeb25477b68fb85ed929f73a960582	18150007	0x2bb8ab3c2a9837de97a83c228a07e16928b4f07f	0x82a812386681cde73eac1fab5c3c7f14cfc4a452d3c1be4eb469e5014ba0d1685eb4f28224f3ec998afe6a27862ba59ce48593a56c4c5f0e4f8a36a1af1d958b1c	0x	2023-09-16T16:53:59.000Z	241380797227181598226	0xdde423427474ccdd0e8324e61124de582547fd448a3d07581c49e0fc3c38d5ee	57896044618658097711785492504343953926634992332820282019728792003956805862927

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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	in_remaining	block_timestamp	transaction_hash
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x0082ce7f8a3e3c69e7c5cd801760d40d55ce119c	17037204	0x99948b44cd6e7f6a03097d08f0cb8b94c41b0a6f71bd5fc3d925f0b1ac671a56	96211593838485662981147	2023-04-13T07:28:47.000Z	0xf00514d872f6c53e5d9aa28c6e90ab355778da99a4551908b349f5a5b52094fc
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x026693b5bfe2b3cd6e35ec9342811be3071e28da	17036790	0x27ef2fbbaa3c5da7a3300fb23a1a86aa8a3d22a23b7fec1d72f151fcb19189ef	0	2023-04-13T05:54:59.000Z	0xde7f576770698d14886c5d0f44e05199c4702544da70973bf42af04364523968
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x0281531ebed0d369e29f29bb4295be46113e422b	17038931	0x55d2150059f46e69e409c6b1536103a04a5461f8f2c74a5713a538f8f97c8237	0	2023-04-13T13:54:23.000Z	0xcab55bdca744ff65b10a1ae41ab637c8377618ef0df261c3a57008d356bd7300

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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	258	17515051	0x53c7afbe4f75c4f19aa6d086ea5a61f551ff01008920f0ddf8355016c6a21699	2023-06-19T16:43:23.000Z	1690070502101307813	0x478f0c13f54a921a2682ddd5ed1637e0eeba9f70f68f713c1e8de52ee74f298a
0x1111111254eeb25477b68fb85ed929f73a960582	false	3	17514738	0x4fdae95174da52068a1a755f4213b73cafcea1d74255636f903b4065621e1f1c	2023-06-19T15:39:35.000Z	2092882104	0x3086e5b278ab89cc1dd339d4b4c3ffb6bc6dd2779cff12e5ad3cd9a342e6a8f1
0x1111111254eeb25477b68fb85ed929f73a960582	false	4	17513415	0xd204629e3fef5ca8a975de3740822032cf61a9f87bc422a70920b641026ab479	2023-06-19T11:11:35.000Z	28100825745	0x12d44b1fd9899b98722b4a0aef5171b396d45b56df934667e7537ccf48dc1643

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
659354	false	658969	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	15991010	0xc93678ec2b974a7ae280341cefeb85984a29fff7	2022-11-17T16:43:11.000Z	0x37e5b355987c71964bad6cde958dc87ab7525d2729118e64c0de38b8b2cfcb95
303134	false	193946	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	15988967	0x35ba260ced73d3d8a880bf6b0912edfb87bfa04c	2022-11-17T09:52:23.000Z	0x81dade2b65a492a824b3c18b874120642030310c22dcaf9f73915ada392f05c7
1167648	false	175244	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	15987504	0xcc88036fa05c86129bf66260c2a905ab2c7b663c	2022-11-17T04:58:35.000Z	0xa2b90b543a0e54dd620f8bc5f7c0505917b680dbf3e2d77862e3fd8dc3fff58a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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	status	gas_used	in_pools	in_amount	signature	to_address	block_number	from_address	in_minReturn	block_timestamp	out_returnAmount	transaction_hash
191294	true	131443	[“14474011154664524427946373126867554402161832605793805858616410165020352009792”]	1350000000	0xe449022e	0x1111111254eeb25477b68fb85ed929f73a960582	18867100	0xd4cdb38fe7b8faff535a133c055ab6edfc7118f0	591313721167765200	2023-12-26T03:10:23.000Z	594285146902276583	0x0a5730e1e1b41a6f990f0c435ac1f5fc18c6631de38d087c8244f2fd8427bd98
285944	false	227596	[]		0xe449022e	0x1111111254eeb25477b68fb85ed929f73a960582	18869273	0x04b3d2d4b51ceb4601dc73a226806cbcab067a75		2023-12-26T10:27:59.000Z		0x230ab5df914a7c0da7df31fb8dade2c06a837904d5636c145134e05f6f91b23e
264455	true	188331	[“1173264970241401508732879088956228588176628932787”,“101158091151877850028968684976255873637166782454”]	1160000000000000000000	0xe449022e	0x1111111254eeb25477b68fb85ed929f73a960582	18868564	0x2faee9aa98e07ec4e37ead7afd3a462e35912f01	1263725668	2023-12-26T08:05:35.000Z	1265819010	0x5a197b9b568395726da358c8549f6972e3696d5d90df0951bad22f88bc960512

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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

gas	status	gas_used	in_anon2	signature	to_address	block_number	from_address	trace_address	block_timestamp	in_amount0Delta	in_amount1Delta	transaction_hash
56584	true	8503	0x0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582	0xfa461e33	0x1111111254eeb25477b68fb85ed929f73a960582	20756571	0xc7bbec68d12a0d1830360f8ec58fa599ba1b0e9b	0,0,0,1,2	2024-09-15T14:19:47.000Z	1387750000000000000	-3328663315	0x8606e85294e73dc241a63c2182856ab1caad75c04e8ebf1b2b36155453d8be12
56264	true	8503	0x0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582	0xfa461e33	0x1111111254eeb25477b68fb85ed929f73a960582	20754618	0x7b3ed3a3444144ff526554d5f4aa463d1759f51a	0,0,0,1,2	2024-09-15T07:47:47.000Z	624487500000000000	-7088087610220825602967	0x4162192e2157b3f72cb0c1ef0ffee201a04fdf0fd16b791315bf7f1f190284cc
49774	true	8503	0x0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582	0xfa461e33	0x1111111254eeb25477b68fb85ed929f73a960582	20755863	0x51d1ac117aadd99e7fc56e802c86a7464cb6ab9d	0,0,0,1,2	2024-09-15T11:57:35.000Z	59475000000000000	-845482565994184668942675	0x15aab3aa3049aeea93feb32c8958539065ca7a98dece6016c2a81a111a4100a4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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

gas	value	status	gas_used	in_pools	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
314346	1900000000000000000	false	123784	[]	0xbc80f1a8	0x1111111254eeb25477b68fb85ed929f73a960582	17738933	0xcc88036fa05c86129bf66260c2a905ab2c7b663c	2023-07-21T03:46:59.000Z	0x386061bf13061e5b9e034f08b283c7d16c7ed6a72de9a975c075407644c14dcb
343452	1900000000000000000	false	130442	[]	0xbc80f1a8	0x1111111254eeb25477b68fb85ed929f73a960582	17740321	0x8eb2283f696f2a130134d46e28d3528e19e16868	2023-07-21T08:27:23.000Z	0xe851b030709e8b173ac4e0aced168af35df227e3ad50884173ef7d2ce40d86d3
130816	0	false	104527	[]	0xbc80f1a8	0x1111111254eeb25477b68fb85ed929f73a960582	17742597	0x0cd83953b2098dc82d307b041e01ac796a3c80d6	2023-07-21T16:06:11.000Z	0x2c56c9d61d9ae5adc534bae35976d69ebb74487078ce571a73c713aa85c81c42

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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

gas	status	gas_used	in_pools	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
315191	false	263852	[]	0x2521b930	0x1111111254eeb25477b68fb85ed929f73a960582	16643129	0x9ecd3f09f4c6d9cf04728fc9de4feed87dfa4683	2023-02-16T18:37:59.000Z	0xa1f6009bc9a69581e86c9b19318425d74cae855baf26193586fb00a6fd4c6566
321920	false	292807	[]	0x2521b930	0x1111111254eeb25477b68fb85ed929f73a960582	16643113	0x9ecd3f09f4c6d9cf04728fc9de4feed87dfa4683	2023-02-16T18:34:47.000Z	0x5fe2b1826f0626087d4f562d8d82c70716c3aeb1bead416e0c5d04a92bc5ae93
317271	false	55749	[]	0x2521b930	0x1111111254eeb25477b68fb85ed929f73a960582	16643034	0xfa2547059302362fa3b54c00d872413716001ac6	2023-02-16T18:18:47.000Z	0x4bdf0fe574343d300fd0346b5c4a206c4c1038b9c0ed62d71e8a286eef2d6646

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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	status	gas_used	in_pools	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
148822	false	29465	[]	0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582	16273369	0x0fcfebf31fa34f1d7aca854a752bfc85564e7b3f	2022-12-27T03:22:23.000Z	0x45f8954f644e267853164f5c62c136b4acda82bda820099ec9c2f4fa9c934a31
1000000	false	31529	[]	0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582	16276714	0x00000000000124d994209fbb955e0217b5c2eca1	2022-12-27T14:35:23.000Z	0x6de6eff12d9a65a380861da790bf22cee8e675b25288e39d6a273146d7f14f4f
355000	false	31537	[]	0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582	16278035	0x5828eff23f92e582ddf4fbbc2900e7448e45bd6c	2022-12-27T19:00:35.000Z	0x2608eab6edcc8a70018338797a0525214368d969bdaf992993f873e696a7b8e7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
140950	653610000000000000	false	99441	[]	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	15990290	0x839d4641f97153b0ff26ab837860c479e2bd0242	2022-11-17T14:18:47.000Z	0x4ffedeb4746982f3bf4f6e52852f7b123675ba7ff82bfbf15331604813ae599c
215768	0	false	169820	[]	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	15987675	0x839d4641f97153b0ff26ab837860c479e2bd0242	2022-11-17T05:32:47.000Z	0x57c64c6e0ab87ef437264d5bfeea3a784fbd38bdca97e50c755d038431c7757c
222699	1014830000000000000	false	161018	[]	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	15990099	0x839d4641f97153b0ff26ab837860c479e2bd0242	2022-11-17T13:40:23.000Z	0xe6beb783810d1da785679733771aa891246d1c40ecb1072712b05007c9895e74

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_ethereum.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

gas	status	gas_used	in_pools	in_amount	in_permit	signature	to_address	in_srcToken	block_number	from_address	in_minReturn	in_recipient	block_timestamp	out_returnAmount	transaction_hash
292692	false	248663	[]			0x3c15fd91	0x1111111254eeb25477b68fb85ed929f73a960582		18449221	0xfde39bf556f0e3a078bff547c4cce631246269af			2023-10-28T14:13:35.000Z		0x3a6de9febc4f35237505ecd223ad33e2c42e109be801529b1158a33744979b0e
198970	true	161294	[“28948022309329048857349863384811638316700979361741368087269763560026110199538”]	300000000000000000000	0x000000000000000000000000535c531d41403ab933018b55cd64d0df28bf92100000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000653e3fdd000000000000000000000000000000000000000000000000000000000000001b7f8396cbc2ee322b7965b1274a9c7a6ad2d1e04c410eb5f5012f141a4ac7837930615c3f724c1d002f9c079ae02d77ba29dde43537072a762ba46f7a2a936ade	0x3c15fd91	0x1111111254eeb25477b68fb85ed929f73a960582	0x111111111117dc0aa78b770fa6a738034120c302	18448371	0x535c531d41403ab933018b55cd64d0df28bf9210	47856999055437990	0x535c531d41403ab933018b55cd64d0df28bf9210	2023-10-28T11:22:35.000Z	48097486487877377	0x1d8193f9c7eccf3ca161cb2a5f6d9a79b1c11afd7a1164e059b6c353ff676ad5
198970	true	156494	[“28948022309329048857349863384811638316700979361741368087269763560026110199538”]	64000000000000000000	0x000000000000000000000000676e08308e1073ad3e4de7e5897847b98504fd4a0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000653e8616000000000000000000000000000000000000000000000000000000000000001bba0dd48b627644dc89792d93382fda577da7e371559a9730e93dc9db36a9de8966949e6e758b0454c9bf4d038d183afa8ebba26b42ef3dc25220c5ade7eb35ba	0x3c15fd91	0x1111111254eeb25477b68fb85ed929f73a960582	0x111111111117dc0aa78b770fa6a738034120c302	18449848	0x676e08308e1073ad3e4de7e5897847b98504fd4a	10186321369099697	0x676e08308e1073ad3e4de7e5897847b98504fd4a	2023-10-28T16:19:59.000Z	10289213504141109	0xc1212cdc7b4bcd13517356644d165380734f9ef10eec1c17bc75fbaa4ad6eafc

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AggregationRouterV5_clipperSwap_function

AggregationRouterV5_clipperSwapTo_function

AggregationRouterV5_clipperSwapToWithPermit_function

AggregationRouterV5_fillOrder_function

AggregationRouterV5_fillOrderRFQ_function

AggregationRouterV5_fillOrderRFQCompact_function

AggregationRouterV5_fillOrderRFQTo_function

AggregationRouterV5_fillOrderRFQToWithPermit_function

AggregationRouterV5_fillOrderTo_function

AggregationRouterV5_fillOrderToWithPermit_function

AggregationRouterV5_OrderFilled_event

AggregationRouterV5_OrderFilledRFQ_event

AggregationRouterV5_swap_function

AggregationRouterV5_uniswapV3Swap_function

AggregationRouterV5_uniswapV3SwapCallback_function

AggregationRouterV5_uniswapV3SwapTo_function

AggregationRouterV5_uniswapV3SwapToWithPermit_function

AggregationRouterV5_unoswap_function

AggregationRouterV5_unoswapTo_function

AggregationRouterV5_unoswapToWithPermit_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​AggregationRouterV5_clipperSwap_function

​AggregationRouterV5_clipperSwapTo_function

​AggregationRouterV5_clipperSwapToWithPermit_function

​AggregationRouterV5_fillOrder_function

​AggregationRouterV5_fillOrderRFQ_function

​AggregationRouterV5_fillOrderRFQCompact_function

​AggregationRouterV5_fillOrderRFQTo_function

​AggregationRouterV5_fillOrderRFQToWithPermit_function

​AggregationRouterV5_fillOrderTo_function

​AggregationRouterV5_fillOrderToWithPermit_function

​AggregationRouterV5_OrderFilled_event

​AggregationRouterV5_OrderFilledRFQ_event

​AggregationRouterV5_swap_function

​AggregationRouterV5_uniswapV3Swap_function

​AggregationRouterV5_uniswapV3SwapCallback_function

​AggregationRouterV5_uniswapV3SwapTo_function

​AggregationRouterV5_uniswapV3SwapToWithPermit_function

​AggregationRouterV5_unoswap_function

​AggregationRouterV5_unoswapTo_function

​AggregationRouterV5_unoswapToWithPermit_function

Tables

AggregationRouterV5_clipperSwap_function

AggregationRouterV5_clipperSwapTo_function

AggregationRouterV5_clipperSwapToWithPermit_function

AggregationRouterV5_fillOrder_function

AggregationRouterV5_fillOrderRFQ_function

AggregationRouterV5_fillOrderRFQCompact_function

AggregationRouterV5_fillOrderRFQTo_function

AggregationRouterV5_fillOrderRFQToWithPermit_function

AggregationRouterV5_fillOrderTo_function

AggregationRouterV5_fillOrderToWithPermit_function

AggregationRouterV5_OrderFilled_event

AggregationRouterV5_OrderFilledRFQ_event

AggregationRouterV5_swap_function

AggregationRouterV5_uniswapV3Swap_function

AggregationRouterV5_uniswapV3SwapCallback_function

AggregationRouterV5_uniswapV3SwapTo_function

AggregationRouterV5_uniswapV3SwapToWithPermit_function

AggregationRouterV5_unoswap_function

AggregationRouterV5_unoswapTo_function

AggregationRouterV5_unoswapToWithPermit_function