1inch_v5_bsc

Tables

AggregationRouterV5_clipperSwap_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_clipperExchange`	`STRING`	Contract address of the Clipper decentralized exchange router handling the swap execution. Hex-encoded, 0x-prefixed, 42-character string.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_dstToken`	`STRING`	Contract address of the destination token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_inputAmount`	`STRING`	Amount of source tokens being swapped or deposited. Numeric string representation of token quantity in smallest denomination.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_goodUntil`	`STRING`	Expiration timestamp for the Clipper swap signature validity. Numeric string representing the deadline after which the signed swap parameters become invalid.
`in_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_vs`	`STRING`	ECDSA signature component vs, which combines the recovery identifier v with the signature component s for compact signature representation. 66-character hex string including 0x prefix.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

AggregationRouterV5_clipperSwapTo_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_clipperExchange`	`STRING`	Contract address of the Clipper decentralized exchange router handling the swap execution. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_dstToken`	`STRING`	Contract address of the destination token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_inputAmount`	`STRING`	Amount of source tokens being swapped or deposited. Numeric string representation of token quantity in smallest denomination.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_goodUntil`	`STRING`	Expiration timestamp for the Clipper swap signature validity. Numeric string representing the deadline after which the signed swap parameters become invalid.
`in_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_vs`	`STRING`	ECDSA signature component vs, which combines the recovery identifier v with the signature component s for compact signature representation. 66-character hex string including 0x prefix.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	in_r	in_vs	value	status	gas_used	signature	to_address	in_dstToken	in_srcToken	block_number	from_address	in_goodUntil	in_recipient	trace_address	in_inputAmount	block_timestamp	in_outputAmount	out_returnAmount	transaction_hash	in_clipperExchange
180210	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0	false	9347	0x093d4fa5	0x1111111254eeb25477b68fb85ed929f73a960582	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0x006a9300277233910900000000e24b9c5b8fc8c0	46657936	0x006a9300277233910900000000e24b9c5b8fc8c0	0	0x006a9300277233910900000000e24b9c5b8fc8c0	7	0	2025-02-14T17:47:23.000Z	3575423017129353		0x621c471f5be53cee9271d2cbabcd19ac267f74ce053c32780e2254c0e2bfa697	0x006a9300277233910900000000e24b9c5b8fc8c0

Example Query

Query with partition filter

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

AggregationRouterV5_clipperSwapToWithPermit_function

