1inch_v4_ethereum

Tables

AggregationRouterV4_clipperSwap_function

Individual swap executions through 1inch v4’s Clipper exchange integration on Ethereum. Records token pairs, amounts, minimum return thresholds, and actual return amounts for analyzing Clipper route performance and slippage outcomes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_dstToken`	`STRING`	Contract address of the destination token being received from the swap. 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.
`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_amount	signature	to_address	in_dstToken	in_srcToken	block_number	from_address	in_minReturn	trace_address	block_timestamp	out_returnAmount	transaction_hash
167824	true	129339	8080382200	0xb0431182	0x1111111254fb6c44bac0bed2854e76f90643097d	0x0000000000000000000000000000000000000000	0xdac17f958d2ee523a2206206994597c13d831ec7	13876685	0x74de5d4fcbf63e00296fd95d33236b9794016631	1912221597811648130	1,0,1	2021-12-25T21:07:04.000Z	1965896520437994265	0xfaae188ea7a733e9c8293ed206644448181d98c8d1bfc9cbb693dce0523e8a71
167821	true	129339	10000000000	0xb0431182	0x1111111254fb6c44bac0bed2854e76f90643097d	0x0000000000000000000000000000000000000000	0xdac17f958d2ee523a2206206994597c13d831ec7	13876807	0x74de5d4fcbf63e00296fd95d33236b9794016631	2352921847820253758	1,0,1	2021-12-25T21:30:02.000Z	2425692626618818308	0x54247a9cd8aa0857fba500f95e73fb9218aff9a5d0b4ee52e59a349f96dabd12
175556	true	135997	21557000000	0xb0431182	0x1111111254fb6c44bac0bed2854e76f90643097d	0x0000000000000000000000000000000000000000	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	13875330	0x74de5d4fcbf63e00296fd95d33236b9794016631	5113413196987139187	1,0,1	2021-12-25T16:04:22.000Z	5264646312950966668	0x9740acc00d155e0520f49b863eb0545ab39392fa659ff398e3fc4c1412aa9bf7

Example Query

Query with partition filter

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

AggregationRouterV4_clipperSwapTo_function

Clipper swap function calls from 1inch Aggregation Router V4 on Ethereum, routing trades through Clipper DEX with source token, destination token, amounts, and minimum return parameters. Contains both successful and failed swap attempts for analyzing routing efficiency and transaction outcomes.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_dstToken`	`STRING`	Contract address of the destination token being received from the swap. 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.
`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	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
221000	0	false	77985	0x9994dd15	0x1111111254fb6c44bac0bed2854e76f90643097d	15123625	0xa58818f1ca5a7dd524eca1f89e2325e15bad6cc4	2022-07-11T20:51:11.000Z	0x56423a3acf643ad19b3c6e37ca8ec8dba554a9c67e523d533e73f3f51c4dc3c7
211000	0	false	77985	0x9994dd15	0x1111111254fb6c44bac0bed2854e76f90643097d	15123592	0xa58818f1ca5a7dd524eca1f89e2325e15bad6cc4	2022-07-11T20:43:51.000Z	0xc84f267a02dfc81c9f86551295c48c046951eb7fbad04aef060bbe80341780fe
299998	10000000000000000	false	46764	0x9994dd15	0x1111111254fb6c44bac0bed2854e76f90643097d	17973378	0xb6f1f501ba37551964c9b23b4c38faed71ddeafa	2023-08-22T22:57:11.000Z	0xb4d04cda365a24f082c425a7f84762c2f4f58fc2668b54957372dbe420a3f661

Example Query

Query with partition filter

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

AggregationRouterV4_clipperSwapToWithPermit_function

