Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_srcTokenSTRINGContract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
in_dstTokenSTRINGContract address of the destination token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_dstReceiverSTRINGAddress that receives the destination tokens from the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_spentAmountSTRINGActual amount of source tokens spent in the swap. Numeric string representation of token quantity in smallest denomination.
in_returnAmountSTRINGActual amount of destination tokens received from the swap. Numeric string representation of token quantity in smallest denomination.
in_minReturnAmountSTRINGMinimum 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_guaranteedAmountSTRINGMinimum 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_referrerSTRINGAddress that referred the user to the protocol or facilitated the transaction. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_amountin_senderlog_indexin_dstTokenin_referrerin_srcTokenblock_numberin_dstReceiverin_spentAmountblock_timestampin_returnAmounttransaction_hashin_minReturnAmountin_guaranteedAmount
0x111111254bf8547e7183e4bbfc36199f3cedf4a1false100000000000000000xf0127a6186cd2447795b01563cd3a8b4ed12ee3f4110x111111111117dc0aa78b770fa6a738034120c3020x1fb53eb183b86582176f6aa8f4db72b62caf0d4b0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee250064330x8229bc97f0b7f5d6b7bf000b7f8deb5c98d801bf100000000000000002023-01-22T12:04:20.000Z53770279217309123660x5eb07dfc745755876bac24eb25348ea3ad25dbfbb571bb0e7de4508b1f74d8a712968816939179407911365138625176779780
0x111111254bf8547e7183e4bbfc36199f3cedf4a1false100000000000000000xf0127a6186cd2447795b01563cd3a8b4ed12ee3f1190xfad8e46123d7b4e77496491769c167ff894d2acb0x00000000000000000000000000000000000000000xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee250113770xf0127a6186cd2447795b01563cd3a8b4ed12ee3f100000000000000002023-01-22T16:15:47.000Z16604885847030538090x96f0fc5c5a105c6680b69139b5b62058214ad34c46c18381ddc3d71177ca69818302442923515269041660488584703053809
0x111111254bf8547e7183e4bbfc36199f3cedf4a1false100000000000000000xf0127a6186cd2447795b01563cd3a8b4ed12ee3f1380xfad8e46123d7b4e77496491769c167ff894d2acb0x00000000000000000000000000000000000000000xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee250116290xf0127a6186cd2447795b01563cd3a8b4ed12ee3f100000000000000002023-01-22T16:28:24.000Z16604885847030538090x7734731bd7a66775775b995b6be034e3b90e136c3e164aab639b518e00b9b1818302442923515269041660488584703053809
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