1inch_v5_gnosis

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

No sample data available.

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_clipperExchange`	`STRING`	Contract address of the Clipper decentralized exchange router handling the swap execution. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_dstToken`	`STRING`	Contract address of the destination token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_inputAmount`	`STRING`	Amount of source tokens being swapped or deposited. Numeric string representation of token quantity in smallest denomination.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_goodUntil`	`STRING`	Expiration timestamp for the Clipper swap signature validity. Numeric string representing the deadline after which the signed swap parameters become invalid.
`in_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_vs`	`STRING`	ECDSA signature component vs, which combines the recovery identifier v with the signature component s for compact signature representation. 66-character hex string including 0x prefix.
`in_permit`	`STRING`	EIP-2612 permit signature data enabling gasless token approvals for the swap operation. Hex-encoded byte string containing owner address, spender address, value, deadline, and ECDSA signature components (v, r, s).
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	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	in_skipPermitAndThresholdAmount
185839	true	67975	{“salt”:“1532878060795”,“maker”:“0xc584d220de2023e2aaaaf6efe7871d7adfabb3b4”,“offsets”:“5499829121128175202955172991599148509588472975012526929879621074681856”,“receiver”:“0x26271dfddbd250014f87f0f302c099d5a798bab1”,“makerAsset”:“0xddafbb505ad214d7b80b1f830fccc89b60fb7a83”,“takerAsset”:“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”,“interactions”:“0xbf15fcd800000000000000000000000011431a89893025d2a48dca4eddc396f8c8117187000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d0063cb2c5500000000010000c584d220de2023e2aaaaf6efe7871d7adfabb3b40000000000000000000000000000000000000000000000000000000026271dfddbd250014f87f0f302c099d5a798bab1c584d220de2023e2aaaaf6efe7871d7adfabb3b4”,“makingAmount”:“35865135”,“takingAmount”:“35865135000000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	248976	248976921409282173	0xf3fa505a07c8db9e744d01779e214ed6608a4505ca7648d46b01711953d91aab	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	25977744	0x9008d19f58aabd9ed0d60971565aa8510560ab41	0x89710cbb72da4b08b558728be560cf85a7df3e394ad6700ad9b3cc47f55a9fa951ce167652b50aa7811ac98977cf94cbc3ce620585f7eeef5bc1a445969a05131b	4	0x	2023-01-15T13:53:15.000Z	248976921409282173	0x2aa0f50fbe7d31409a87eff88a5e52bae80dafbbdbb4d1908fd24a4f7d19663f	57896044618658097711785492504343953926634992332820282019728792003956565068695
185832	true	67975	{“salt”:“463972353082”,“maker”:“0x5e55b240bada3a286724ef68ee6fe5c543d6465a”,“offsets”:“5499829121128175202955172991599148509588472975012526929879621074681856”,“receiver”:“0x26271dfddbd250014f87f0f302c099d5a798bab1”,“makerAsset”:“0xddafbb505ad214d7b80b1f830fccc89b60fb7a83”,“takerAsset”:“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”,“interactions”:“0xbf15fcd800000000000000000000000011431a89893025d2a48dca4eddc396f8c8117187000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d0063c5c9df000000000000005e55b240bada3a286724ef68ee6fe5c543d6465a0000000000000000000000000000000000000000000000000000000026271dfddbd250014f87f0f302c099d5a798bab15e55b240bada3a286724ef68ee6fe5c543d6465a”,“makingAmount”:“35330546”,“takingAmount”:“35330546000000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	219109	219109241166309669	0x883acc3fb50122d87421755575593a3dbbfb1cc2368a47fc8487569052810e31	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	25977619	0x9008d19f58aabd9ed0d60971565aa8510560ab41	0x488d5c9a60ab8d02897c8ec8405ea42184fbb33bac9ad92020a31dbdbf8aa5740791cc532a6900ed5e9e69a34cba8c7af06fe89ca12dc5c3991eb6ae8f27fcc11b	4	0x	2023-01-15T13:42:30.000Z	219109241166309669	0xa68ef67a508eda01f9062b05bad4dadb8ef202e6480493127382fd80a49d5b16	57896044618658097711785492504343953926634992332820282019728792003956565038857
477943	true	141095	{“salt”:“557019568691”,“maker”:“0x44034e2261ede365b20eb18b109ca3698c19ddc9”,“offsets”:“12078056109444544136644881178716611325260305918824174400514173937123328”,“receiver”:“0x26271dfddbd250014f87f0f302c099d5a798bab1”,“makerAsset”:“0xddafbb505ad214d7b80b1f830fccc89b60fb7a83”,“takerAsset”:“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”,“interactions”:“0xbf15fcd800000000000000000000000011431a89893025d2a48dca4eddc396f8c8117187000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d0063cdae1b0000000000000044034e2261ede365b20eb18b109ca3698c19ddc900000000000000000000000000000000000000000000000000000000ddafbb505ad214d7b80b1f830fccc89b60fb7a8300000000000000000000000044034e2261ede365b20eb18b109ca3698c19ddc90000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000063cdae11000000000000000000000000000000000000000000000000000000000000001c3ead0dd45198812f79f4e148876c3a7f5a3d41e5943b6908aa01c5b117b84baf4eeb2155fead0e55ecca6a597051ce6d10b9dd09ff5d7a3bd2511410a52ddfae26271dfddbd250014f87f0f302c099d5a798bab144034e2261ede365b20eb18b109ca3698c19ddc9”,“makingAmount”:“131000000”,“takingAmount”:“131000000000000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	126999978	126999978509387563824	0xde31fceffb85c9477ff983a1eedbb607eae8884ebe59c6b896ef412234ffeedf	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	25983604	0x59a0a6d73e6a5224871f45e6d845ce1574063ade	0xb185c9727344a7175098db249ef8b57e2ab44910af9bcc3946a7eb2ccd669dedf9e560b519af90d9abcf42120322cd2eabc35c246e63c8824a27b79165a9b2d6	3,1,0,1	0x	2023-01-15T22:21:55.000Z	126999978509387563824	0x9caf372c4c5fdafe284a90c58002de3ff35b3471a89f5e225e2c210057fb5189	125729978

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_order`	`STRUCT<info STRING, makerAsset STRING, takerAsset STRING, maker STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_vs`	`STRING`	ECDSA signature component vs, which combines the recovery identifier v with the signature component s for compact signature representation. 66-character hex string including 0x prefix.
`in_flagsAndAmount`	`STRING`	Encoded integer combining order execution flags and token amount for RFQ (Request-for-Quote) orders. Numeric string representing a packed value where higher-order bits contain execution flags and lower-order bits contain the taking amount in the token’s smallest denomination.
`out_filledMakingAmount`	`STRING`	Amount of maker tokens actually filled in the RFQ (Request-for-Quote) order execution. Numeric string representing the quantity in the token’s smallest denomination.
`out_filledTakingAmount`	`STRING`	Amount of taker tokens actually filled in the RFQ (Request-for-Quote) order execution. Numeric string representing the quantity in the token’s smallest denomination.
`out_orderHash`	`STRING`	Unique identifier hash for the order being filled. 66-character hex string including 0x prefix.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_order`	`STRUCT<info STRING, makerAsset STRING, takerAsset STRING, maker STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_flagsAndAmount`	`STRING`	Encoded integer combining order execution flags and token amount for RFQ (Request-for-Quote) orders. Numeric string representing a packed value where higher-order bits contain execution flags and lower-order bits contain the taking amount in the token’s smallest denomination.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`out_filledMakingAmount`	`STRING`	Amount of maker tokens actually filled in the RFQ (Request-for-Quote) order execution. Numeric string representing the quantity in the token’s smallest denomination.
`out_filledTakingAmount`	`STRING`	Amount of taker tokens actually filled in the RFQ (Request-for-Quote) order execution. Numeric string representing the quantity in the token’s smallest denomination.
`out_orderHash`	`STRING`	Unique identifier hash for the order being filled. 66-character hex string including 0x prefix.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_order`	`STRUCT<info STRING, makerAsset STRING, takerAsset STRING, maker STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_flagsAndAmount`	`STRING`	Encoded integer combining order execution flags and token amount for RFQ (Request-for-Quote) orders. Numeric string representing a packed value where higher-order bits contain execution flags and lower-order bits contain the taking amount in the token’s smallest denomination.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_permit`	`STRING`	EIP-2612 permit signature data enabling gasless token approvals for the swap operation. Hex-encoded byte string containing owner address, spender address, value, deadline, and ECDSA signature components (v, r, s).
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon1`	`STRING`	Actual amount of tokens received by the taker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon2`	`STRING`	Unique identifier hash for the executed order. 66-character hex string including 0x prefix.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_order_`	`STRUCT<salt STRING, makerAsset STRING, takerAsset STRING, maker STRING, receiver STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING, offsets STRING, interactions STRING>`	Structured order parameters defining the maker-taker exchange agreement in 1inch RFQ orders. Contains salt for uniqueness, maker and taker asset addresses, participant addresses (maker, receiver, allowedSender), token amounts (makingAmount, takingAmount), offsets for bitfield encoding, and interactions for custom execution logic.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_interaction`	`STRING`	Encoded data for custom interactions executed during order fulfillment. Hex-encoded byte string, typically 0x-prefixed.
`in_makingAmount`	`STRING`	Amount of tokens provided by the maker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_takingAmount`	`STRING`	Amount of tokens requested from the taker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_skipPermitAndThresholdAmount`	`STRING`	Bitfield parameter combining permit-skipping flag and minimum threshold amount for order execution. Numeric string encoding both a boolean flag (in the highest bit) to skip EIP-2612 permit processing and a threshold amount (in remaining bits) specifying the minimum acceptable taking amount.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`out_actualMakingAmount`	`STRING`	Actual amount of maker tokens transferred in the order execution. Numeric string representing the token quantity in its smallest denomination.
`out_actualTakingAmount`	`STRING`	Actual amount of taker tokens transferred in the order execution. Numeric string representing the token quantity in its smallest denomination.
`out_orderHash`	`STRING`	Unique identifier hash for the order being filled. 66-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	in_order_	in_target	signature	to_address	block_number	from_address	in_signature	out_orderHash	trace_address	in_interaction	block_timestamp	in_takingAmount	transaction_hash	out_actualMakingAmount	out_actualTakingAmount	in_skipPermitAndThresholdAmount
117334	true	75614	{“salt”:“240796163610”,“maker”:“0x8c8868c77e0546b34f196595f0e727bc1add2e4d”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0xdd96b45877d0e8361a4ddb732da741e97f3191ff”,“takerAsset”:“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”,“interactions”:“0xbf15fcd800000000000000000000000011431a89893025d2a48dca4eddc396f8c8117187000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d00667d53e4000000000000008c8868c77e0546b34f196595f0e727bc1add2e4d00000000000000000000000000000000000000000000000000000000”,“makingAmount”:“12375226776574504446”,“takingAmount”:“8000000000000000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x111111125421ca6dc452d289314280a0f8842a65	0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	33005868	0xf5ab9bf279284fb8e3de1c3bf0b0b4a6fb0bb538	0x15343d0f19a430196a20538dd42e49d3952e15f0963d574caec6605561b2aee0f09168631c9a94cff4220bb39f187259858727ac0384bd6ac1e16f5f50717f53	0x834fe019f39eec131c362bf4e64d0dc965b116c0c16614c0740ed95d9209636a	0,2	0x	2024-03-19T08:07:00.000Z	200000000000000000	0xdd4fcea78dbc41e74cb2fa95a9702bc6bb97f1189cc0196707dd59ecdd9eb869	309380669414362	200000000000000000	57896044618658097711785492504343953926634992332820282019728792310243427540186
117334	true	75614	{“salt”:“240796163610”,“maker”:“0x8c8868c77e0546b34f196595f0e727bc1add2e4d”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0xdd96b45877d0e8361a4ddb732da741e97f3191ff”,“takerAsset”:“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”,“interactions”:“0xbf15fcd800000000000000000000000011431a89893025d2a48dca4eddc396f8c8117187000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d00667d53e4000000000000008c8868c77e0546b34f196595f0e727bc1add2e4d00000000000000000000000000000000000000000000000000000000”,“makingAmount”:“12375226776574504446”,“takingAmount”:“8000000000000000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x111111125421ca6dc452d289314280a0f8842a65	0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	33015942	0xf5ab9bf279284fb8e3de1c3bf0b0b4a6fb0bb538	0x15343d0f19a430196a20538dd42e49d3952e15f0963d574caec6605561b2aee0f09168631c9a94cff4220bb39f187259858727ac0384bd6ac1e16f5f50717f53	0x834fe019f39eec131c362bf4e64d0dc965b116c0c16614c0740ed95d9209636a	0,2	0x	2024-03-19T22:48:50.000Z	199970000000000000	0xbc4668f2b963cbb6799dcade50fbf4dec12778b199e2d77583853e919cd218ea	309334262313950	199970000000000000	57896044618658097711785492504343953926634992332820282019728792310197484510778
117334	true	75614	{“salt”:“240796163610”,“maker”:“0x8c8868c77e0546b34f196595f0e727bc1add2e4d”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0xdd96b45877d0e8361a4ddb732da741e97f3191ff”,“takerAsset”:“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”,“interactions”:“0xbf15fcd800000000000000000000000011431a89893025d2a48dca4eddc396f8c8117187000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d00667d53e4000000000000008c8868c77e0546b34f196595f0e727bc1add2e4d00000000000000000000000000000000000000000000000000000000”,“makingAmount”:“12375226776574504446”,“takingAmount”:“8000000000000000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x111111125421ca6dc452d289314280a0f8842a65	0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	33009840	0xf5ab9bf279284fb8e3de1c3bf0b0b4a6fb0bb538	0x15343d0f19a430196a20538dd42e49d3952e15f0963d574caec6605561b2aee0f09168631c9a94cff4220bb39f187259858727ac0384bd6ac1e16f5f50717f53	0x834fe019f39eec131c362bf4e64d0dc965b116c0c16614c0740ed95d9209636a	0,2	0x	2024-03-19T13:55:35.000Z	199970000000000000	0x7e8407d3d9a4ad239110dffe0f5ecdd67ce4d115ff3b96e5b400d922910a90aa	309334262313950	199970000000000000	57896044618658097711785492504343953926634992332820282019728792310197484510778

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	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
462343	true	314248	{“salt”:“1103666344763”,“maker”:“0xaf4d91250065e756276d89584f414b58a9bce5c9”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x19a6a39b746c4647a01a3bf80751155969ddb15a”,“takerAsset”:“0xddafbb505ad214d7b80b1f830fccc89b60fb7a83”,“interactions”:“0xbf15fcd800000000000000000000000011431a89893025d2a48dca4eddc396f8c8117187000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d0063a80e1000000000000001af4d91250065e756276d89584f414b58a9bce5c900000000000000000000000000000000000000000000000000000000”,“makingAmount”:“1000000000000000000”,“takingAmount”:“50370000”,“allowedSender”:“0x540a623c7ed0c09e1b3916a83d93f2f59d44ea89”}	0xddafbb505ad214d7b80b1f830fccc89b60fb7a83000000000000000000000000540a623c7ed0c09e1b3916a83d93f2f59d44ea890000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000063a47d19000000000000000000000000000000000000000000000000000000000000001baff0abc2374757df0d6a42e7c16ce31a3a0b6a2c846d86138fba468e70577b8b74bb8426a3b11acb3a17aed85951c6e8c9eb33b3a6aa1344980efa29fe0be46b	0x540a623c7ed0c09e1b3916a83d93f2f59d44ea89	1000000000000000000	50370000	0xa497e53871af7eec3f109f95b9057c1b98872fe96ecfd5ee90a8f25cc7fa1397	0xd365c695	0x1111111254eeb25477b68fb85ed929f73a960582	25579229	0x540a623c7ed0c09e1b3916a83d93f2f59d44ea89	0x06cea860aca670ce81ab5cc30d9e3c1b73f788d099315dbba3f0b258b8afd8cff9a6287ab8a5c6a915ae77479d49fedf7273d6f6efc16245b81dddf76439401a	0x	2022-12-22T14:52:35.000Z	50370000	0xdc8653de4bae1e07c0327fd202396bb42f1099a5f547ba2d5cc905d031a44146	57896044618658097711785492504343953926634992332820282019729792003956564819968
505953	true	348424	{“salt”:“784681275868”,“maker”:“0x6d03e37308fd0110c099191e1b1ddb7c3a611845”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x529ff4d9b07acd6366d0c3eb077ebaa2b06e71c4”,“takerAsset”:“0xddafbb505ad214d7b80b1f830fccc89b60fb7a83”,“interactions”:“0xbf15fcd800000000000000000000000011431a89893025d2a48dca4eddc396f8c8117187000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d0063939030000000000000016d03e37308fd0110c099191e1b1ddb7c3a61184500000000000000000000000000000000000000000000000000000000”,“makingAmount”:“4000000000000000000”,“takingAmount”:“200000000”,“allowedSender”:“0xa5ed8da239f400141427800da33b602a039f2254”}	0xddafbb505ad214d7b80b1f830fccc89b60fb7a83000000000000000000000000a5ed8da239f400141427800da33b602a039f22540000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000063939ccc000000000000000000000000000000000000000000000000000000000000001bda32ce74868fd1d91fce58c184d520948aa3ae8ee247e70f1b93d8b5a88736a8106d8f18a2b62c974d801041281dba8b4eaa59716999895c06d5bd70d68f878f	0xa5ed8da239f400141427800da33b602a039f2254	4000000000000000000	200000000	0x9eac8c583234682eb22a083e0fa643e23697861d507a2b04d8c52faeb0ddaf9e	0xd365c695	0x1111111254eeb25477b68fb85ed929f73a960582	25366556	0xa5ed8da239f400141427800da33b602a039f2254	0x7623469edb863785e6ae9dbe06cdca5068b8e1255c6f7676aca3cd32fbd6e58fb8c37c637ce1b85f4fdedea392c41c33e55e8dcb00fa5b4bbaeae2edd4c69203	0x	2022-12-09T19:39:00.000Z	200000000	0x6f32ae53ac121c0ad08bff9f3985de56a10a9a7f0be39a85f032569b05acf667	57896044618658097711785492504343953926634992332820282019732792003956564819968
210289	true	177553	{“salt”:“17070159267”,“maker”:“0x3b608c5243732903152e38f1dab1056a4a79b980”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x4f4f9b8d5b4d0dc10506e5551b0513b61fd59e75”,“takerAsset”:“0xeeeeeb57642040be42185f49c52f7e9b38f8eeee”,“interactions”:“0xbf15fcd800000000000000000000000011431a89893025d2a48dca4eddc396f8c8117187000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d0064f1b0ec000000000500003b608c5243732903152e38f1dab1056a4a79b98000000000000000000000000000000000000000000000000000000000”,“makingAmount”:“500000000000000000000”,“takingAmount”:“60000000000000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0xeeeeeb57642040be42185f49c52f7e9b38f8eeee000000000000000000000000633a626e57939810033358a5fcc0768f44457f410000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064f2fd2e000000000000000000000000000000000000000000000000000000000000001b658ab300dafb60a68a10f07db3ed1e87eff8e48809e0f79c2d01e34f46f2fe87475d0d90b290f16e6d91717cd5dacc810cfd14d81017ecfaef4a521562bdebda	0x3b608c5243732903152e38f1dab1056a4a79b980	500000000000000000000	60000000000000000000	0xc5916d95e9a2967df6db6345970d72a1e2180d6cf9eb6615947c9eadb4842255	0xd365c695	0x1111111254eeb25477b68fb85ed929f73a960582	29753079	0x633a626e57939810033358a5fcc0768f44457f41	0x9ccebf7530229cfa1372dcaabec86ab61d7150a398f36363543ba9c15b93ac6f6a96ae2cb08dc84135e574b596d149918e6fa3db548e762339f67221803c2a291b	0x	2023-09-01T09:16:30.000Z	60000000000000000000	0x9f573b453be5de5a753e4a9ac60c400e1ec90f5781b69fd17cd8310caf239e2f	57896044618658097711785492504343953926634992332820282020223792003956564819968

Example Query

Query with partition filter

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

AggregationRouterV5_OrderFilled_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_maker`	`STRING`	Address of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
`in_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_remaining`	`STRING`	Remaining amount after the operation. Decimal-encoded string representing token quantity or order size left unfilled.

Sample Data

address	removed	in_maker	block_number	in_orderHash	block_timestamp	transaction_hash
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x64cfa69fe7cc656af99b3312802dc4b87e45575d	27902339	0xb4e08c604a4987f45a0973723802f6f0cf5aa49f4732730731a9f01cdd56c3c1	2023-05-12T07:17:35.000Z	0x34a0cb7865f20f2fc9593092622020dcae2b84a5f67f6653afa3af3588a75705
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x28c1e820706d946a7b43f2c9b79427fb0522eb64	27899399	0x6434735e71f1bd289dd61776406a21bb98e3f6dbcaa07031935b657af9187b23	2023-05-12T03:01:00.000Z	0xfe7c0d234f988e1678ddf9e1768df6dd0bb4d1609c9cc66759fdbcc7aa6e4e9a
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x0cfdccb038208b260e96e92f68d6f59b0ffb3c2a	27904217	0x9400febc8fd5e735c352d053781b1181761927d1fbf9c6241b3c7875c8b12fb9	2023-05-12T10:00:55.000Z	0xa557dcc3c551ada35979260428f2cf897f94ab43acd6a8f1c0d07e597db95e77

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	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
496458	false	421329	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	35321476	0x4cb6f0ef0eeb503f8065af1a6e6d5dd46197d3d9	2024-08-05T01:14:00.000Z	0x8c2069ff56848439ca495a600bd42df84860bdde20c29decf8d9da862b340c15
484774	false	182556	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	35321471	0x4cb6f0ef0eeb503f8065af1a6e6d5dd46197d3d9	2024-08-05T01:13:30.000Z	0xe7a358779cc784f54a13d323c9142fb147e9016a3ebc9a817ffbb9194b7584ed
485037	false	182556	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	35321480	0x4cb6f0ef0eeb503f8065af1a6e6d5dd46197d3d9	2024-08-05T01:14:25.000Z	0xc79da02d76ebb29aaac9137520155a34e5a2694da066d9425804eabb09ce0225

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_minReturn`	`STRING`	Minimum acceptable output amount for the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_pools`	`ARRAY<STRING>`	Array of encoded pool identifiers for routing token swaps through decentralized exchanges. Elements are numeric strings representing packed pool addresses and swap parameters.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	value	status	gas_used	in_pools	in_amount	signature	to_address	block_number	from_address	in_minReturn	trace_address	block_timestamp	out_returnAmount	transaction_hash
201881	0	false	26525	[“57896044618658097711785492504623877974012633783033462279607100459384252236215”]	78627000	0xe449022e	0x1111111254eeb25477b68fb85ed929f73a960582	31229059	0x20272463aa2a7c0e3f11555b4fb9cb542278b316	78244651		2023-12-01T21:27:00.000Z		0xe0c000ba3763ac373d2fe0b58adf4b62e65e4520a265889944c322b9a5c93385

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_amount0Delta`	`STRING`	Change in amount for the first token in a Uniswap V3 liquidity pool swap. Positive values indicate tokens owed to the pool, negative values indicate tokens owed to the recipient.
`in_amount1Delta`	`STRING`	Change in amount for the second token in a Uniswap V3 liquidity pool swap. Positive values indicate tokens owed to the pool, negative values indicate tokens owed to the recipient.
`in_anon2`	`STRING`	Third parameter passed to the Uniswap V3 swap callback function. Hex-encoded, 0x-prefixed, 66-character string representing contextual data for the swap operation.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_minReturn`	`STRING`	Minimum acceptable output amount for the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_pools`	`ARRAY<STRING>`	Array of encoded pool identifiers for routing token swaps through decentralized exchanges. Elements are numeric strings representing packed pool addresses and swap parameters.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_minReturn`	`STRING`	Minimum acceptable output amount for the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_pools`	`ARRAY<STRING>`	Array of encoded pool identifiers for routing token swaps through decentralized exchanges. Elements are numeric strings representing packed pool addresses and swap parameters.
`in_permit`	`STRING`	EIP-2612 permit signature data enabling gasless token approvals for the swap operation. Hex-encoded byte string containing owner address, spender address, value, deadline, and ECDSA signature components (v, r, s).
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_minReturn`	`STRING`	Minimum acceptable output amount for the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_pools`	`ARRAY<STRING>`	Array of encoded pool identifiers for routing token swaps through decentralized exchanges. Elements are numeric strings representing packed pool addresses and swap parameters.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	value	status	gas_used	in_pools	in_amount	signature	to_address	in_srcToken	block_number	from_address	in_minReturn	block_timestamp	out_returnAmount	transaction_hash
199562	0	true	122259	[“1457117133085500360141846234485816116193016710546195098690”]	103858	0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582	0x4ecaba5870353805a9f068101a40e0f32ed605c6	30390106	0x5afad1e172b55f59674cd2cea5aca8c4ba0768c6	102698	2023-10-10T14:46:40.000Z	103736	0x393e45d9dcd9c4ec3c4c3dee0f7ef5e2d43de6da008fe7d5f8343f006e5140ad
199476	70000000000000000	true	124144	[“57896044618658097713242609636896662061323848806899252369675240283294921511256”]	70000000000000000	0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	30390059	0x5afad1e172b55f59674cd2cea5aca8c4ba0768c6	68958	2023-10-10T14:42:40.000Z	69655	0x43c9c50c093716c329a930bf55d29c60202c7c2621213ad5d97cce88d04f1e62
173420	70000000000000000	true	107044	[“57896044618658097713242609636896662061323848806899252369675240283294921511256”]	70000000000000000	0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	30390064	0x5afad1e172b55f59674cd2cea5aca8c4ba0768c6	68946	2023-10-10T14:43:05.000Z	69643	0xea367dac75cb2673793c956073b473f5288618e2d51977e964faca7765538576

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_minReturn`	`STRING`	Minimum acceptable output amount for the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_pools`	`ARRAY<STRING>`	Array of encoded pool identifiers for routing token swaps through decentralized exchanges. Elements are numeric strings representing packed pool addresses and swap parameters.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	value	status	gas_used	in_pools	in_amount	signature	to_address	in_srcToken	block_number	from_address	in_minReturn	in_recipient	trace_address	block_timestamp	out_returnAmount	transaction_hash
150277	0	true	85561	[“28948022309329048857349863386038470774131483111621717593275450613963267450927”]	902566154654533671384	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	0x84e2c67cbefae6b5148fca7d02b341b12ff4b5bb	34766633	0xc629bf86f02ef13e8f1f5f75ade8a8165587998f	7059114337493229131	0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f	4,2	2024-07-02T20:41:05.000Z	7073260859211652436	0xbbb040c7cda32bf0b80c675a6cbd034d0b34670e07844039060e9c73aff10c58
91546	0	true	86327	[“28948022309329048857349863384876850025914843375213312636828750771533354800550”]	9860490000000000	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	0x9c58bacc331c9aa871afd802db6379a98e80cedb	34762906	0x3a23f943181408eac424116af7b7790c94cb97a5	2817241478393000852	0x49cc048d0cd136d28d6ca929a6a55e45fb4ecf84	0,2,2	2024-07-02T15:15:25.000Z	2831398470746734525	0x7aa2c40d9a61fd2610b302181bad3cf16eb4a748acec44b5452c04f1b9ba8408
91385	2383200000000000000	true	88450	[“57896044618658097713242609636852007606232263274848701514015214829526414512745”]	2383200000000000000	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	34762912	0x3a23f943181408eac424116af7b7790c94cb97a5	8227922468229093	0x49cc048d0cd136d28d6ca929a6a55e45fb4ecf84	0,2,0	2024-07-02T15:16:00.000Z	8269268812290546	0x09439ce1418b1a538f36061efc64a169b88e2c606a9698cf71727f9aa386b74d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.1inch_v5_gnosis.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`	`NUMERIC`	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
265018	true	156785	[“28948022309329048857349863385636181160097119004862305837719565048227059595863”]	11490000000000000000	0x000000000000000000000000155294cd322814d95db37775e524b37dfca23f8f0000000000000000000000001111111254eeb25477b68fb85ed929f73a9605820000000000000000000000000000000000000000000000009f74ae1f953d00000000000000000000000000000000000000000000000000000000000065502a19000000000000000000000000000000000000000000000000000000000000001c9783ec48154f3979ad28da8077a8999ef7dfa6348e8efcb5d548e1d5cd01b32d08ac0adca08df8ae34d64a0a41424645be3ff3beacedc4b2a09133ef82e54ad9	0x3c15fd91	0x1111111254eeb25477b68fb85ed929f73a960582	0x4f4f9b8d5b4d0dc10506e5551b0513b61fd59e75	30900222	0x155294cd322814d95db37775e524b37dfca23f8f	102446357270675355	0x155294cd322814d95db37775e524b37dfca23f8f	2023-11-11T12:58:15.000Z	103481168960278137	0xbe3ce9be95329bfe348f4d6b9866b5c90c7496318468ecffb7609809d0df3189
209856	true	172180	[“86844066927987146569135355890368261266702552827944967038224658306536728550902”]	1550000000000000000	0x0000000000000000000000003e6ab3fdf4a65625d15fcc02728d258b7f3ba5420000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000065005bf6000000000000000000000000000000000000000000000000000000000000001b4f1540966f94e66f73d76b9eb375027638056063c1ec39986c6aac3eb8b89f47457fd18477087043eefd875bda5f57a59a0584dbd1b238b8e7425a68a31e36d9	0x3c15fd91	0x1111111254eeb25477b68fb85ed929f73a960582	0xeeeeeb57642040be42185f49c52f7e9b38f8eeee	29921617	0x3e6ab3fdf4a65625d15fcc02728d258b7f3ba542	130227193483868414	0x3e6ab3fdf4a65625d15fcc02728d258b7f3ba542	2023-09-11T12:39:30.000Z	130357551034903318	0x65e9ab55d11046b76d52e3773ec675026a42680c34152cf88e7e3fabe993d17c
265070	true	152021	[“28948022309329048857349863385636181160097119004862305837719565048227059595863”]	4113053367579908675	0x0000000000000000000000000b183853c1c9f9485b2c3786df7961f86635e3ac0000000000000000000000001111111254eeb25477b68fb85ed929f73a9605820000000000000000000000000000000000000000000000003914803ef4d31a4300000000000000000000000000000000000000000000000000000000658aaa3e000000000000000000000000000000000000000000000000000000000000001c049090160cfc0a9d135b5370b16cb59421a232039c1cabdd8c709b165ec90a015b769fa787f083b4eb6b44a5f59c628558e0cb7726ebafc7ff8ec84fb9fd2c15	0x3c15fd91	0x1111111254eeb25477b68fb85ed929f73a960582	0x4f4f9b8d5b4d0dc10506e5551b0513b61fd59e75	31625124	0x0b183853c1c9f9485b2c3786df7961f86635e3ac	37770923326549321	0x0b183853c1c9f9485b2c3786df7961f86635e3ac	2023-12-25T21:56:20.000Z	38152447804595274	0x0c5dbf81bb7a810738cad195d79455911dbf8b28995433dfdc780fe507c03f41

Example Query

Query with partition filter

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