1inch_v3_bsc

Tables

AggregationRouterV3_discountedSwap_function

Discounted swap function calls from 1inch V3 aggregation router on BNB Smart Chain (BSC), capturing CHI gastoken-subsidized trades with routing details, token addresses, and execution amounts. Used for analyzing gas-optimized swap behavior and CHI token consumption patterns.

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.
`out_chiSpent`	`STRING`	Amount of CHI token consumed for gas optimization. Numeric string representation of CHI tokens burned during transaction execution.

Sample Data

gas	status	in_data	in_desc	gas_used	in_caller	signature	to_address	out_gasLeft	block_number	from_address	out_chiSpent	trace_address	block_timestamp	out_returnAmount	transaction_hash
766668	false	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000003000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001c00000000000000000000000000000000000000000000000000000000000000320800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a4b757fed600000000000000000000000083c5b5b309ee8e232fe9db217d394e262a71bcc000000000000000000000000055d398326f99059ff775485246999027b3197955000000000000000000000000bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c0000000000000000001e848058f876857a02d6762e0101bb5c46a8c1ed44dc16000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a4b757fed600000000000000000000000058f876857a02d6762e0101bb5c46a8c1ed44dc16000000000000000000000000bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d560000000000000000002625a09911e98974d0badde85bd5f4d1f93087aa3ec5fa000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a4b757fed60000000000000000000000009911e98974d0badde85bd5f4d1f93087aa3ec5fa000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d56000000000000000000000000fe19f0b51438fd612f6fd59c1dbb3ea319f433ba0000000000000000002625a0e92fb4538f981b0560056c4a8154739772948fad000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	{“flags”:“12”,“amount”:“311657293019259000000”,“permit”:“0x”,“dstToken”:“0xfe19f0b51438fd612f6fd59c1dbb3ea319f433ba”,“srcToken”:“0x55d398326f99059ff775485246999027b3197955”,“dstReceiver”:“0xe92fb4538f981b0560056c4a8154739772948fad”,“srcReceiver”:“0x83c5b5b309ee8e232fe9db217d394e262a71bcc0”,“minReturnAmount”:“311046269565510318114”}	332158	0xbaf9a5d4b0052359326a6cdab54babaa3a3a9643	0x6c4a483e	0x11111112542d85b3ef69ae05771c2dccff4faa26	434667	19758446	0xe92fb4538f981b0560056c4a8154739772948fad	7	1,0,1,0,2	2022-07-22T00:03:28.000Z	312619043113767369223	0xe565059298e967a8578af8658ddc2869db13e257b86753d8ca24e0f9bbca1451
1504377	false	0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000700000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000038000000000000000000000000000000000000000000000000000000000000005e000000000000000000000000000000000000000000000000000000000000006c00000000000000000000000000000000000000000000000000000000000000b200000000000000000000000000000000000000000000000000000000000000e4080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064eb5625d900000000000000000000000055d398326f99059ff775485246999027b3197955000000000000000000000000114f84658c99aa6ea62e3160a87a16deaf7efe83000000000000000000000000000000000000000000000239e3aff56cf379e1c000000000000000000000000000000000000000000000000000000000800000000000000000000000114f84658c99aa6ea62e3160a87a16deaf7efe8300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c47dc2038200000000000000000000000055d398326f99059ff775485246999027b31979550000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f8000000000000000000000000000000000000000000000239e3aff56cf379e1c00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000baf9a5d4b0052359326a6cdab54babaa3a3a9643000000000000000000000000910bf2d50fa5e014fd06666f456182d4ab7c8bd200000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a4b3af37c0000000000000000000000000000000000000000000000000000000000000008080000000000000000000000000000000000000000000000000000000000000440000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f8000000000000000000000000000000320000000000000000000000000000003200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f990000000000000000000000002170ed0880ac9a755fd29b2688956bd959f933f80000000000000000000000009ba8966b706c905e594acbb946ad5e29509f45eb000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000009ba8966b706c905e594acbb946ad5e29509f45eb0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000024bd6015b4000000000000000000000000baf9a5d4b0052359326a6cdab54babaa3a3a964300000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000003a483f1291f00000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000340000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d56000000000000000000000000000000320000000000000000000000000000003200000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000016080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064eb5625d9000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d56000000000000000000000000860822cac26fb7e74e2cfad2642bc8a14d512270000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000800000000000000000000000860822cac26fb7e74e2cfad2642bc8a14d51227000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000843df0212400000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000003000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000028000000000000000000000000000000000000000000000000000000000000044800000000000000000000000000000000000000000000000000000000000004400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000002647f8fe7a000000000000000000000000000000000000000000000000000000000000000808000000000000000000000000000000000000000000000000000000000000044000000000000000000000000baf9a5d4b0052359326a6cdab54babaa3a3a964300000000000000000000000000000000000000000000000000000000000001e0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a40597122400000000000000000000000014016e85a25aeb13065688cafb43044c2ef867840000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000001000000000000000000000000000000010000000000000000000000000000000000000000000000008b1132b65d84ba6a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004470bdb94700000000000000000000000014016e85a25aeb13065688cafb43044c2ef8678400000000000000000000000000000000000000000000023a4ac8ede31ebbf8130000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a4b3af37c00000000000000000000000000000000000000000000000000000000000000080800000000000000000000000000000000000000000000000000000000000004400000000000000000000000014016e85a25aeb13065688cafb43044c2ef86784000000000000000000000000000000010000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f9900000000000000000000000014016e85a25aeb13065688cafb43044c2ef86784000000000000000000000000e92fb4538f981b0560056c4a8154739772948fad00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	{“flags”:“12”,“amount”:“10512603979756559000000”,“permit”:“0x”,“dstToken”:“0x14016e85a25aeb13065688cafb43044c2ef86784”,“srcToken”:“0x55d398326f99059ff775485246999027b3197955”,“dstReceiver”:“0xe92fb4538f981b0560056c4a8154739772948fad”,“srcReceiver”:“0xbaf9a5d4b0052359326a6cdab54babaa3a3a9643”,“minReturnAmount”:“10414832611123038991767”}	948599	0xbaf9a5d4b0052359326a6cdab54babaa3a3a9643	0x6c4a483e	0x11111112542d85b3ef69ae05771c2dccff4faa26	555935	19758656	0xe92fb4538f981b0560056c4a8154739772948fad	20	1,0,1,0,2	2022-07-22T00:14:29.000Z	10502834258476292246785	0xc5499d7f81983835293e30d5e8dfed2266b97dbf477117601ec51d01ae0d0847
1022046	false	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000003000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001c00000000000000000000000000000000000000000000000000000000000000660800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000a4b757fed600000000000000000000000020bcc3b8a0091ddac2d0bc30f68e6cbb97de59cd000000000000000000000000bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c00000000000000000000000055d398326f99059ff775485246999027b31979550000000000000000001e8480baf9a5d4b0052359326a6cdab54babaa3a3a9643000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000003e483f1291f0000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000038000000000000000000000000055d398326f99059ff775485246999027b3197955000000000000000000000000000000320000000000000000000000000000003200000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000016080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064eb5625d900000000000000000000000055d398326f99059ff775485246999027b3197955000000000000000000000000114f84658c99aa6ea62e3160a87a16deaf7efe83000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000800000000000000000000000114f84658c99aa6ea62e3160a87a16deaf7efe8300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c47dc2038200000000000000000000000055d398326f99059ff775485246999027b31979550000000000000000000000004691937a7508860f876c9c0a2a617e7d9e945d4b00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000baf9a5d4b0052359326a6cdab54babaa3a3a9643000000000000000000000000910bf2d50fa5e014fd06666f456182d4ab7c8bd20000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000028000000000000000000000000000000000000000000000000000000000000044800000000000000000000000000000000000000000000000000000000000004400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000001a4b3af37c0000000000000000000000000000000000000000000000000000000000000008080000000000000000000000000000000000000000000000000000000000000440000000000000000000000004691937a7508860f876c9c0a2a617e7d9e945d4b000000000000000000000000000000010000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000064d1660f990000000000000000000000004691937a7508860f876c9c0a2a617e7d9e945d4b000000000000000000000000e92fb4538f981b0560056c4a8154739772948fad00000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	{“flags”:“12”,“amount”:“1655798556487199700”,“permit”:“0x”,“dstToken”:“0x4691937a7508860f876c9c0a2a617e7d9e945d4b”,“srcToken”:“0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c”,“dstReceiver”:“0xe92fb4538f981b0560056c4a8154739772948fad”,“srcReceiver”:“0x20bcc3b8a0091ddac2d0bc30f68e6cbb97de59cd”,“minReturnAmount”:“2250475490422357530909”}	653991	0xbaf9a5d4b0052359326a6cdab54babaa3a3a9643	0x6c4a483e	0x11111112542d85b3ef69ae05771c2dccff4faa26	368212	19759787	0xe92fb4538f981b0560056c4a8154739772948fad	14	1,0,1,0,2	2022-07-22T01:13:10.000Z	0	0x62e98501a880d5c9aeb4a16f7538c1c74c9c2a9b88087e918dbabf4ca44dccf9