Clipper swap executions from 1inch v4 aggregation router on Ethereum using EIP-2612 gasless approvals (permit signatures). Contains token swaps between USDC and ETH/WBTC with source amount, destination token, minimum return, and actual return amount for analyzing DEX aggregation efficiency.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_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_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_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_amount	in_permit	signature	to_address	in_dstToken	in_srcToken	block_number	from_address	in_minReturn	in_recipient	block_timestamp	out_returnAmount	transaction_hash
263679	true	224667	9024749414	0x000000000000000000000000296455465396ff9db0c08fdffa68a4fc2c96075a0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097dffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000061dabb98000000000000000000000000000000000000000000000000000000000000001bcc449aac1082c1dd8204a69e780490f2b92a132fa28994a508ee04afeddfcd8f0f8fd0a7175e8ad0ad4d49e4ce639fb5a9ec9c5ecc9235dd37df9130fc5fdef4	0xd6a92a5d	0x1111111254fb6c44bac0bed2854e76f90643097d	0x0000000000000000000000000000000000000000	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	13967409	0x296455465396ff9db0c08fdffa68a4fc2c96075a	2895381031302178800	0x296455465396ff9db0c08fdffa68a4fc2c96075a	2022-01-08T22:11:37.000Z	2906847417010626659	0x4398072aea428d86808edf38e3d1e22d88dcc08331de4edb02bc299bdb077933
263679	true	224667	17776065975	0x000000000000000000000000914d5674b1fcbcdfa8ec452e5e4a539048bcafe50000000000000000000000001111111254fb6c44bac0bed2854e76f90643097dffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000061dab81a000000000000000000000000000000000000000000000000000000000000001bd3eb7fc9e069bd40bc62f31892c2581d8f950ed2298f51ca964773df302aec2e33794c245bafeff449a107a483198c7990dfc760eb16ccaa350d370c1b59e57f	0xd6a92a5d	0x1111111254fb6c44bac0bed2854e76f90643097d	0x0000000000000000000000000000000000000000	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	13967337	0x914d5674b1fcbcdfa8ec452e5e4a539048bcafe5	5618970704917528617	0x914d5674b1fcbcdfa8ec452e5e4a539048bcafe5	2022-01-08T21:56:20.000Z	5792753304038689296	0xaa03b0001442654ea710bed2245ea2d4374ec0cf16383356d844cafc34f04b9e
263679	true	224667	6984873681	0x000000000000000000000000e610c34f333c2ec6a003170880f3fe7a3724c8e90000000000000000000000001111111254fb6c44bac0bed2854e76f90643097dffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000061c5572a000000000000000000000000000000000000000000000000000000000000001b1d584af35f09c3246189a9b2f67fe2cfa61ca5c725af10e8817d1577282902934a3f33afb1255c5d1b8fa70c30dda9235ad6a259f4ae1abbfb92745d9667cb74	0xd6a92a5d	0x1111111254fb6c44bac0bed2854e76f90643097d	0x0000000000000000000000000000000000000000	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	13862586	0xe610c34f333c2ec6a003170880f3fe7a3724c8e9	1747666658340843157	0xe610c34f333c2ec6a003170880f3fe7a3724c8e9	2021-12-23T16:44:41.000Z	1765319856909942583	0xda3facad8cf25d6331ecc16da89c5f5dafb5a3880cde15ca3424cdfd56b08a01

Example Query

Query with partition filter

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

AggregationRouterV4_fillOrderRFQ_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`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_makingAmount`	`STRING`	Amount of tokens provided by the maker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_takingAmount`	`STRING`	Amount of tokens requested from the taker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon1`	`STRING`	Actual amount of tokens received by the taker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
458968	false	1529	0xd0a3b665	0x1111111254fb6c44bac0bed2854e76f90643097d	14986071	0x2057cfb9fd11837d61b294d514c5bd03e5e7189a	1,1,1,0,2	2022-06-18T16:58:07.000Z	0x0ef5c874248aa30f19231904cbb623592519557e43089a4b7fe6cee7f742e663
723464	false	1529	0xd0a3b665	0x1111111254fb6c44bac0bed2854e76f90643097d	14986672	0x2057cfb9fd11837d61b294d514c5bd03e5e7189a	1,3,2	2022-06-18T19:25:08.000Z	0xfb556c0e2325c01cf0385a015e26c9af3cb8fa7eb5e1380bbbfd6eb409f5beb6
1283963	false	1529	0xd0a3b665	0x1111111254fb6c44bac0bed2854e76f90643097d	14986536	0x2057cfb9fd11837d61b294d514c5bd03e5e7189a	1,1,1,0,2	2022-06-18T18:49:27.000Z	0x7700718853e3b0364408098e7d6c0302c53b656571994ef369fe739bbe6b91de

Example Query

Query with partition filter

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

