1inch_v2_bsc

Tables

OneInchExchange_Swapped_event

Token swap execution events from 1inch v2 DEX aggregator on BNB Smart Chain (BSC). Captures source and destination tokens, amounts spent and received, sender and receiver addresses, with slippage protection parameters for analyzing swap efficiency and routing behavior.

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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`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.
`in_minReturnAmount`	`STRING`	Minimum acceptable amount of destination tokens the user was willing to receive, specified as slippage protection. Values are in smallest token units (wei-equivalent) and swap would revert if actual return fell below this threshold.
`in_guaranteedAmount`	`STRING`	Minimum amount of destination tokens guaranteed to be received in the swap, denominated in the smallest unit (wei-equivalent) of the destination token. Value acts as a price floor to protect against slippage during order execution.
`in_referrer`	`STRING`	Address that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_amount	in_sender	log_index	in_dstToken	in_referrer	in_srcToken	block_number	in_dstReceiver	in_spentAmount	block_timestamp	in_returnAmount	transaction_hash	in_minReturnAmount	in_guaranteedAmount
0x111111254bf8547e7183e4bbfc36199f3cedf4a1	false	10000000000000000	0xf0127a6186cd2447795b01563cd3a8b4ed12ee3f	411	0x111111111117dc0aa78b770fa6a738034120c302	0x1fb53eb183b86582176f6aa8f4db72b62caf0d4b	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	25006433	0x8229bc97f0b7f5d6b7bf000b7f8deb5c98d801bf	10000000000000000	2023-01-22T12:04:20.000Z	5377027921730912366	0x5eb07dfc745755876bac24eb25348ea3ad25dbfbb571bb0e7de4508b1f74d8a7	1296881693917940791	1365138625176779780
0x111111254bf8547e7183e4bbfc36199f3cedf4a1	false	10000000000000000	0xf0127a6186cd2447795b01563cd3a8b4ed12ee3f	119	0xfad8e46123d7b4e77496491769c167ff894d2acb	0x0000000000000000000000000000000000000000	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	25011377	0xf0127a6186cd2447795b01563cd3a8b4ed12ee3f	10000000000000000	2023-01-22T16:15:47.000Z	1660488584703053809	0x96f0fc5c5a105c6680b69139b5b62058214ad34c46c18381ddc3d71177ca6981	830244292351526904	1660488584703053809
0x111111254bf8547e7183e4bbfc36199f3cedf4a1	false	10000000000000000	0xf0127a6186cd2447795b01563cd3a8b4ed12ee3f	138	0xfad8e46123d7b4e77496491769c167ff894d2acb	0x0000000000000000000000000000000000000000	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	25011629	0xf0127a6186cd2447795b01563cd3a8b4ed12ee3f	10000000000000000	2023-01-22T16:28:24.000Z	1660488584703053809	0x7734731bd7a66775775b995b6be034e3b90e136c3e164aab639b518e00b9b181	830244292351526904	1660488584703053809

Example Query

Query with partition filter

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

1inch_v1_bsc 1inch_v3_bsc

⌘I

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

OneInchExchange_Swapped_event

​Tables

​OneInchExchange_Swapped_event

Tables

OneInchExchange_Swapped_event