Example Query

Query with partition filter

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

AggregationRouterV3_swap_function

Token swap execution records from 1inch v3 aggregation router on BNB Smart Chain. Captures failed swap attempts with gas consumption, caller addresses, and transaction context for analyzing routing efficiency and transaction failure patterns.

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	trace_address	block_timestamp	transaction_hash
1557277	false	190688	0x7c025200	0x11111112542d85b3ef69ae05771c2dccff4faa26	14742800	0x71ac7699c60c210d2a14f5aa59a33c3f06d49e6c	1	2022-01-27T22:16:33.000Z	0x68aec83fb754620aaa9dd86171ff46ee4ef5c7aa274f2b8780b13fa3ac39cbea
1226145	false	205279	0x7c025200	0x11111112542d85b3ef69ae05771c2dccff4faa26	14742903	0x11111112542d85b3ef69ae05771c2dccff4faa26	8,0	2022-01-27T22:22:14.000Z	0x179dbab415f99601c585e5f143c500627005ab301f8d35a8b748c7b20d54f671
1546063	false	865762	0x7c025200	0x11111112542d85b3ef69ae05771c2dccff4faa26	14742330	0x11111112542d85b3ef69ae05771c2dccff4faa26	3,0	2022-01-27T21:51:56.000Z	0x6fedf8ec833c6972a61f89fdd4da895b93d8224d20ec0aef25c43db62a602ad8