AggregationRouterV4_fillOrderRFQTo_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`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_makingAmount`	`STRING`	Amount of tokens provided by the maker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_takingAmount`	`STRING`	Amount of tokens requested from the taker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon1`	`STRING`	Actual amount of tokens received by the taker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_order	in_target	out_anon0	out_anon1	signature	to_address	block_number	from_address	in_signature	trace_address	block_timestamp	in_takingAmount	transaction_hash
749996	true	58698	{“info”:“30751300141344956867769365458”,“maker”:“0x945bcf562085de2d5875b9e2012ed5fd5cfab927”,“makerAsset”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“takerAsset”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“makingAmount”:“56167215961465740000”,“takingAmount”:“89977000000”,“allowedSender”:“0x2c54b300ac0f7ba014eb9223883276fd1f9fba35”}	0xb0273284f69bee017b5332b81b668aebeea22532	56167215961465740000	89977000000	0xbaba5855	0x1111111254fb6c44bac0bed2854e76f90643097d	15852458	0x2c54b300ac0f7ba014eb9223883276fd1f9fba35	0xa4dae0837f6f5194b206ba607d88985201ecadea4f4cad3748180bcbe44438d65fe0391216c4f6cc92250b7b9edcab4c3a52b2920391abfcdd7f41b3d02ddfe01b	4,0	2022-10-29T08:14:59.000Z	89977000000	0xa0c2f108dd9cfe45cfac108438795f883102841e53ce59c86ec4d5972028b78a
775678	true	58718	{“info”:“30750917389852171468262136213”,“maker”:“0x945bcf562085de2d5875b9e2012ed5fd5cfab927”,“makerAsset”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“takerAsset”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“makingAmount”:“57552820947077684000”,“takingAmount”:“89977000000”,“allowedSender”:“0x650a17a305b69d60c471591794f7564670afb98d”}	0xb0273284f69bee017b5332b81b668aebeea22532	57552820947077684000	89977000000	0xbaba5855	0x1111111254fb6c44bac0bed2854e76f90643097d	15850736	0x650a17a305b69d60c471591794f7564670afb98d	0x9dac51afce71b1ad2ef14de76748b6873c018855e7e1e7540823ea5dd17cc5a46088c64968c60ad63837a0373fd7d38eaf9e814a912ecd2dba13a6d384e29cf21c	3,0	2022-10-29T02:28:47.000Z	89977000000	0x31d9bd8acc82cab316a9bb4f19e880b76c4cb9c5b15503fcc4bb2e8ca4212189
738284	true	59982	{“info”:“30716518952967930095988318937”,“maker”:“0x945bcf562085de2d5875b9e2012ed5fd5cfab927”,“makerAsset”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“takerAsset”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“makingAmount”:“66812424741534340000”,“takingAmount”:“90000000000”,“allowedSender”:“0x3d5d77852e2806160abe0dee906d49355e939aab”}	0xb0273284f69bee017b5332b81b668aebeea22532	66812424741534340000	90000000000	0xbaba5855	0x1111111254fb6c44bac0bed2854e76f90643097d	15696234	0x3d5d77852e2806160abe0dee906d49355e939aab	0xcb7a0cc60503cbdd35a82ee806cb6327dd54ab6ee3c8638f577846e50c6964a50c9b4be38706c71e5ee1a6a0fe9c900265cf96c300744d7ac8f8dfe0b9fbf9451b	4,0	2022-10-07T12:29:35.000Z	90000000000	0x2f732e0de67a1fe4093492cb8a56a85e7f629b514b82912a4be9150c1a2b57e3

Example Query

Query with partition filter

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