Token swap function calls executed through 1inch AggregationRouterV5 using Clipper DEX (Decentralized Exchange) with EIP-2612 permit signatures for gasless approvals. Contains swap parameters including source/destination tokens, amounts, recipient addresses, ECDSA signature components, and execution outcomes for tracking permit-based swap transactions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_clipperExchange`	`STRING`	Contract address of the Clipper decentralized exchange router handling the swap execution. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_dstToken`	`STRING`	Contract address of the destination token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_inputAmount`	`STRING`	Amount of source tokens being swapped or deposited. Numeric string representation of token quantity in smallest denomination.
`in_outputAmount`	`STRING`	Expected amount of destination tokens to be received from the swap operation. Numeric string representation of token quantity in smallest denomination.
`in_goodUntil`	`STRING`	Expiration timestamp for the Clipper swap signature validity. Numeric string representing the deadline after which the signed swap parameters become invalid.
`in_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_vs`	`STRING`	ECDSA signature component vs, which combines the recovery identifier v with the signature component s for compact signature representation. 66-character hex string including 0x prefix.
`in_permit`	`STRING`	EIP-2612 permit signature data enabling gasless token approvals for the swap operation. Hex-encoded byte string containing owner address, spender address, value, deadline, and ECDSA signature components (v, r, s).
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrder_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_order`	`STRUCT<salt STRING, makerAsset STRING, takerAsset STRING, maker STRING, receiver STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING, offsets STRING, interactions STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_interaction`	`STRING`	Encoded data for custom interactions executed during order fulfillment. Hex-encoded byte string, typically 0x-prefixed.
`in_makingAmount`	`STRING`	Amount of tokens provided by the maker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_takingAmount`	`STRING`	Amount of tokens requested from the taker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_skipPermitAndThresholdAmount`	`STRING`	Bitfield parameter combining permit-skipping flag and minimum threshold amount for order execution. Numeric string encoding both a boolean flag (in the highest bit) to skip EIP-2612 permit processing and a threshold amount (in remaining bits) specifying the minimum acceptable taking amount.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon1`	`STRING`	Actual amount of tokens received by the taker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon2`	`STRING`	Unique identifier hash for the executed order. 66-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	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
281901	true	149236	{“salt”:“871751761197”,“maker”:“0x937c4bfb346537aa0b79b5e9aa67f4b0fcf05c8f”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x55d398326f99059ff775485246999027b3197955”,“takerAsset”:“0x7bc75e291e656e8658d66be1cc8154a3769a35dd”,“interactions”:“0xbf15fcd800000000000000000000000058ce0e6ef670c9a05622f4188faa03a9e12ee2e4000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d006b55576f00000000010000937c4bfb346537aa0b79b5e9aa67f4b0fcf05c8f00000000000000000000000000000000000000000000000000000000”,“makingAmount”:“11000000000000000000”,“takingAmount”:“75119648238700000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	146433060562882	1000000000000000000	0xeec62c17a454f6e70f1203dbc0937ef9ad76bed14583514a9e14a48e0c4095c8	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	42735076	0x5ea07cf2ddf252d279361eaad5c595ca6e4dd679	0xd129ccbe830d68fd6d8ab6c9fb8d89750806e5cb346e2ef5acf32f65c554cab17eb02761cb65cfa5c44bda4575ef457dd4bfa5c08c9f6867785527f56db953e21c		0x	2024-10-01T12:17:16.000Z	1000000000000000000	0x14823a4b20f97b4606c1a1d2d7169bbf433878e3d8fabae729f3d6580862cebd	57896044618658097711785492504343953926634992332820282019728792143067972354705
358423	true	85136	{“salt”:“651741655773”,“maker”:“0xde6c0c3dbe6bdd8fc8eacd0e6fe8548c5dc34d02”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x55d398326f99059ff775485246999027b3197955”,“takerAsset”:“0x6ad9e9c098a45b2b41b519119c31c3dcb02accb2”,“interactions”:“0xbf15fcd800000000000000000000000058ce0e6ef670c9a05622f4188faa03a9e12ee2e4000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d006ae71ed500000000000000de6c0c3dbe6bdd8fc8eacd0e6fe8548c5dc34d0200000000000000000000000000000000000000000000000000000000”,“makingAmount”:“15000000000000000000”,“takingAmount”:“300000000000000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	15000000000000000000	300000000000000000000	0xf92b4c40921e83fb740b549f9619d4f684956871c3cf4488e991200e1ab57fd9	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	42738693	0xe37e799d5077682fa0a244d46e5649f71457bd09	0x4e3f00c077671d9158d3712accc4473bfbf59385911e2535b4ee66ab3829ebea0beee9f915859f06be673f4630c1010ee5d89d8d70147c8b5c7e761641764703	1,0,1,1,0,0,3	0x	2024-10-01T15:18:13.000Z	300000000000000000000	0x85bb37447c7c18dc82c084f22148ef92416f21413852e939ec4f1e3682f34bbc	57896044618658097711785492504343953926634992332820282019743492003956564819968
476428	true	94936	{“salt”:“139219070724”,“maker”:“0x819dd678eab36598cc2e6f9fa6be5882013365e0”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x55d398326f99059ff775485246999027b3197955”,“takerAsset”:“0x6ad9e9c098a45b2b41b519119c31c3dcb02accb2”,“interactions”:“0xbf15fcd800000000000000000000000058ce0e6ef670c9a05622f4188faa03a9e12ee2e4000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d006b39a0c900000000010000819dd678eab36598cc2e6f9fa6be5882013365e000000000000000000000000000000000000000000000000000000000”,“makingAmount”:“15000000000000000000”,“takingAmount”:“1558536656717000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	1924882540985201709	200000000000000000000	0x3021867db9ff1fe654c37226d67df539fbe05542c4fc300270ab11233ea2f702	0x62e238bb	0x1111111254eeb25477b68fb85ed929f73a960582	42738693	0xe37e799d5077682fa0a244d46e5649f71457bd09	0x36d1a24183a1da76f2bcea7e9a5ab224262c2ee406c98ca416ae587ac10e973b6c844d4dec25c756cfc0f6fb016bcc1b73487b500612cff57c8340938ebbe2d9	1,0,1,1,0,0,1	0x	2024-10-01T15:18:13.000Z	200000000000000000000	0x85bb37447c7c18dc82c084f22148ef92416f21413852e939ec4f1e3682f34bbc	57896044618658097711785492504343953926634992332820282019730678388846730317642

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrderRFQ_function

Decoded function calls to the 1inch AggregationRouterV5 fillOrderRFQ method, which executes Request-for-Quote (RFQ) orders between maker and taker. Contains order details including asset addresses, amounts, maker signature, execution flags, and returned fill amounts for peer-to-peer token swaps.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_order`	`STRUCT<info STRING, makerAsset STRING, takerAsset STRING, maker STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_flagsAndAmount`	`STRING`	Encoded integer combining order execution flags and token amount for RFQ (Request-for-Quote) orders. Numeric string representing a packed value where higher-order bits contain execution flags and lower-order bits contain the taking amount in the token’s smallest denomination.
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon1`	`STRING`	Actual amount of tokens received by the taker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon2`	`STRING`	Unique identifier hash for the executed order. 66-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	in_order	out_anon0	out_anon1	out_anon2	signature	to_address	block_number	from_address	in_signature	trace_address	block_timestamp	transaction_hash	in_flagsAndAmount
502069	true	35361	{“info”:“31869642799910519926914428738”,“maker”:“0xfbcbc817ee4fa411aa7492b576abd7669927509d”,“makerAsset”:“0x55d398326f99059ff775485246999027b3197955”,“takerAsset”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“makingAmount”:“6860759240117644689408”,“takingAmount”:“2608974533512907238”,“allowedSender”:“0xe37e799d5077682fa0a244d46e5649f71457bd09”}	6860759240117644689408	2608974533512907238	0x94863eac3d3b98b0975376720296a4703969ee51f7f2b737661442420421d924	0x3eca9c0a	0x1111111254eeb25477b68fb85ed929f73a960582	42692318	0xe37e799d5077682fa0a244d46e5649f71457bd09	0x3a92cf39f4dc56cf52f34de4a7907d67e00e8eeb24776404ca5ef20cd7d1252f4140231a2ec2b346b29e755e198446982e8e28dca82dfaea8702b528d7dcae481b	0,1,3,0,0,1,2,2,1	2024-09-30T00:39:16.000Z	0x718c8adea61e1a9db5b0293ecf0dd856c8d6a161c187da9f9c07d845760a1320	2608974533512907238
2706963	false	47740					0x3eca9c0a	0x1111111254eeb25477b68fb85ed929f73a960582	32921737	0x4fa8ed9b7bf41978a481a0bb4520e69fade4d262		1,1,0,1	2023-10-25T20:45:33.000Z	0xb0d179a5292b435b9322f008c190a1a80461bc63060308664a05ac81322d6b09
301912	true	47461	{“info”:“31327217839949592753248229459”,“maker”:“0xfbcbc817ee4fa411aa7492b576abd7669927509d”,“makerAsset”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“takerAsset”:“0x55d398326f99059ff775485246999027b3197955”,“makingAmount”:“444819703301481216”,“takingAmount”:“799200000000000000000”,“allowedSender”:“0xf8a1527325bb62d6d0320eb2312748d590f1ce27”}	444819703301481216	799200000000000000000	0xba3807d021b5da1f4b9980d84f4ad3ddf2329f4d08c9466f76ef0989dced2eec	0x3eca9c0a	0x1111111254eeb25477b68fb85ed929f73a960582	32916775	0xf8a1527325bb62d6d0320eb2312748d590f1ce27	0x16b07a2203a6dc74438a516fd033d406e4e2841d52bdbddaa921f9f17abc89682284b476d1becca09eb45f34fe2d4bcbf008a8acf67fca9d574616056dd228f01b	1,1,2,0,0,0,1,0,1	2023-10-25T16:37:20.000Z	0x0302424f3bc46bff2714f415540b28682c69d8f443d0357e533f1d63a9dd6948	799200000000000000000

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrderRFQCompact_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_order`	`STRUCT<info STRING, makerAsset STRING, takerAsset STRING, maker STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_r`	`STRING`	ECDSA signature component r used for cryptographic verification of signed messages or permits. 66-character hex string including 0x prefix.
`in_vs`	`STRING`	ECDSA signature component vs, which combines the recovery identifier v with the signature component s for compact signature representation. 66-character hex string including 0x prefix.
`in_flagsAndAmount`	`STRING`	Encoded integer combining order execution flags and token amount for RFQ (Request-for-Quote) orders. Numeric string representing a packed value where higher-order bits contain execution flags and lower-order bits contain the taking amount in the token’s smallest denomination.
`out_filledMakingAmount`	`STRING`	Amount of maker tokens actually filled in the RFQ (Request-for-Quote) order execution. Numeric string representing the quantity in the token’s smallest denomination.
`out_filledTakingAmount`	`STRING`	Amount of taker tokens actually filled in the RFQ (Request-for-Quote) order execution. Numeric string representing the quantity in the token’s smallest denomination.
`out_orderHash`	`STRING`	Unique identifier hash for the order being filled. 66-character hex string including 0x prefix.

Sample Data

gas	in_r	in_vs	status	gas_used	in_order	signature	to_address	block_number	from_address	out_orderHash	trace_address	block_timestamp	transaction_hash	in_flagsAndAmount	out_filledMakingAmount	out_filledTakingAmount
363406			false	5742		0x9570eeee	0x1111111254eeb25477b68fb85ed929f73a960582	27950710	0xdd1305150d27aecc60c066630105db419977e367		0,0,1,0,1,3,3,8	2023-05-05T17:49:02.000Z	0xdf464773c8f5c40e52c5ccd0559cfaebd5dabd09775f158f3c74a0ca52a770bf
330000	0x76ce59f6858b1e2f052e7520495765cdd1febfc193e2b86ddca7fda4b6c41e0d	0x8a2f24c53b60a18876c870bbb7cbf1b9d0718df473041f5ea038e57e2f124a4d	true	101124	{“info”:“31051452629744763037540633842”,“maker”:“0x2008b6c3d07b061a84f790c035c2f6dc11a0be70”,“makerAsset”:“0x55d398326f99059ff775485246999027b3197955”,“takerAsset”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“makingAmount”:“332434456752291971072”,“takingAmount”:“167543425114915392”,“allowedSender”:“0x763b06a7d3ef483dec87b9b004f879bc1d1713df”}	0x9570eeee	0x1111111254eeb25477b68fb85ed929f73a960582	27948600	0x763b06a7d3ef483dec87b9b004f879bc1d1713df	0xc19766883fcfcdd9826d869c23d01479233720d26deb40f19b241df8925a87f0		2023-05-05T16:03:22.000Z	0x6651fc51ad531d7e4de221421ae8d761c1533330bf15e93cb2ddb50c895fa18a	167543425114915392	332434456752291971072	167543425114915392
131024	0xa31ac89f201565324cf30f595c36ac1656c61980d0ed32ac55f0f0190569f773	0x0cd510827ca2652bd3d8493e39e1bea3ecc221a04f230637bde036d8a74ca396	true	86088	{“info”:“31051899280759019766938124811”,“maker”:“0x2008b6c3d07b061a84f790c035c2f6dc11a0be70”,“makerAsset”:“0xe9e7cea3dedca5984780bafc599bd69add087d56”,“takerAsset”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“makingAmount”:“92974644322306998272”,“takingAmount”:“46806250000000000”,“allowedSender”:“0x37bb91cafb9c1274b0ab9eb0fd7d09f8ae56918a”}	0x9570eeee	0x1111111254eeb25477b68fb85ed929f73a960582	27956661	0x37bb91cafb9c1274b0ab9eb0fd7d09f8ae56918a	0x219ea68bb3648a9818c09dbe941d56ad312b65bec3780c7cb6a45ac121890422		2023-05-05T22:46:59.000Z	0x0f03f721cf91464af03e3435dfbdbcbb2dd4c2ab0c24f4053b0a749e1ca32a28	46806250000000000	92974644322306998272	46806250000000000

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrderRFQTo_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_order`	`STRUCT<info STRING, makerAsset STRING, takerAsset STRING, maker STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_flagsAndAmount`	`STRING`	Encoded integer combining order execution flags and token amount for RFQ (Request-for-Quote) orders. Numeric string representing a packed value where higher-order bits contain execution flags and lower-order bits contain the taking amount in the token’s smallest denomination.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`out_filledMakingAmount`	`STRING`	Amount of maker tokens actually filled in the RFQ (Request-for-Quote) order execution. Numeric string representing the quantity in the token’s smallest denomination.
`out_filledTakingAmount`	`STRING`	Amount of taker tokens actually filled in the RFQ (Request-for-Quote) order execution. Numeric string representing the quantity in the token’s smallest denomination.
`out_orderHash`	`STRING`	Unique identifier hash for the order being filled. 66-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	in_order	in_target	signature	to_address	block_number	from_address	in_signature	out_orderHash	trace_address	block_timestamp	transaction_hash	in_flagsAndAmount	out_filledMakingAmount	out_filledTakingAmount
282281	true	64586	{“info”:“31457650801244818850493886546”,“maker”:“0xff8ba4d1fc3762f6154cc942ccf30049a2a0cec6”,“makerAsset”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“takerAsset”:“0x55d398326f99059ff775485246999027b3197955”,“makingAmount”:“74813251007092000”,“takingAmount”:“190000000000000000000”,“allowedSender”:“0xe37e799d5077682fa0a244d46e5649f71457bd09”}	0x0392957571f28037607c14832d16f8b653edd472	0x5a099843	0x1111111254eeb25477b68fb85ed929f73a960582	35266371	0xe37e799d5077682fa0a244d46e5649f71457bd09	0x5b20e2fdc99ac73834fe0bb232e23f342886022419efd0b208da580e1f7ada6808088a24a1b9a45d802b6b0cd9df1e708099e3926c08e94296280e00df9eb5a61c	0xeddf2da08f4cd5c11340b50ccd0e47d2edae3020de381c0c82b0fcb11e198f14	1,1,2,0,0,0,0,1	2024-01-15T12:43:29.000Z	0xc94a3111ea0060b052d441d6ad5f96df308ef21d94a83af79d728c77cb1b07ae	190000000000000000000	74813251007092000	190000000000000000000
247837	true	59194	{“info”:“31457952737551817328451105864”,“maker”:“0xff8ba4d1fc3762f6154cc942ccf30049a2a0cec6”,“makerAsset”:“0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c”,“takerAsset”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“makingAmount”:“150674143162497800”,“takingAmount”:“18895680000000000”,“allowedSender”:“0xe37e799d5077682fa0a244d46e5649f71457bd09”}	0x731b8244f818fd488d9dc516edd976a96459ae59	0x5a099843	0x1111111254eeb25477b68fb85ed929f73a960582	35271814	0xe37e799d5077682fa0a244d46e5649f71457bd09	0xf96d964deb773375a69e67417feaa44ee630e8e1b94139fade0b7724cffeb82660402fc4c247671313ae3be4a3d6d44710fa5b4846720cf094eabd51335a7b871c	0xb33081d65781185edfd3cdb78076d700917ee0927fe0a01065ec05ba7d0bd0b5	1,1,1,0,0,0,0,1	2024-01-15T17:16:19.000Z	0xb6af25542f28c456d1787643f7923f02ff52f855a42b2ae6903c317221f1c04c	18895680000000000	150674143162497800	18895680000000000
413580	true	62710	{“info”:“31458334751174839779576230258”,“maker”:“0xff8ba4d1fc3762f6154cc942ccf30049a2a0cec6”,“makerAsset”:“0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c”,“takerAsset”:“0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c”,“makingAmount”:“4455764185638886”,“takingAmount”:“600000000000000000”,“allowedSender”:“0xe37e799d5077682fa0a244d46e5649f71457bd09”}	0x768bc9e41a4d1fd679b8aa05ffe86b1e042c68e5	0x5a099843	0x1111111254eeb25477b68fb85ed929f73a960582	35278704	0xe37e799d5077682fa0a244d46e5649f71457bd09	0xd8586afc6c5bf9172929297c0167b8762f992fadc4393e6864ecb4a088e480e82260b9cd9587b83cfc3caa9be63803518619e8ba77fcd34d321052b5a90bf2941b	0x5c6b2d782cfc58843d6f86066e1a5682e533bb0ecc4197af08e5665d5d511a10	1,1,2,0,0,0,2,0,1	2024-01-15T23:01:26.000Z	0x8ec90d9a1228bacc04f97c46e8f3ccf598da9e21f63358b7cc865b4b2eba2d18	600000000000000000	4455764185638886	600000000000000000

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrderRFQToWithPermit_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_order`	`STRUCT<info STRING, makerAsset STRING, takerAsset STRING, maker STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_flagsAndAmount`	`STRING`	Encoded integer combining order execution flags and token amount for RFQ (Request-for-Quote) orders. Numeric string representing a packed value where higher-order bits contain execution flags and lower-order bits contain the taking amount in the token’s smallest denomination.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_permit`	`STRING`	EIP-2612 permit signature data enabling gasless token approvals for the swap operation. Hex-encoded byte string containing owner address, spender address, value, deadline, and ECDSA signature components (v, r, s).
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon1`	`STRING`	Actual amount of tokens received by the taker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon2`	`STRING`	Unique identifier hash for the executed order. 66-character hex string including 0x prefix.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrderTo_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_order_`	`STRUCT<salt STRING, makerAsset STRING, takerAsset STRING, maker STRING, receiver STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING, offsets STRING, interactions STRING>`	Structured order parameters defining the maker-taker exchange agreement in 1inch RFQ orders. Contains salt for uniqueness, maker and taker asset addresses, participant addresses (maker, receiver, allowedSender), token amounts (makingAmount, takingAmount), offsets for bitfield encoding, and interactions for custom execution logic.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_interaction`	`STRING`	Encoded data for custom interactions executed during order fulfillment. Hex-encoded byte string, typically 0x-prefixed.
`in_makingAmount`	`STRING`	Amount of tokens provided by the maker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_takingAmount`	`STRING`	Amount of tokens requested from the taker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_skipPermitAndThresholdAmount`	`STRING`	Bitfield parameter combining permit-skipping flag and minimum threshold amount for order execution. Numeric string encoding both a boolean flag (in the highest bit) to skip EIP-2612 permit processing and a threshold amount (in remaining bits) specifying the minimum acceptable taking amount.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`out_actualMakingAmount`	`STRING`	Actual amount of maker tokens transferred in the order execution. Numeric string representing the token quantity in its smallest denomination.
`out_actualTakingAmount`	`STRING`	Actual amount of taker tokens transferred in the order execution. Numeric string representing the token quantity in its smallest denomination.
`out_orderHash`	`STRING`	Unique identifier hash for the order being filled. 66-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	in_order_	in_target	signature	to_address	block_number	from_address	in_signature	out_orderHash	trace_address	in_interaction	block_timestamp	in_makingAmount	in_takingAmount	transaction_hash	out_actualMakingAmount	out_actualTakingAmount	in_skipPermitAndThresholdAmount
585845	false	390313			0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	39571487	0x1d0ae300eec4093cee4367c00b228d10a5c7ac63			0,0,1		2024-06-13T08:16:57.000Z			0xec74e2206f7af1e2cf7d09a505a5878abcf8dc730496ebb3f69ce427c2d9857a
299101	false	4237			0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	39564858	0x1d0ae300eec4093cee4367c00b228d10a5c7ac63			0,1,1		2024-06-13T02:44:03.000Z			0xc3db6def2c9564bfb79f62e4cd98fdee62353d5d295baf2e95742fb271f40bd9
503716	true	455222	{“salt”:“144923739803”,“maker”:“0x1d0b5f79c7781f80a7570864b6d67a86bc0d3ff7”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0xe045fc25581cfdc3cfb5c282501f3cd1a133a7ec”,“takerAsset”:“0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c”,“interactions”:“0xbf15fcd800000000000000000000000058ce0e6ef670c9a05622f4188faa03a9e12ee2e4000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d006992e977000000000000001d0b5f79c7781f80a7570864b6d67a86bc0d3ff700000000000000000000000000000000000000000000000000000000”,“makingAmount”:“931985501891588896410”,“takingAmount”:“745588401513271200”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x111111125421ca6dc452d289314280a0f8842a65	0xe5d7bde6	0x1111111254eeb25477b68fb85ed929f73a960582	39583403	0xe37e799d5077682fa0a244d46e5649f71457bd09	0xa1a5b7adb5c9f8b674d5ff2b679dacc71f023066a131cadd27780970b2f0b07b065f413b652ecdfaf7952f1b0562c6530259ef30df3726ba7fe5b4b38632e1b7	0x8fed8c0240b8d7f9a272a121a0469c78bf40335e9890ab933fad3eea05654871	0,3	0x	2024-06-13T18:16:30.000Z	0	9000000000000000	0x492cdfb56b184a263d8a8b4b81013ec9c0ac017775cd5d6937d52988954c5470	11249999999999998749	9000000000000000	57896044618658097711785492504343953926634992332820282019728792003956564819969

Example Query

Query with partition filter

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

AggregationRouterV5_fillOrderToWithPermit_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_order`	`STRUCT<salt STRING, makerAsset STRING, takerAsset STRING, maker STRING, receiver STRING, allowedSender STRING, makingAmount STRING, takingAmount STRING, offsets STRING, interactions STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_signature`	`STRING`	Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
`in_interaction`	`STRING`	Encoded data for custom interactions executed during order fulfillment. Hex-encoded byte string, typically 0x-prefixed.
`in_makingAmount`	`STRING`	Amount of tokens provided by the maker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_takingAmount`	`STRING`	Amount of tokens requested from the taker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
`in_skipPermitAndThresholdAmount`	`STRING`	Bitfield parameter combining permit-skipping flag and minimum threshold amount for order execution. Numeric string encoding both a boolean flag (in the highest bit) to skip EIP-2612 permit processing and a threshold amount (in remaining bits) specifying the minimum acceptable taking amount.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_permit`	`STRING`	EIP-2612 permit signature data enabling gasless token approvals for the swap operation. Hex-encoded byte string containing owner address, spender address, value, deadline, and ECDSA signature components (v, r, s).
`out_anon0`	`STRING`	Actual amount of tokens provided by the maker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon1`	`STRING`	Actual amount of tokens received by the taker in the order or swap execution. Numeric string representing the token quantity in its smallest denomination.
`out_anon2`	`STRING`	Unique identifier hash for the executed order. 66-character hex string including 0x prefix.

Sample Data

gas	status	gas_used	in_order	in_permit	in_target	out_anon0	out_anon1	out_anon2	signature	to_address	block_number	from_address	in_signature	in_interaction	block_timestamp	in_takingAmount	transaction_hash	in_skipPermitAndThresholdAmount
196928	true	151751	{“salt”:“1607331397444”,“maker”:“0x6827c36ff9e2207124d8264966d914df7f48d8aa”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x55d398326f99059ff775485246999027b3197955”,“takerAsset”:“0x12f31b73d812c6bb0d735a218c086d44d5fe5f89”,“interactions”:“0xbf15fcd800000000000000000000000058ce0e6ef670c9a05622f4188faa03a9e12ee2e4000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d0064cbae3c000000000000006827c36ff9e2207124d8264966d914df7f48d8aa00000000000000000000000000000000000000000000000000000000”,“makingAmount”:“300000000000000000000”,“takingAmount”:“315789473684210500000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x12f31b73d812c6bb0d735a218c086d44d5fe5f8900000000000000000000000082be81938d4f486dfa761acd0eb996316ff606310000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064c951ee000000000000000000000000000000000000000000000000000000000000001cbfd4817a5f4042e0cfbf7466bb3b3f90b5a7313e4a834351c07a82e96ba220cd1083df3944e74a3feb7cc3a1a21844af8a67b8b423c78535ab7acd897c1abeeb	0x82be81938d4f486dfa761acd0eb996316ff60631	439541527930162478	462675292558065728	0x49f820fc32a92a2083eddce6b406dde4d569895a8adaec3671760b5449e26d21	0xd365c695	0x1111111254eeb25477b68fb85ed929f73a960582	30451205	0x82be81938d4f486dfa761acd0eb996316ff60631	0x8b369baf5dc2ea5a94f8d3b69fe2d79eb10e1c0f1c432345944839c607743b872db71140c4de6636a6d461522f579c3d1a984b76c5ec4e3beecc93f4b33dfb4b00	0x	2023-07-31T18:42:28.000Z	462675292558065728	0x9e65fea83964e7dd5f6bb83b5d7358cb21b0609fd7dd57096a42e02875b1a913	57896044618658097711785492504343953926634992332820282019729227150069215680821
239948	true	142284	{“salt”:“1234218666277”,“maker”:“0xdf2c20264358fb4cec88f81c33fc05b6225a6eec”,“offsets”:“4421431254442149611168492388118363282642987198110904030635476664713216”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c”,“takerAsset”:“0x111111111117dc0aa78b770fa6a738034120c302”,“interactions”:“0xbf15fcd800000000000000000000000058ce0e6ef670c9a05622f4188faa03a9e12ee2e4000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d006fead17b00000000000000df2c20264358fb4cec88f81c33fc05b6225a6eec00000000000000000000000000000000000000000000000000000000”,“makingAmount”:“20000000000000000”,“takingAmount”:“8406054998900000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x111111111117dc0aa78b770fa6a738034120c302000000000000000000000000ca6837467c64e97ee5466693500dad0722afa32b0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582000000000000000000000000000000000000000000000000000000018ed332c70000000000000000000000000000000000000000000000000000000065183ee8000000000000000000000000000000000000000000000000000000000000001c675d35c1a9e2a4fe83339ab4208edd9f2e1d768d0a10451770e0a6ddc07b89e106e4665f5645b7d980a38bd42f36a77b391656522d93776d555d9573255a7ec9	0xca6837467c64e97ee5466693500dad0722afa32b	15919	6691173063	0x5eb264982062e5364a9c383f84b14764a223b5304d72a1132807a5ba06091a0f	0xd365c695	0x1111111254eeb25477b68fb85ed929f73a960582	32183062	0xca6837467c64e97ee5466693500dad0722afa32b	0x1ed569923f9fffb22cc566d38d2c8b779ff3a72a5001e3d838dbfed3f59cf1614eb628cf42097a4b41f3e3d31a9f6eedf4de01eb58114799bbe26a23d7e97a951b	0x	2023-09-30T02:59:55.000Z	6691173063	0x6744a1c3b95a20f6e4e1b31307279aca8724d309102aad6cda2bc8aa086878b0	57896044618658097711785492504343953926634992332820282019728792003956564835727
223768	true	194581	{“salt”:“372196456222”,“maker”:“0x7ae8262cfa3f0475fc1c0215e523f29d86699dc1”,“offsets”:“4475351147789005094231522783095416493407084522705596177160048153198592”,“receiver”:“0x0000000000000000000000000000000000000000”,“makerAsset”:“0x55d398326f99059ff775485246999027b3197955”,“takerAsset”:“0x111111111117dc0aa78b770fa6a738034120c302”,“interactions”:“0x7878bf15fcd800000000000000000000000058ce0e6ef670c9a05622f4188faa03a9e12ee2e4000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000242cc2878d00641a20d0000000000100017ae8262cfa3f0475fc1c0215e523f29d86699dc100000000000000000000000000000000000000000000000000000000”,“makingAmount”:“490000000000000000”,“takingAmount”:“930698269045796441”,“allowedSender”:“0xdf3501f6e9fd0dcd307e4d5e63b79a4d08ac5c6f”}	0x111111111117dc0aa78b770fa6a738034120c302000000000000000000000000df3501f6e9fd0dcd307e4d5e63b79a4d08ac5c6f0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000641a2e3f000000000000000000000000000000000000000000000000000000000000001c89f626fecdcccdfa33a01da71c06cc7a4787448eb141b2a8b231d897dda120d23252438324376758c2062c85b59277a5bf82f83300967c1db34609f0107019b4	0xdf3501f6e9fd0dcd307e4d5e63b79a4d08ac5c6f	490000000000000000	930698269045796441	0x2523fde08d6b7f1fef84ec2310786b91b92c917cb004af25363714b3642606dd	0xd365c695	0x1111111254eeb25477b68fb85ed929f73a960582	26667337	0xdf3501f6e9fd0dcd307e4d5e63b79a4d08ac5c6f	0xb75f185b974614eecb1a905026d0f98eb323aeae1ab5bd55c8b3b1d6c3d60c3fe7ab9dd44d6028c9472f845c44bbe17a70a3162b762f4f09940193f22ea56de2	0x	2023-03-21T21:23:14.000Z	930698269045796441	0x6f74ad4436642f10b4dd8e6fe43c693beb319862a0eb1e2acecc984cc3ee584d	57896044618658097711785492504343953926634992332820282019729282003956564819968

Example Query

Query with partition filter

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

AggregationRouterV5_OrderFilled_event

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

Columns

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

Sample Data

address	removed	in_maker	log_index	block_number	in_orderHash	in_remaining	block_timestamp	transaction_hash
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x012910e424b2af7bc244973debe986d1d601c351	99	28239423	0xef0f762d7f479eab72dd6700a1a692e224128845d68fe43b0c0c93bf18b3e6a4	0	2023-05-15T18:48:31.000Z	0x7843175252b22b645491d2135b3d23397e16c4e5ccfa24dd445bb6b1e065415a
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x021c127841a49af410672e5074b64c2f2e5010db	362	28234218	0x5681a101d4d2f27931a756ec6faf6e4d7440645acbd36ca04e5fe9bdf0d03cb0	0	2023-05-15T14:26:57.000Z	0x00f9abd948e0f3c149df21e896f12c2f0b78b97eece8ff2794cee7e8bdfbb8cd
0x1111111254eeb25477b68fb85ed929f73a960582	false	0x02692354a80411f2129b57be282bf76b7056b322	86	28223379	0x411602194910d653c70527dd2b82ccacf5c3847e9402c88c8f1f494290b1147b	67156234522447637	2023-05-15T05:23:24.000Z	0x4f51f774c9dc4365496841596a56033368305cdc4be5f1e351b6cc497a4ec733

Example Query

Query with partition filter

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

AggregationRouterV5_OrderFilledRFQ_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	in_orderHash	block_timestamp	in_makingAmount	transaction_hash
0x1111111254eeb25477b68fb85ed929f73a960582	false	7	30421580	0x2c8f1bc9ef93be9266ba54064e333d61a28875d88260b5f9b05577c66adc76e9	2023-07-30T17:56:43.000Z	8498990850755844000	0xbd4bf0c4a5b330c1f760e3f692195d0e35616d8d34e2dbbe39753457f09b97d1
0x1111111254eeb25477b68fb85ed929f73a960582	false	8	30418889	0x49aff04d596adce9c3116f7b62cf2a2979c938a81c1e9652fcd0fe6f37a48dca	2023-07-30T15:41:49.000Z	212499703736438870	0x5879ccd782b5af88ce1255870d99345f68e98ec24f094d276166c825a91e8434
0x1111111254eeb25477b68fb85ed929f73a960582	false	9	30411843	0x8969200b2d7a7cbf8ba54179a10df7299e5bb6743b5dd49437caded8ff06a20f	2023-07-30T09:48:30.000Z	3362129583948950500	0xc0f8c0cae7197e56ff7bbaec8cd885516ee9669bb46b238e9d686bb083f8ad01

Example Query

Query with partition filter

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

AggregationRouterV5_swap_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`NUMERIC`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_executor`	`STRING`	Address of the executor contract responsible for processing cross-chain message delivery. Hex-encoded, 0x-prefixed, 42-character string.
`in_desc`	`STRUCT<srcToken STRING, dstToken STRING, srcReceiver STRING, dstReceiver STRING, amount STRING, minReturnAmount STRING, flags STRING>`	Swap operation parameters struct containing source and destination token addresses, receiver addresses, token amounts, minimum return amount, execution flags, and permit signature data.
`in_permit`	`STRING`	EIP-2612 permit signature data enabling gasless token approvals for the swap operation. Hex-encoded byte string containing owner address, spender address, value, deadline, and ECDSA signature components (v, r, s).
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
`out_returnAmount`	`STRING`	Amount of tokens returned by the swap operation. Numeric string representation of token quantity in smallest denomination.
`out_spentAmount`	`STRING`	Amount of source tokens consumed by the swap operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
1000000	false	940981	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	55648702	0xdee72d065f2cd0f8f1752a06752a65b3c0b0f63c	2025-07-28T20:28:31.000Z	0x5bd13690cc4673586c1ac0454b7ab8f68e43818125acdff3fecd021bcec6a9eb
1000000	false	965946	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	55644196	0xdee72d065f2cd0f8f1752a06752a65b3c0b0f63c	2025-07-28T19:32:11.000Z	0x190209d81c1603b350be1c9049596b6b08d947fd4e39a3331754e9e40e7e210b
1000000	false	178971	0x12aa3caf	0x1111111254eeb25477b68fb85ed929f73a960582	55627542	0x37899ddddc10e45b2a2245c3e663509db64328cd	2025-07-28T16:04:00.000Z	0xf22983d88026c310257438fdfb92088d42d455b20bba7d5c6570396fa3424a43

Example Query

Query with partition filter

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

AggregationRouterV5_uniswapV3Swap_function

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

Columns

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

Sample Data

gas	value	status	gas_used	in_pools	in_amount	signature	to_address	block_number	from_address	in_minReturn	trace_address	block_timestamp	transaction_hash
250047	0	false	24672	[“363263096396199421982621211414784529438829759872”]	998544687	0xe449022e	0x1111111254eeb25477b68fb85ed929f73a960582	31082069	0xb739e5be612fe4c4eb26323326d7e9185430ecde	909308322215435904183		2023-08-22T18:18:27.000Z	0x779a561e03bd11d40c32bd6a361d9c88555921076a111462f54621ab906a8062
738746	3192000000000000	false	20821	[“86844066927987146567678238757427621737190249800856441850111313036892278685702”]	3192000000000000	0xe449022e	0x1111111254eeb25477b68fb85ed929f73a960582	49781489	0x69460570c93f9de5e2edbc3052bf10125f0ca22d	389057179801574303	0,4	2025-05-16T17:13:18.000Z	0x530dc9f4693c13387c865e22d8980b6126d76cf9f7fa3affccfaf7e9a6fd5dcc
738734	2793000000000000	false	20821	[“86844066927987146567678238757427621737190249800856441850111313036892278685702”]	2793000000000000	0xe449022e	0x1111111254eeb25477b68fb85ed929f73a960582	49781462	0x69460570c93f9de5e2edbc3052bf10125f0ca22d	340443129467184489	0,4	2025-05-16T17:12:38.000Z	0xaa50bb6c979b848fa973665a5dbc87077fba0de44bad8093145a9e58d2e81310

Example Query

Query with partition filter

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

AggregationRouterV5_uniswapV3SwapCallback_function

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

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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

AggregationRouterV5_uniswapV3SwapTo_function

Decoded function calls to the 1inch AggregationRouterV5 contract’s uniswapV3SwapTo method, which executes token swaps through Uniswap V3 pools. Contains input parameters including swap amounts, minimum return thresholds, encoded pool routing data, and recipient addresses, along with transaction execution metadata and actual return amounts.

Columns

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

Sample Data

gas	status	gas_used	in_pools	in_amount	signature	to_address	block_number	from_address	in_recipient	trace_address	block_timestamp	transaction_hash
117045	false	4620	[“57896044618658097713242609638119079379571530630391338243340479439305508678226”]	13900000000000000	0xbc80f1a8	0x1111111254eeb25477b68fb85ed929f73a960582	36966145	0xef2fa3932070d7b8c4f9a3196f79c7cb2825df5a	0x020941c803a8fb168e6820ebb96f4bc3c7c76b4b	0,2,1	2024-03-14T16:10:19.000Z	0x2afe9709fc127f1e15b27124e96d2ece8865f66dfce2763ab753138a23185468
117045	false	4751	[“57896044618658097713244071138895617013217125698104320151599561362763742750761”]	13900000000000000	0xbc80f1a8	0x1111111254eeb25477b68fb85ed929f73a960582	36964868	0xef2fa3932070d7b8c4f9a3196f79c7cb2825df5a	0x020941c803a8fb168e6820ebb96f4bc3c7c76b4b	0,2,1	2024-03-14T15:06:07.000Z	0xb33546b8898838a9811f702897b0fd0d28d423388a9e4589bc8a03e5b52e29eb
117045	false	4751	[“57896044618658097713244071138895617013217125698104320151599561362763742750761”]	13900000000000000	0xbc80f1a8	0x1111111254eeb25477b68fb85ed929f73a960582	36965054	0xef2fa3932070d7b8c4f9a3196f79c7cb2825df5a	0x020941c803a8fb168e6820ebb96f4bc3c7c76b4b	0,2,1	2024-03-14T15:15:25.000Z	0x47bf37768141da9b961e08f1f015dc830b1bfc593c2af0fc05ba74328b2f16dc

Example Query

Query with partition filter

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

AggregationRouterV5_uniswapV3SwapToWithPermit_function

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

Columns

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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

AggregationRouterV5_unoswap_function

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

Columns

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

Sample Data

gas	status	gas_used	in_pools	in_amount	signature	to_address	in_srcToken	block_number	from_address	in_minReturn	block_timestamp	out_returnAmount	transaction_hash
300000	true	89342	[“57896044618658097713243340388620005416921865218935381111621957715245509538491”]	19775991708642209962381	0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582	0xb5be8d87fce6ce87a24b90abdb019458a8ec31f9	26369707	0xb1c0c09b1018a755de173b8e5f29c8d87e18b0a8	452569555109226062886	2023-03-11T10:16:57.000Z	456190111550099871390	0x07d9591b481f0eba2659a648471008d3e035cb47a11f977441ab23350e8aa5fc
300000	true	247689	[“57896044618658097713243340388089461684854376724198604485308730267506028370966”,“57896044618658097713243340388640986228789554675980162329207092779278157868655”]	330000000000000000000	0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582	0xe9e7cea3dedca5984780bafc599bd69add087d56	26364207	0xb1c0c09b1018a755de173b8e5f29c8d87e18b0a8	3257605714820906244728	2023-03-11T05:40:27.000Z	3258811102371805212593	0xb72fb4f0c2d598217d56bd7332fe910d08e27319491505b8027fc7a202d85232
300000	true	247689	[“57896044618658097713243340388089461684854376724198604485308730267506028370966”,“57896044618658097713243340388640986228789554675980162329207092779278157868655”]	330000000000000000000	0x0502b1c5	0x1111111254eeb25477b68fb85ed929f73a960582	0xe9e7cea3dedca5984780bafc599bd69add087d56	26365239	0xb1c0c09b1018a755de173b8e5f29c8d87e18b0a8	3265922413774285362155	2023-03-11T06:32:31.000Z	3292049793084479645053	0xe72007a7d75f174dacb1d102ac9eaf562e5b58e745201e2bfd39ba774eb4a74e

Example Query

Query with partition filter

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

AggregationRouterV5_unoswapTo_function

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

Columns

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

Sample Data

gas	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
96510	18800000000000000	true	81374	[“57896044618658097713243340388478612507983905397949883345241148622002191265279”]	18800000000000000	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	0x0000000000000000000000000000000000000000	36130654	0x0425841529882628880fbd228ac90606e0c2e09a	365636497641041349612	0xcba41dfaa47fb26318cc576c839306eb46470e3a	0	2024-02-14T14:29:07.000Z	373098466980654438380	0x23abc4aee76c05068beaa49fb82302d1787807704fb6833101f3a44d76fb1a67
108591	0	true	88616	[“28948022309329048857350594135756802472603821558306559488186810731759365257693”]	191612203705829984535	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	0x85eac5ac2f758618dfa09bdbe0cf174e7d574d5b	36138663	0x0425841529882628880fbd228ac90606e0c2e09a	72218055180324430	0x996ee28072dda20f2b9f1eb6d00572975c1f8bc4	2	2024-02-14T21:10:06.000Z	73691893041147378	0xa395a162d8cc78e883036fbefd4ed85a6759a3883fd886ee3fc4f0719e5b7402
260493	0	true	169006	[“1457847884277936917914228022471434882860360111244574256906”,“57896044618658097713243340387711267671031357580073609987120633324868916153774”]	11452284600000000000000	0xf78dc253	0x1111111254eeb25477b68fb85ed929f73a960582	0x6cb755c4b82e11e727c05f697c790fdbc4253957	36116396	0x0051437667689b36f9cfec31e4f007f1497c0f98	21703509177637682530	0x7c795e30c0dc3dc06f6ca3ed4fab29f9f06e38fc		2024-02-14T02:35:13.000Z	21924351705936530578	0x7a752636ec2218e1fa5bdb66f966a877d3f21e3c013a2a8fa800bc2a04b9f190

Example Query

Query with partition filter

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

AggregationRouterV5_unoswapToWithPermit_function

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

Columns

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

Sample Data

gas	status	gas_used	in_pools	in_amount	in_permit	signature	to_address	in_srcToken	block_number	from_address	in_minReturn	in_recipient	block_timestamp	out_returnAmount	transaction_hash
153908	true	143516	[“1458578635474184646077062895245462369418850616859449996710”]	102637062179261000350	0x00000000000000000000000000000489abe83e08f2c14f101857c66075f5ad240000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000065df2f52000000000000000000000000000000000000000000000000000000000000001c31be8b3b85e0e927b9e67d7f2119138a6ac236a3297d8a9d998eea4f9be4f918090b756a7e1f305cdadece56d5d68d89b0cb064ba6d05948c6d28ffc20ae8538	0x3c15fd91	0x1111111254eeb25477b68fb85ed929f73a960582	0x111111111117dc0aa78b770fa6a738034120c302	36502594	0x00000489abe83e08f2c14f101857c66075f5ad24	49758586612478403955	0x00000489abe83e08f2c14f101857c66075f5ad24	2024-02-27T13:04:35.000Z	49783478351654231071	0xb7f56f380b36ce82eaea97592257b1d647d3ff6f277895a1d864072839da49b3
358892	true	298512	[“1457847884553788401134603077566599143874205452374709736076”,“57896044618658097713244071138867770799850491192367026901208433051351714045331”,“57896044618658097713243340388739651164374889123458345172505044540995985915271”]	537846650622532442398	0x0000000000000000000000004a2d1f983ec177bdab80c726b966eba33e7fb3a80000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064c7f073000000000000000000000000000000000000000000000000000000000000001cbd492407694b4633de329f5ea6d5d46d22419a4e76cebc09e5f0977545f76a2071f34b8de812393203cf9483cc7974bfe1aad1e5ea9edc4dd323b21d3ae3bd6b	0x3c15fd91	0x1111111254eeb25477b68fb85ed929f73a960582	0xad6742a35fb341a9cc6ad674738dd8da98b94fb1	30421126	0x4a2d1f983ec177bdab80c726b966eba33e7fb3a8	47253960867386768410971	0x4a2d1f983ec177bdab80c726b966eba33e7fb3a8	2023-07-30T17:34:01.000Z	47731273603420978192901	0x11bc55e97319a565db40ea619009a07140f4f0c9a77736fc7e31e2679ef49bfd
216075	true	160599	[“28948022309329048857350594135925310930168271407019952978151342729548159688372”]	37113757895103168512	0x000000000000000000000000133ce67b95b553bf7609f9816315a7d36d61671c0000000000000000000000001111111254eeb25477b68fb85ed929f73a960582ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000064c738c0000000000000000000000000000000000000000000000000000000000000001b651f52d8a311b561e83f86fb8791d9d3dc5b63076bb0e7a3a38cea20137608a76523d66c9d1e5d80ffce16be49edaf0243f155d074da9278525b7e0c072b5e05	0x3c15fd91	0x1111111254eeb25477b68fb85ed929f73a960582	0x2dff88a56767223a5529ea5960da7a3f5f766406	30405585	0x133ce67b95b553bf7609f9816315a7d36d61671c	38085584966411122	0x133ce67b95b553bf7609f9816315a7d36d61671c	2023-07-30T04:33:12.000Z	38470287844859720	0xbb1f5242fba18ae60d66f11945de372cae3a41fa08d96780b02d62b874874402

Example Query

Query with partition filter

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