1inch_v2_ethereum

Tables

LimitOrderProtocol_OrderFilledRFQ_event

RFQ (Request for Quote) limit order fill events from 1inch v2 protocol on Ethereum, capturing maker amounts and order hashes when orders execute. Used for tracking private market maker fills and analyzing RFQ trading volume.

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
0x119c71d3bbac22029622cbaec24854d3d32d2828	false	509	13848282	0x9514e34614d3ff2faf73c80b51d90ac5e655e46fdab4ad99c12f7bfcfa347392	2021-12-21T11:32:16.000Z	1000000	0xa9a3835417067a0fbc1a83eba09569c683720097bb8ef21fb3f6d239b3c76b12

Example Query

Query with partition filter

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

OneInchExchange_Swapped_event

Token swap event logs from 1inch v2 decentralized exchange aggregator on Ethereum. Captures source and destination token addresses, amounts spent and received, sender and receiver addresses, slippage parameters, and optional referrer data for analyzing DEX trading activity.

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 for the swap to execute. Serves as slippage protection, preventing execution if market conditions worsen below this threshold.
`in_guaranteedAmount`	`STRING`	Minimum amount of destination tokens guaranteed by 1inch to be received by the user. Represents a floor price protection mechanism, typically calculated from the quoted rate minus acceptable slippage.
`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
0x111111125434b319222cdbf8c261674adb56f3ae	false	235000000000000000	0x066aea7f5a27e0002bfa88b4df4c6717d7c8ac29	158	0x0000000000004946c0e9f43f4dee607b0ef1fa1c	0x0000000000000000000000000000000000000000	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	12308003	0x066aea7f5a27e0002bfa88b4df4c6717d7c8ac29	235000000000000000	2021-04-25T07:10:39.000Z	174	0xf3a298bd0f58d0438a11b1a8ec385f097d6a647350bd819ff48df2dfbd0d786f	173	174
0x111111125434b319222cdbf8c261674adb56f3ae	false	50000000000	0x35da3d2f891ba64e6fc625a1ff2b1074c41f5559	42	0x04fa0d235c4abf4bcf4787af4cf447de572ef828	0x0000000000000000000000000000000000000000	0xdac17f958d2ee523a2206206994597c13d831ec7	12310147	0x35da3d2f891ba64e6fc625a1ff2b1074c41f5559	50000000000	2021-04-25T15:02:23.000Z	1967330379108234477825	0xbc055de67dfa9ae9bd30c395c37714f35f74c68abfdf4531efd46c92652d7b2f	1947081712486945083609	2028210117173901128760
0x111111125434b319222cdbf8c261674adb56f3ae	false	368000000000000000	0x112ce6d14f669d697aaba230e2341a8296c2572c	68	0x0e29e5abbb5fd88e28b2d355774e73bd47de3bcd	0x0000000000000000000000000000000000000000	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	12308000	0x112ce6d14f669d697aaba230e2341a8296c2572c	368000000000000000	2021-04-25T07:10:13.000Z	9641732029868349119951	0x9cf9fb2e6f6b30613ffdc9549600175de0d63fe1af9d6227f6ee703cb41393bb	6617708393222247838936	6822379786827059627770

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

LimitOrderProtocol_OrderFilledRFQ_event

OneInchExchange_Swapped_event

​Tables

​LimitOrderProtocol_OrderFilledRFQ_event

​OneInchExchange_Swapped_event

Tables

LimitOrderProtocol_OrderFilledRFQ_event

OneInchExchange_Swapped_event