AggregationRouterV4_fillOrderRFQToWithPermit_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`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_makingAmount`	`STRING`	Amount of tokens provided by the maker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_takingAmount`	`STRING`	Amount of tokens requested from the taker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_permit`	`STRING`	EIP-2612 permit signature data enabling gasless token approvals for the swap operation. Hex-encoded byte string containing owner address, spender address, value, deadline, and ECDSA signature components (v, r, s).
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon1`	`STRING`	Actual amount of tokens received by the taker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

gas	status	gas_used	in_order	in_permit	in_target	out_anon0	out_anon1	signature	to_address	block_number	from_address	in_signature	block_timestamp	in_makingAmount	in_takingAmount	transaction_hash
290625	false	100170						0x4cc4a27b	0x1111111254fb6c44bac0bed2854e76f90643097d	15905356	0xa8cadc2268b01395f8573682fb9dd00bd582e8a0		2022-11-05T17:38:47.000Z			0x82dfae20ffd325a6c07493d3a783530a6b50fe94c51b007f3462d90d0985d8db
290642	false	100182						0x4cc4a27b	0x1111111254fb6c44bac0bed2854e76f90643097d	15905356	0xa8cadc2268b01395f8573682fb9dd00bd582e8a0		2022-11-05T17:38:47.000Z			0xe264c90e01a3f33617a195aec65c64e98c156fac9954bf6028bc76b1713fccb9
681320	true	165530	{“info”:“30762864727633826590480893632”,“maker”:“0xb398ffef80144095b8712c70a0c09886c8151feb”,“makerAsset”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“takerAsset”:“0x111111111117dc0aa78b770fa6a738034120c302”,“makingAmount”:“686063020”,“takingAmount”:“1051075623166452311441”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x0000000000000000000000002deeca909787b9553dba4ade8f78f67dbe22d5b90000000000000000000000001111111254fb6c44bac0bed2854e76f90643097dffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000006367210d000000000000000000000000000000000000000000000000000000000000001bf96ba26c9fa274c0f5b1fe1bcda36a45333fe511f41d5ff297149228656ee739008c8bdc193d2aa9b2dab30780666acd4528d6a0a1440c415d7193c629d4ff0e	0x2deeca909787b9553dba4ade8f78f67dbe22d5b9	686063020	1051075623166452311441	0x4cc4a27b	0x1111111254fb6c44bac0bed2854e76f90643097d	15904377	0x2deeca909787b9553dba4ade8f78f67dbe22d5b9	0x8168bb5ca39b4eda06f6db6c9c35aa3d7cdce56916621b9470fdebfffcdf67164417aee9f6d3bf9ecc1b4b647a0dd3174137302324d58676995cea0da76c78e3	2022-11-05T14:21:11.000Z	0	1051075623166452311441	0x43c301424e14fa2378830d83095cbf4c35d380cd78e96900c8a0417838eb626b

Example Query

Query with partition filter

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

AggregationRouterV4_OrderFilledRFQ_event

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_makingAmount`	`STRING`	Amount of tokens provided by the maker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.

Sample Data

address	removed	log_index	block_number	in_orderHash	block_timestamp	in_makingAmount	transaction_hash
0x1111111254fb6c44bac0bed2854e76f90643097d	false	256	15534409	0x98f21ce8d075c8c56057b6375939ecb34febb42742bb3d8b16ec16086a93dc75	2022-09-14T18:14:35.000Z	2535927512308069300	0xefe7b7b267ec752a1597578d83dd402bdc66cc77db6509f1786aee74db111ec3
0x1111111254fb6c44bac0bed2854e76f90643097d	false	3	15533767	0x374cf518399075761c542e1dd3e49ae84ed90eb5e2b4355602f97d6937106164	2022-09-14T15:39:32.000Z	2316029579732296000	0x434f30e029939b700a610f1d8e0b1c91363397e73d5c570209217bf74058977e
0x1111111254fb6c44bac0bed2854e76f90643097d	false	4	15532768	0x0f6b4663a8dc934f078ac537e119f1beb272a9a927af12fa6dc88e3f4d9fd4bd	2022-09-14T11:45:51.000Z	4826527	0x07b6618dafee97a17a2a5afb1300d8dc3275d80b52d4b75c98cc5efa4dfdff73

Example Query

Query with partition filter

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

AggregationRouterV4_swap_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`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_caller`	`STRING`	Address that initiated or requested the contract function call. Hex-encoded, 0x-prefixed, 42-character string.
`in_desc`	`STRUCT<srcToken STRING, dstToken STRING, srcReceiver STRING, dstReceiver STRING, amount STRING, minReturnAmount STRING, flags STRING, permit STRING>`	Swap operation parameters struct containing source and destination token addresses, receiver addresses, token amounts, minimum return amount, execution flags, and permit signature data.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.
`out_spentAmount`	`STRING`	Amount of source tokens consumed by the swap operation. Numeric string representation of token quantity in smallest denomination.
`out_gasLeft`	`STRING`	Amount of gas remaining after the function execution. Numeric string representation of unspent gas units from the allocated gas limit.