Example Query

Query with partition filter

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

AggregationRouterV3_Swapped_event

Token swap execution events from 1inch V3 aggregation router on BNB Smart Chain (BSC). Records include source/destination tokens, amounts spent/received, sender addresses, and receivers for analyzing DEX aggregator trading patterns.

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_sender`	`STRING`	Address that initiated the transaction 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_dstReceiver`	`STRING`	Address that receives the destination tokens from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_spentAmount`	`STRING`	Actual amount of source tokens spent in the swap. Numeric string representation of token quantity in smallest denomination.
`in_returnAmount`	`STRING`	Actual amount of destination tokens received from the swap. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_dstToken	in_srcToken	block_number	in_dstReceiver	in_spentAmount	block_timestamp	in_returnAmount	transaction_hash
0x11111112542d85b3ef69ae05771c2dccff4faa26	false	0x9681f21e1e1441d88f6059757f43c697dbaed961	218	0x1d2f0da169ceb9fc7b3144628db156f3f6c60dbe	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	32223570	0x9681f21e1e1441d88f6059757f43c697dbaed961	453959105292138418	2023-10-01T12:49:43.000Z	187913671799197726676	0x972a77ca723b76492a3c8710d47a7d0f0dcf5bc16d816170579991683c7717d6
0x11111112542d85b3ef69ae05771c2dccff4faa26	false	0xfbb3b84a1e2bd54ba8b9b4726fd5bf97705fe622	96	0x1d2f0da169ceb9fc7b3144628db156f3f6c60dbe	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	32214032	0xfbb3b84a1e2bd54ba8b9b4726fd5bf97705fe622	308804931626457834	2023-10-01T04:51:48.000Z	128485640944266246177	0x0645844272e893fbf5c12a5fcee33589918cc185c47c7cbd46bb8dd4c551f8e5
0x11111112542d85b3ef69ae05771c2dccff4faa26	false	0x9681f21e1e1441d88f6059757f43c697dbaed961	263	0x3ee2200efb3400fabb9aacf31297cbdd1d435d47	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	32223543	0x9681f21e1e1441d88f6059757f43c697dbaed961	272140909073213799	2023-10-01T12:48:22.000Z	224153402090963585027	0xaa17f0d22a97784ba8aa9df6d591557130cbcc5d88964aee1ffb3f0a84c128d2

Example Query

Query with partition filter

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

AggregationRouterV3_unoswap_function

Individual swap executions through 1inch V3’s unoswap function on BNB Smart Chain (BSC), capturing input amounts, minimum return thresholds, and actual output amounts. Used for analyzing slippage, swap efficiency, and token routing patterns through the 1inch aggregation router.

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_anon3`	`ARRAY<STRING>`	Sequential counter tracking the total number of pairs created by the factory contract.
`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_anon3	in_amount	signature	to_address	in_srcToken	block_number	from_address	in_minReturn	block_timestamp	out_returnAmount	transaction_hash
182232	238023767213175550	true	95997	[“0x80000000000000003b7c4580a527a61703d82139f8a06bc30097cc9caa2df5a6”]	238023767213175540	0x2e95b6c8	0x11111112542d85b3ef69ae05771c2dccff4faa26	0x0000000000000000000000000000000000000000	33419645	0xf04d00cd87e09aeb760d150c535e2522a912377f	26431488650214863810	2023-11-12T05:15:57.000Z	26970906785933534501	0x137135ffa7f7cf85eb167e62f85e1073d978404ca532498aea7c2a563ffcbb91
208855	95667978689699140	true	113469	[“0x80000000000000003b7c45804c48d692e3de076c7b844b956b28cdd1dd5c0945”]	95667978689699129	0x2e95b6c8	0x11111112542d85b3ef69ae05771c2dccff4faa26	0x0000000000000000000000000000000000000000	33429920	0xaf523fa3fc2b3f99b227f4c5f0333a0480582897	17430556558654575734	2023-11-12T13:51:10.000Z	17786282202708750749	0x736e05e90e625f6855936fbcb05762456350c6c0fa44e0ef06df6e035437860f
535971	663041346032479	true	328138	[“0x00000000000000003b74a460c736ca3d9b1e90af4230bd8f9626528b3d4e0ee0”]	663041346032479	0x2e95b6c8	0x11111112542d85b3ef69ae05771c2dccff4faa26	0x0000000000000000000000000000000000000000	33417939	0x5fc6608f1b88fcea5c98e9a18e70fc1114f377f5	124306829812731913	2023-11-12T03:49:45.000Z	126843703890542769	0x8459c7aac8a6bd75614a0a677df4bd0cbd25b08bb0ddfa492bbf58a5ea57a95e

Example Query

Query with partition filter

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

AggregationRouterV3_unoswapWithPermit_function

No description available.

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

No sample data available.

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AggregationRouterV3_discountedSwap_function

AggregationRouterV3_swap_function

AggregationRouterV3_Swapped_event

AggregationRouterV3_unoswap_function

AggregationRouterV3_unoswapWithPermit_function

​Tables

​AggregationRouterV3_discountedSwap_function

​AggregationRouterV3_swap_function

​AggregationRouterV3_Swapped_event

​AggregationRouterV3_unoswap_function

​AggregationRouterV3_unoswapWithPermit_function

Tables

AggregationRouterV3_discountedSwap_function

AggregationRouterV3_swap_function

AggregationRouterV3_Swapped_event

AggregationRouterV3_unoswap_function

AggregationRouterV3_unoswapWithPermit_function