Skip to main content

​
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.
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_orderHashSTRINGUnique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
in_makingAmountSTRINGAmount of tokens provided by the maker in the RFQ order execution. Numeric string representing the token quantity in its smallest denomination.
addressremovedlog_indexblock_numberin_orderHashblock_timestampin_makingAmounttransaction_hash
0x119c71d3bbac22029622cbaec24854d3d32d2828false509138482820x9514e34614d3ff2faf73c80b51d90ac5e655e46fdab4ad99c12f7bfcfa3473922021-12-21T11:32:16.000Z10000000xa9a3835417067a0fbc1a83eba09569c683720097bb8ef21fb3f6d239b3c76b12
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.
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 for the swap to execute. Serves as slippage protection, preventing execution if market conditions worsen below this threshold.
in_guaranteedAmountSTRINGMinimum 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_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
0x111111125434b319222cdbf8c261674adb56f3aefalse2350000000000000000x066aea7f5a27e0002bfa88b4df4c6717d7c8ac291580x0000000000004946c0e9f43f4dee607b0ef1fa1c0x00000000000000000000000000000000000000000xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee123080030x066aea7f5a27e0002bfa88b4df4c6717d7c8ac292350000000000000002021-04-25T07:10:39.000Z1740xf3a298bd0f58d0438a11b1a8ec385f097d6a647350bd819ff48df2dfbd0d786f173174
0x111111125434b319222cdbf8c261674adb56f3aefalse500000000000x35da3d2f891ba64e6fc625a1ff2b1074c41f5559420x04fa0d235c4abf4bcf4787af4cf447de572ef8280x00000000000000000000000000000000000000000xdac17f958d2ee523a2206206994597c13d831ec7123101470x35da3d2f891ba64e6fc625a1ff2b1074c41f5559500000000002021-04-25T15:02:23.000Z19673303791082344778250xbc055de67dfa9ae9bd30c395c37714f35f74c68abfdf4531efd46c92652d7b2f19470817124869450836092028210117173901128760
0x111111125434b319222cdbf8c261674adb56f3aefalse3680000000000000000x112ce6d14f669d697aaba230e2341a8296c2572c680x0e29e5abbb5fd88e28b2d355774e73bd47de3bcd0x00000000000000000000000000000000000000000xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee123080000x112ce6d14f669d697aaba230e2341a8296c2572c3680000000000000002021-04-25T07:10:13.000Z96417320298683491199510x9cf9fb2e6f6b30613ffdc9549600175de0d63fe1af9d6227f6ee703cb41393bb66177083932222478389366822379786827059627770
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