Sample Data

gas	status	in_data	in_desc	gas_used	in_caller	signature	to_address	out_gasLeft	block_number	from_address	block_timestamp	out_spentAmount	out_returnAmount	transaction_hash
224480	true	0x00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a4b757fed6000000000000000000000000ab293dce330b92aa52bc2a7cd3816edaa75f890b000000000000000000000000a68dd8cb83097765263adad881af6eed479c4a33000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000002dc6c01111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	{“flags”:“4”,“amount”:“40267507646373186662066”,“permit”:“0x”,“dstToken”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“srcToken”:“0xa68dd8cb83097765263adad881af6eed479c4a33”,“dstReceiver”:“0xe9e5d197b2dd08463161de2f8848674482501e67”,“srcReceiver”:“0xab293dce330b92aa52bc2a7cd3816edaa75f890b”,“minReturnAmount”:“809235655618310285”}	167764	0x220bda5c8994804ac96ebe4df184d25e5c2196d4	0x7c025200	0x1111111254fb6c44bac0bed2854e76f90643097d	29371	14011335	0xe9e5d197b2dd08463161de2f8848674482501e67	2022-01-15T17:17:14.000Z	40267507646373186662066	872987976330031841	0x3e8ba6b7d6e63bbe32f0d691bc4e83982898b57de5dcf40009dea3ed9f361596
244090	true	0x00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a4b757fed6000000000000000000000000ab293dce330b92aa52bc2a7cd3816edaa75f890b000000000000000000000000a68dd8cb83097765263adad881af6eed479c4a33000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000002dc6c01111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	{“flags”:“4”,“amount”:“3004000000000000000000”,“permit”:“0x”,“dstToken”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“srcToken”:“0xa68dd8cb83097765263adad881af6eed479c4a33”,“dstReceiver”:“0xfda9365e2cdf21d72cb0dc4f5ff46f29e4ac59ce”,“srcReceiver”:“0xab293dce330b92aa52bc2a7cd3816edaa75f890b”,“minReturnAmount”:“81574970373007455”}	189616	0x220bda5c8994804ac96ebe4df184d25e5c2196d4	0x7c025200	0x1111111254fb6c44bac0bed2854e76f90643097d	31929	14009673	0xfda9365e2cdf21d72cb0dc4f5ff46f29e4ac59ce	2022-01-15T11:12:01.000Z	3004000000000000000000	86922307562485796	0x502c17c8ce4ba97bbc214d6a4241015e17df709d01a88c5936f3ba971c2c9f1b
224466	true	0x00000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a4b757fed6000000000000000000000000ab293dce330b92aa52bc2a7cd3816edaa75f890b000000000000000000000000a68dd8cb83097765263adad881af6eed479c4a33000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000002dc6c01111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	{“flags”:“4”,“amount”:“50374877100000000000000”,“permit”:“0x”,“dstToken”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“srcToken”:“0xa68dd8cb83097765263adad881af6eed479c4a33”,“dstReceiver”:“0xe9e5d197b2dd08463161de2f8848674482501e67”,“srcReceiver”:“0xab293dce330b92aa52bc2a7cd3816edaa75f890b”,“minReturnAmount”:“1342151996209830611”}	172552	0x220bda5c8994804ac96ebe4df184d25e5c2196d4	0x7c025200	0x1111111254fb6c44bac0bed2854e76f90643097d	29369	14008916	0xe9e5d197b2dd08463161de2f8848674482501e67	2022-01-15T08:16:23.000Z	50374877100000000000000	1461013055074161151	0xbef64318fa9386262380891d3eafb34075de587cde5083fe0eea391f4efdaf29

Example Query

Query with partition filter

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

