1inch_v4_bsc

Tables

AggregationRouterV4_fillOrderRFQ_function

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

Columns

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

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash
381693	0	false	1529	0xd0a3b665	0x1111111254fb6c44bac0bed2854e76f90643097d	13641706	0x3790c9b5a9b9d9aa1c69140a5f01a57c9b868e1e	1,2,2	2021-12-20T13:46:55.000Z	0xd0c7cc3718a801ec605acdde580550a8cd72d7199ee6664129811da4a401cb85
213885	754169397465539500	false	1529	0xd0a3b665	0x1111111254fb6c44bac0bed2854e76f90643097d	13645138	0x3790c9b5a9b9d9aa1c69140a5f01a57c9b868e1e	1,2,1	2021-12-20T16:39:11.000Z	0x57ef4b04e4f2956ef0413e65549912ccead12d7aa9946fd1847d05ae25020cd8
245888	488137668272524350	false	1529	0xd0a3b665	0x1111111254fb6c44bac0bed2854e76f90643097d	13642838	0x3790c9b5a9b9d9aa1c69140a5f01a57c9b868e1e	1,2,1	2021-12-20T14:43:48.000Z	0x12e09d0e632e0dfe8be29bc398457938725ccbed75079cecd498c68d0e88ad26

Example Query

Query with partition filter

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

AggregationRouterV4_fillOrderRFQTo_function

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

Columns

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

Sample Data