AggregationRouterV4_uniswapV3Swap_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`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
144141	452124000000000000	true	101773	[“86844066927987146567678238757297496810455573021819158383277400169966058034752”]	452124000000000000	0xe449022e	0x1111111254fb6c44bac0bed2854e76f90643097d	15323704	0x00000000009726632680fb29d3f7a9734e3010e2	833803842	1	2022-08-11T23:53:45.000Z	850807953	0xbfe9696ff05397c2669cc68e13f6bdd049f26629e58494c3a435ff1f402b663d
144113	1487250000000000000	true	100799	[“86844066927987146567678238757297496810455573021819158383277400169966058034752”]	1487250000000000000	0xe449022e	0x1111111254fb6c44bac0bed2854e76f90643097d	15321501	0x00000000009726632680fb29d3f7a9734e3010e2	2766133544	1	2022-08-11T15:26:55.000Z	2823063267	0xe029a1957df2e792cf1233578276c521e580483e2bc292c552bfd56f03b490c4
126504	991500000000000000	true	100743	[“86844066927987146567678238757297496810455573021819158383277400169966058034752”]	991500000000000000	0xe449022e	0x1111111254fb6c44bac0bed2854e76f90643097d	15317715	0x00000000009726632680fb29d3f7a9734e3010e2	1827107168	1	2022-08-11T01:08:29.000Z	1859458692	0xcd37979ada0caa7e1cf1e9f4625ea8ed7fa77b31b04db91a950d019342898b20

Example Query

Query with partition filter

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

AggregationRouterV4_uniswapV3SwapCallback_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_amount0Delta`	`STRING`	Change in amount for the first token in a Uniswap V3 liquidity pool swap. Positive values indicate tokens owed to the pool, negative values indicate tokens owed to the recipient.
`in_amount1Delta`	`STRING`	Change in amount for the second token in a Uniswap V3 liquidity pool swap. Positive values indicate tokens owed to the pool, negative values indicate tokens owed to the recipient.
`in_anon2`	`STRING`	Third parameter passed to the Uniswap V3 swap callback function. Hex-encoded, 0x-prefixed, 66-character string representing contextual data for the swap operation.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
213884	false	6432	0xfa461e33	0x1111111254fb6c44bac0bed2854e76f90643097d	15318542	0xc60604a8e104940cf28f4fd9af8abb06dc50b812	0,2	2022-08-11T04:15:12.000Z	0x16aebee9457588bb36efa7a479ba114a7b568f7f961706100c766273847b31f0
130130	false	6883	0xfa461e33	0x1111111254fb6c44bac0bed2854e76f90643097d	15317739	0xe574ddb560d3507ba34b0db531b831b7918c62b1	0,2	2022-08-11T01:12:55.000Z	0x86dad78a1b732fd9d4f038632a0da73adb94e502d1b5d206fabd045d0d6c8a9b
186499	false	7210	0xfa461e33	0x1111111254fb6c44bac0bed2854e76f90643097d	15320039	0x14036bbda496e39dc3db6025fe858431c1ddadb1	0,2	2022-08-11T09:58:46.000Z	0xd427319d83871cc6cbcddec7d098542e214e061312e5355509efb86913f75317

Example Query

Query with partition filter

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

AggregationRouterV4_uniswapV3SwapTo_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_minReturn`	`STRING`	Minimum acceptable output amount for the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_pools`	`ARRAY<STRING>`	Array of encoded pool identifiers for routing token swaps through decentralized exchanges. Elements are numeric strings representing packed pool addresses and swap parameters.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	value	status	gas_used	in_pools	in_amount	signature	to_address	block_number	from_address	in_minReturn	in_recipient	trace_address	block_timestamp	out_returnAmount	transaction_hash
195770	4864696996722884000	true	127653	[“86844066927987146567678238757374885272631065163384959813305783582584345529728”]	4864696996722884073	0xbc80f1a8	0x1111111254fb6c44bac0bed2854e76f90643097d	14068558	0xd8401637ab562b62fa6402c2a499539c20667890	19767023100000000000000	0xd8401637ab562b62fa6402c2a499539c20667890		2022-01-24T13:21:45.000Z	19769000000000000003676	0x296502a63ec1aa9eea48f3b3e4d6771e22486bde242d83a3ba4452920cf0607a
316054	0	true	66550	[“459814688994941497959443052062941677297164997647”]	3746313745833992443063	0xbc80f1a8	0x1111111254fb6c44bac0bed2854e76f90643097d	18068436	0x9008d19f58aabd9ed0d60971565aa8510560ab41	122098176399245312	0x9008d19f58aabd9ed0d60971565aa8510560ab41	4	2023-09-05T06:17:23.000Z	123082840172214824	0x0fea864ddfe21e5a738abe453562266e7b91f82d10910785563e31422edf1732
520519	0	true	90441	[“57896044618658097711785492504861130023810985324535465758817693697233763417245”]	409634424510040965120	0xbc80f1a8	0x1111111254fb6c44bac0bed2854e76f90643097d	18071915	0x9008d19f58aabd9ed0d60971565aa8510560ab41	336470495337644032	0x9008d19f58aabd9ed0d60971565aa8510560ab41	6	2023-09-05T17:59:23.000Z	339183967926372783	0x24a0987c8f90199fce33c069c31e445dce46542cfccd02089bdb6b111cd51fee

Example Query

Query with partition filter

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

AggregationRouterV4_uniswapV3SwapToWithPermit_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_minReturn`	`STRING`	Minimum acceptable output amount for the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_pools`	`ARRAY<STRING>`	Array of encoded pool identifiers for routing token swaps through decentralized exchanges. Elements are numeric strings representing packed pool addresses and swap parameters.
`in_permit`	`STRING`	EIP-2612 permit signature data enabling gasless token approvals for the swap operation. Hex-encoded byte string containing owner address, spender address, value, deadline, and ECDSA signature components (v, r, s).
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	status	gas_used	in_pools	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
273336	false	43532	[]	0x2521b930	0x1111111254fb6c44bac0bed2854e76f90643097d	14707984	0x07a2e516993972ecd674058e173f02694617e233	2022-05-04T01:08:49.000Z	0x486417e0e0d4a44233d471c3101f4e7f3ba9d025f25b0155a16aa84aec7a8284
370447	false	243777	[]	0x2521b930	0x1111111254fb6c44bac0bed2854e76f90643097d	14712797	0x30b0f204f59a6a030cfa587d88522bd5f94a255d	2022-05-04T19:31:18.000Z	0x5a690a0b86f90ac5d1ef1d9923d48fd44895d65c43553239099b9e72b18672cb
255177	false	46314	[]	0x2521b930	0x1111111254fb6c44bac0bed2854e76f90643097d	14712908	0xc67cebf114e4421490a4b77438765a73af7d3c7b	2022-05-04T19:57:26.000Z	0x2e309269dd601f420dc7249da813baefa2836d1d72cebc14f8c2395c2ba7f425

Example Query

Query with partition filter

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