gas	value	status	gas_used	in_order	in_target	out_anon0	out_anon1	signature	to_address	block_number	from_address	in_signature	trace_address	block_timestamp	in_takingAmount	transaction_hash
151700	0	true	106764	{“info”:“30556982897047990706028100057”,“maker”:“0xb398ffef80144095b8712c70a0c09886c8151feb”,“makerAsset”:“0xe9e7cea3dedca5984780bafc599bd69add087d56”,“takerAsset”:“0x55d398326f99059ff775485246999027b3197955”,“makingAmount”:“92245454420907751838”,“takingAmount”:“92430315051009771381”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x37c787193de657efa1f792a3e65586331552f335	92245454420907751838	92430315051009771381	0xbaba5855	0x1111111254fb6c44bac0bed2854e76f90643097d	19109086	0x8224ca9df0e74f186067e6204d50aab8a9997f3d	0x8a0e2cc0c1252af5aba2891c19b3b6527ba3b007d8f635fd901251247496d64c4f773f78f8d07cc2116d4083995c959f986808e43eccfe65f43a93717cb50764		2022-06-29T10:08:05.000Z	92430315051009771381	0xc8ba8bdf621213c6a64e17e09bc46833e78c4e2be5f6ac011c244264d1a7268a
154594	2886257932000000000	true	105458	{“info”:“57896044618658097711785492504343953926634992332850839497698098460059168819224”,“maker”:“0xbe883a42d6ae7f08f73d7d91c69e603f61b58e3d”,“makerAsset”:“0x55d398326f99059ff775485246999027b3197955”,“takerAsset”:“0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c”,“makingAmount”:“625368884491349393408”,“takingAmount”:“2886257932000000000”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x4a7b00d3f6b08522df8e48ebe4e0cdbb7763e075	625368884491349393408	2886257932000000000	0xbaba5855	0x1111111254fb6c44bac0bed2854e76f90643097d	19118002	0xb9d3d7f194070695e69d7f2bdabca84b9e0fb208	0xf2e11dd814ecad37bcea70dc2985609c49919cbab18c1cc85641d625a342d0b2392859e09238f3a579054e0a1846b45a001a5ebfe425282d42fafee403cc4e671c		2022-06-29T17:34:21.000Z	2886257932000000000	0xf8b3f68545a94026c1e7bf39615320da63a2c1f189dae981c4d6dafa012ec72c
144862	0	true	80078	{“info”:“30357816754407367217830575727”,“maker”:“0xb398ffef80144095b8712c70a0c09886c8151feb”,“makerAsset”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“takerAsset”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“makingAmount”:“546367419690026395724”,“takingAmount”:“231247056202660683”,“allowedSender”:“0x0000000000000000000000000000000000000000”}	0x910bf2d50fa5e014fd06666f456182d4ab7c8bd2	546367419690026395724	231247056202660683	0xbaba5855	0x1111111254fb6c44bac0bed2854e76f90643097d	15534056	0x98468c0e9342d4e0ac3e09257251fab192992092	0x98637f9a4942bc9b6d57a8827e6323e954fcfc3772d4e8d9ba2567e2e1966a3c55b342a9da603c554711aef376a98c79800e466b98cce08df126569320dcffc71b	1	2022-02-24T11:00:59.000Z	231247056202660683	0xd32e63a37f2291b3ed5274323b28652780856099ebbadf5845e3d186c3987efe

Example Query

Query with partition filter

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

AggregationRouterV4_fillOrderRFQToWithPermit_function

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

Columns

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

Sample Data

gas	value	status	gas_used	in_order	in_permit	in_target	out_anon0	out_anon1	signature	to_address	block_number	from_address	in_signature	trace_address	block_timestamp	in_makingAmount	in_takingAmount	transaction_hash
231711	0	false	56398						0x4cc4a27b	0x1111111254fb6c44bac0bed2854e76f90643097d	21977036	0xa4fa8a93abcd166c4a7648ee44f3f73fd878486b			2022-10-07T18:44:59.000Z			0x68d95442a8fb8a1283ff73263cac97906ca777f1b0ebbc4f619e191ea3061534

Example Query

Query with partition filter

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

AggregationRouterV4_OrderFilledRFQ_event

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

Columns

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

Sample Data

address	removed	log_index	block_number	in_orderHash	block_timestamp	in_makingAmount	transaction_hash
0x1111111254fb6c44bac0bed2854e76f90643097d	false	4	18060304	0x50b67806af968af92b09340df2630f0af62874ae3531ce9a62e4938b84d16293	2022-05-23T19:29:27.000Z	29940000000000000000	0x094dc5e4672975d219ec14f4e112e292658e8c3ebcafebd61c436292af63685c
0x1111111254fb6c44bac0bed2854e76f90643097d	false	4	18046241	0x26e923f75daf0444fef3326417f398fe3e05e7d5e81c958bf561f6c4fc53488c	2022-05-23T07:43:03.000Z	96206790493356000000	0xa6885ae8dcb8cfc92edf87e0727e8c3cb49ba88e196a1ce25987926e25c29868
0x1111111254fb6c44bac0bed2854e76f90643097d	false	4	18057527	0x8ac3a31c048ef3ef21d297ba341dfa161e029eee31a0228e11dc1e15eabbe2b2	2022-05-23T17:10:32.000Z	1537092334194240046781	0x95b303026d9b7478d5c0e40ae3a8c7b881d2083d98291b71c4847870c118b9f2

Example Query

Query with partition filter

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

AggregationRouterV4_swap_function

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

Columns

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

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
209652	false	38160	0x7c025200	0x1111111254fb6c44bac0bed2854e76f90643097d	13160286	0xa695e74fe0bc15486940c251721ab55e81fe47b6	2021-12-03T13:37:51.000Z	0xad90425e2a818813a66eed6bb8b7965b35e3a45002f0814a782f27022350ca1f
369947	false	289910	0x7c025200	0x1111111254fb6c44bac0bed2854e76f90643097d	13163123	0xa52163098688879486d617a589a78cd14d492d2a	2021-12-03T16:02:07.000Z	0x9d9ff7b6aedba9d1f14d99ddc355cbc2c1089875cabbdf48c6365b9da556c439
432359	false	64791	0x7c025200	0x1111111254fb6c44bac0bed2854e76f90643097d	13162808	0xb2a41af8436c2deadde16a77f0a6487f403c1fdd	2021-12-03T15:46:19.000Z	0xc52ad1637d0d9eb1c3d427f6e1bb4c4ff3ee03e6b6e20a90a7c741df49bebf49

Example Query

Query with partition filter

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

AggregationRouterV4_uniswapV3Swap_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`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	block_timestamp	transaction_hash
183036	11000000000000000	false	55471	[“86844066927987146567678238756946312465537229656136433808555285582870614799419”]	11000000000000000	0xe449022e	0x1111111254fb6c44bac0bed2854e76f90643097d	15247224	0x10960a530ebdddbdfc49fabe72c21eb77771e7da	11527259872	2022-02-14T11:08:06.000Z	0x1164ee3c66c1805d8cc5682a2f75a7bc9f6fc4713cedf09ee91af090dbd63d39
252946	0	false	24976	[“163248960865057146580983398007839793088586855897”,“57896044618658097711785492505204238924778906940556566059624475180444131503134”]	8000000000000000000	0xe449022e	0x1111111254fb6c44bac0bed2854e76f90643097d	16012239	0x8ef7f3651800194968e04030cb09c0d130514111	1840274655967126287438306756	2022-03-13T03:22:34.000Z	0xf06286b9599737d2f0603c838d7ec14d2cee6c4de498379f50f103cc688c3db9
205939	394195066123280	false	55566	[“28948022309329048855892746253302491346327489016767269287504344742136162334738”]	394195066123280	0xe449022e	0x1111111254fb6c44bac0bed2854e76f90643097d	21413418	0x7c975bf83def7450cd766c4c68f6b9ae40096586	5633839014616502118864151836	2022-09-17T14:40:18.000Z	0xccb7cbaa46ca9da892d028d6be25f6900fed3335e3c012997c368f789a2aa83b

Example Query

Query with partition filter

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

AggregationRouterV4_uniswapV3SwapCallback_function

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

Columns

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

AggregationRouterV4_uniswapV3SwapTo_function

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

Columns

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

No sample data available.

Example Query

Query with partition filter

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

AggregationRouterV4_uniswapV3SwapToWithPermit_function

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

Columns

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

AggregationRouterV4_unoswap_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`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	value	status	gas_used	in_pools	in_amount	signature	to_address	in_srcToken	block_number	from_address	in_minReturn	block_timestamp	out_returnAmount	transaction_hash
900000	0	false	462668	[]		0x2e95b6c8	0x1111111254fb6c44bac0bed2854e76f90643097d		33770218	0xb0b0761752c5b0b509094c51340721ba1214cd08		2023-11-24T10:33:41.000Z		0x9721949cdaa6763a51b34c27362ab345f15de32460db1edbd75f59869220e1a2
226593	0	false	158023	[]		0x2e95b6c8	0x1111111254fb6c44bac0bed2854e76f90643097d		33779237	0x41865e36c5cbceb187e9f1921f7a3cddcba6e401		2023-11-24T18:05:35.000Z		0x7095397e7dc3604e40f373176ae07f513b209e4308b2ac162c08aa2879995777
208335	15717586500000000	true	113128	[“0x80000000000000003b7c4580c7b4b32a3be2cb6572a1c9959401f832ce47a6d2”]	15717586500000000	0x2e95b6c8	0x1111111254fb6c44bac0bed2854e76f90643097d	0x0000000000000000000000000000000000000000	33777877	0x3f220c9b44970639d07a29bed26c709630cfb5a2	5807332813386490419	2023-11-24T16:57:21.000Z	5925849809578051448	0xd9756c5b0723520482602034dcc8b71bdb604ad3d2b8faa5259460f34f83309d

Example Query

Query with partition filter

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

AggregationRouterV4_unoswapWithPermit_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`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.
`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	value	status	gas_used	in_pools	in_amount	in_permit	signature	to_address	in_srcToken	block_number	from_address	in_minReturn	trace_address	block_timestamp	out_returnAmount	transaction_hash
55555	0	false	24436	[]			0xa1251d75	0x1111111254fb6c44bac0bed2854e76f90643097d		17922789	0xbbc1e9bf4ad9f3173d774ac03c8ac0c5989168db			2022-05-19T00:25:21.000Z		0xc9bb9d10618fe7dd9d17678967eb5ff82811c19572a6323731553e6cfdbf2161
55555	0	false	24664	[]			0xa1251d75	0x1111111254fb6c44bac0bed2854e76f90643097d		17922848	0xbbc1e9bf4ad9f3173d774ac03c8ac0c5989168db			2022-05-19T00:28:18.000Z		0xc0da39b46f68fce74d856b5023d63361832a7ffc08e9bc8879cec7de7a86b55a

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AggregationRouterV4_fillOrderRFQ_function

AggregationRouterV4_fillOrderRFQTo_function

AggregationRouterV4_fillOrderRFQToWithPermit_function

AggregationRouterV4_OrderFilledRFQ_event

AggregationRouterV4_swap_function

AggregationRouterV4_uniswapV3Swap_function

AggregationRouterV4_uniswapV3SwapCallback_function

AggregationRouterV4_uniswapV3SwapTo_function

AggregationRouterV4_uniswapV3SwapToWithPermit_function

AggregationRouterV4_unoswap_function

AggregationRouterV4_unoswapWithPermit_function

​Tables

​AggregationRouterV4_fillOrderRFQ_function

​AggregationRouterV4_fillOrderRFQTo_function

​AggregationRouterV4_fillOrderRFQToWithPermit_function

​AggregationRouterV4_OrderFilledRFQ_event

​AggregationRouterV4_swap_function

​AggregationRouterV4_uniswapV3Swap_function

​AggregationRouterV4_uniswapV3SwapCallback_function

​AggregationRouterV4_uniswapV3SwapTo_function

​AggregationRouterV4_uniswapV3SwapToWithPermit_function

​AggregationRouterV4_unoswap_function

​AggregationRouterV4_unoswapWithPermit_function

Tables

AggregationRouterV4_fillOrderRFQ_function

AggregationRouterV4_fillOrderRFQTo_function

AggregationRouterV4_fillOrderRFQToWithPermit_function

AggregationRouterV4_OrderFilledRFQ_event

AggregationRouterV4_swap_function

AggregationRouterV4_uniswapV3Swap_function

AggregationRouterV4_uniswapV3SwapCallback_function

AggregationRouterV4_uniswapV3SwapTo_function

AggregationRouterV4_uniswapV3SwapToWithPermit_function

AggregationRouterV4_unoswap_function

AggregationRouterV4_unoswapWithPermit_function