AggregationRouterV4_unoswap_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`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	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
159806	20000000000000000	false	156370	[]	0x2e95b6c8	0x1111111254fb6c44bac0bed2854e76f90643097d	18423864	0xe808c821d56d69ae0b0d5f7c2aeaf7d2b7fb780d	2023-10-25T01:03:11.000Z	0x42e3da985eb05e926e07e0aa9df12288e27a44b76dc61097d7c86612a0bd0706
600000	0	false	428683	[]	0x2e95b6c8	0x1111111254fb6c44bac0bed2854e76f90643097d	18427818	0xcbdfca586340780739a3595a2648da647f50774f	2023-10-25T14:23:11.000Z	0x89ef75386e90347d967ddfc4714ca91fa393999669354e8f9ee9ea50f15a44bd
194286	60000000000000000	false	160844	[]	0x2e95b6c8	0x1111111254fb6c44bac0bed2854e76f90643097d	18430187	0xf8abc9dd7ff57ebd7acd5c2fc8389e019dfef9f4	2023-10-25T22:20:35.000Z	0x2a92cbac9036437f81e893dd51f921d90e3032d9283e17a1e6d68e904acd39d3

Example Query

Query with partition filter

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

AggregationRouterV4_unoswapWithPermit_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`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.
`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	block_timestamp	out_returnAmount	transaction_hash
298274	true	259052	[“0x00000000000000003b6d0340b4e16d0168e52d35cacd2c6185b44281ec28c9dc”,“0x00000000000000003b6d034054bebb624ddb561b971bb07b700c9d3afd25fabc”]	1000000000	0x00000000000000000000000053a1ff1d3a863bdf7e07f20c4ad21667865a59cd0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097dffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064e88014000000000000000000000000000000000000000000000000000000000000001b1c1dcc48391a03b704201c1ac2f3652f5865120233f9ddb58ab0a9d1078ae42b78b397abf617ff881ab25b1eb6c8d89fb7b647f246808374e5bbd9dd0dc54bf5	0xa1251d75	0x1111111254fb6c44bac0bed2854e76f90643097d	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	17987342	0x53a1ff1d3a863bdf7e07f20c4ad21667865a59cd	5769078205565	2023-08-24T21:49:23.000Z	5798068548307	0x8f149cae122bfa210d8d296e3438e26928933c9ad68b3495ed24fa6ee3aabffc
241485	true	177139	[“0x40000000000000003b6d0340b4e16d0168e52d35cacd2c6185b44281ec28c9dc”]	65000000	0x00000000000000000000000085412f6cd3c3d35092a6e87e2899b3003d3ee2dc0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064a46121000000000000000000000000000000000000000000000000000000000000001b1c81e10017c2faa510324a97c73a0985b8710e0ed5d640c7447aef66c6b30ec45e40f0ac5b38e6fb3750fa7294be0d7f76cd24a57b4809e9386d69f9daf97963	0xa1251d75	0x1111111254fb6c44bac0bed2854e76f90643097d	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	17615327	0x85412f6cd3c3d35092a6e87e2899b3003d3ee2dc	32874685955761481	2023-07-03T18:50:59.000Z	32969770444792146	0x26bd1a90d39164c485dd78fd89408216e7aff4a048dcad3a74e98d861780843a
219899	false	187778	[]			0xa1251d75	0x1111111254fb6c44bac0bed2854e76f90643097d		15314959	0xc5ea2f344d5648d95e96e2b8c9e955e77e74099c		2022-08-10T14:53:21.000Z		0x148bab18df276021b4c27ec72445687a80b7c102bae8234524d80cd9bb122d85

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AggregationRouterV4_clipperSwap_function

AggregationRouterV4_clipperSwapTo_function

AggregationRouterV4_clipperSwapToWithPermit_function

AggregationRouterV4_fillOrderRFQ_function

AggregationRouterV4_fillOrderRFQTo_function

AggregationRouterV4_fillOrderRFQToWithPermit_function

AggregationRouterV4_OrderFilledRFQ_event

AggregationRouterV4_swap_function

AggregationRouterV4_uniswapV3Swap_function

AggregationRouterV4_uniswapV3SwapCallback_function

AggregationRouterV4_uniswapV3SwapTo_function

AggregationRouterV4_uniswapV3SwapToWithPermit_function

AggregationRouterV4_unoswap_function

AggregationRouterV4_unoswapWithPermit_function

Metrics

Primitives

Contracts

Blockchain

​Tables

​AggregationRouterV4_clipperSwap_function

​AggregationRouterV4_clipperSwapTo_function

​AggregationRouterV4_clipperSwapToWithPermit_function

​AggregationRouterV4_fillOrderRFQ_function

​AggregationRouterV4_fillOrderRFQTo_function

​AggregationRouterV4_fillOrderRFQToWithPermit_function

​AggregationRouterV4_OrderFilledRFQ_event

​AggregationRouterV4_swap_function

​AggregationRouterV4_uniswapV3Swap_function

​AggregationRouterV4_uniswapV3SwapCallback_function

​AggregationRouterV4_uniswapV3SwapTo_function

​AggregationRouterV4_uniswapV3SwapToWithPermit_function

​AggregationRouterV4_unoswap_function

​AggregationRouterV4_unoswapWithPermit_function

Tables

AggregationRouterV4_clipperSwap_function

AggregationRouterV4_clipperSwapTo_function

AggregationRouterV4_clipperSwapToWithPermit_function

AggregationRouterV4_fillOrderRFQ_function

AggregationRouterV4_fillOrderRFQTo_function

AggregationRouterV4_fillOrderRFQToWithPermit_function

AggregationRouterV4_OrderFilledRFQ_event

AggregationRouterV4_swap_function

AggregationRouterV4_uniswapV3Swap_function

AggregationRouterV4_uniswapV3SwapCallback_function

AggregationRouterV4_uniswapV3SwapTo_function

AggregationRouterV4_uniswapV3SwapToWithPermit_function

AggregationRouterV4_unoswap_function

AggregationRouterV4_unoswapWithPermit_function