Skip to main content

Tables

CoWSwapEthFlow_createOrder_function

CoWSwap EthFlow contract order creation function calls containing native cryptocurrency swap parameters and order hash outputs. Used for tracking intent-based DEX orders where users deposit native tokens (ETH, BNB, MATIC) to receive specified token amounts through CoWSwap settlement protocol.
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.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueSTRINGAmount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_orderSTRUCT<buyToken STRING, receiver STRING, sellAmount STRING, buyAmount STRING, appData STRING, feeAmount STRING, validTo STRING, partiallyFillable BOOL, quoteId STRING>Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
out_orderHashSTRINGUnique identifier hash for the order being filled. 66-character hex string including 0x prefix.
gasvaluestatusgas_usedin_ordersignatureto_addressblock_numberfrom_addressout_orderHashtrace_addressblock_timestamptransaction_hash
1250963565000000000000true76720{“appData”:“0x1705a77787c3a98c5860276c82a5030b1c576b9d31dbdf47c59594f0e67cf02e”,“quoteId”:“39522068”,“validTo”:“1752158529”,“buyToken”:“0x057ba66c2109fd4487f0781e0203b71fd77a6341”,“receiver”:“0x11c1bfe4814352cfa3a73626227498b62c3c947e”,“buyAmount”:“2803040962943194545949”,“feeAmount”:“0”,“sellAmount”:“3565000000000000”,“partiallyFillable”:false}0x322bba210xba3cb449bd2b4adddbc894d8697f5170800eadec3562507210x11c1bfe4814352cfa3a73626227498b62c3c947e0x3a6eb1000adc491ccea37cb25451c19274aa7814a706246e94559417eddc8a2e2025-07-10T14:13:21.000Z0x0253d61ffca4c250286693c00098e97896a9d30966d896bfff1972aa5c6f0f8c
1317848970000000000000true81705{“appData”:“0x6993545f3ae767acb0766470c28fe753b072f22d18f02099aa2e1ce06708bcfa”,“quoteId”:“39506209”,“validTo”:“1752150751”,“buyToken”:“0x057ba66c2109fd4487f0781e0203b71fd77a6341”,“receiver”:“0x11c1bfe4814352cfa3a73626227498b62c3c947e”,“buyAmount”:“7091830098587761266806”,“feeAmount”:“0”,“sellAmount”:“8970000000000000”,“partiallyFillable”:false}0x322bba210xba3cb449bd2b4adddbc894d8697f5170800eadec3562193710x11c1bfe4814352cfa3a73626227498b62c3c947e0x6595f8d565d659e5748a9c2efc10a6281949bb5bbe233ae3effb941e973a98f62025-07-10T12:02:53.000Z0x2eb3243e5f719a39d9e8bae6ed74aef078cfec1237e6619ed4a7d10d55d12743
1494711780000000000000true87412{“appData”:“0x8212c3d7fa233b4722e79f8428df5c8e7090b1f4e91ff46536ad2cc5750f8c6f”,“quoteId”:“39523189”,“validTo”:“1752159086”,“buyToken”:“0x057ba66c2109fd4487f0781e0203b71fd77a6341”,“receiver”:“0x11c1bfe4814352cfa3a73626227498b62c3c947e”,“buyAmount”:“1394564919394712415439”,“feeAmount”:“0”,“sellAmount”:“1780000000000000”,“partiallyFillable”:false}0x322bba210xba3cb449bd2b4adddbc894d8697f5170800eadec3562527230x11c1bfe4814352cfa3a73626227498b62c3c947e0x047a257d2b9ec43a60cd44e63ea7b4fe703d5f37f077fba9fc9013bb5207903c2025-07-10T14:21:41.000Z0xd23caec3a9885f0bd20f385681b0994d77842215f47c992dd0848aaaf3cba87d
Query with partition filter
SELECT *
FROM `tt-contracts.cowswap_v1_arbitrum.CoWSwapEthFlow_createOrder_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

CoWSwapEthFlow_OrderPlacement_event

CoW Protocol native ETH order placement events emitted by the EthFlow contract. Records user-initiated swap orders that wrap native chain tokens (ETH, WBNB, WMATIC) into their wrapped equivalents for execution through CoW Protocol’s batch auction settlement system.
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_orderSTRUCT<sellToken STRING, buyToken STRING, receiver STRING, sellAmount STRING, buyAmount STRING, validTo STRING, appData STRING, feeAmount STRING, kind STRING, partiallyFillable BOOL, sellTokenBalance STRING, buyTokenBalance STRING>Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
in_signatureSTRUCT<scheme INT64, data STRING>Cryptographic signature authorizing the order execution. Hex-encoded byte string used to verify the order was signed by the maker’s private key.
in_dataSTRINGEncoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
addressin_dataremovedin_orderin_senderlog_indexblock_numberin_signatureblock_timestamptransaction_hash
0xba3cb449bd2b4adddbc894d8697f5170800eadec0x00000000025b0f14686fd141false{“kind”:“0xf3b277728b3fee749481eb3e0b3b48980dbbab78658fc419025cb16eee346775”,“appData”:“0x1705a77787c3a98c5860276c82a5030b1c576b9d31dbdf47c59594f0e67cf02e”,“validTo”:“4294967295”,“buyToken”:“0x057ba66c2109fd4487f0781e0203b71fd77a6341”,“receiver”:“0x11c1bfe4814352cfa3a73626227498b62c3c947e”,“buyAmount”:“2803040962943194545949”,“feeAmount”:“0”,“sellToken”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“sellAmount”:“3565000000000000”,“buyTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“sellTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“partiallyFillable”:false}0x11c1bfe4814352cfa3a73626227498b62c3c947e4356250721{“data”:“0xba3cb449bd2b4adddbc894d8697f5170800eadec”,“scheme”:0}2025-07-10T14:13:21.000Z0x0253d61ffca4c250286693c00098e97896a9d30966d896bfff1972aa5c6f0f8c
0xba3cb449bd2b4adddbc894d8697f5170800eadec0x00000000025ad121686fb2dffalse{“kind”:“0xf3b277728b3fee749481eb3e0b3b48980dbbab78658fc419025cb16eee346775”,“appData”:“0x6993545f3ae767acb0766470c28fe753b072f22d18f02099aa2e1ce06708bcfa”,“validTo”:“4294967295”,“buyToken”:“0x057ba66c2109fd4487f0781e0203b71fd77a6341”,“receiver”:“0x11c1bfe4814352cfa3a73626227498b62c3c947e”,“buyAmount”:“7091830098587761266806”,“feeAmount”:“0”,“sellToken”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“sellAmount”:“8970000000000000”,“buyTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“sellTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“partiallyFillable”:false}0x11c1bfe4814352cfa3a73626227498b62c3c947e15356219371{“data”:“0xba3cb449bd2b4adddbc894d8697f5170800eadec”,“scheme”:0}2025-07-10T12:02:53.000Z0x2eb3243e5f719a39d9e8bae6ed74aef078cfec1237e6619ed4a7d10d55d12743
0xba3cb449bd2b4adddbc894d8697f5170800eadec0x00000000025b1375686fd36efalse{“kind”:“0xf3b277728b3fee749481eb3e0b3b48980dbbab78658fc419025cb16eee346775”,“appData”:“0x8212c3d7fa233b4722e79f8428df5c8e7090b1f4e91ff46536ad2cc5750f8c6f”,“validTo”:“4294967295”,“buyToken”:“0x057ba66c2109fd4487f0781e0203b71fd77a6341”,“receiver”:“0x11c1bfe4814352cfa3a73626227498b62c3c947e”,“buyAmount”:“1394564919394712415439”,“feeAmount”:“0”,“sellToken”:“0x82af49447d8a07e3bd95bd0d56f35241523fbab1”,“sellAmount”:“1780000000000000”,“buyTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“sellTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“partiallyFillable”:false}0x11c1bfe4814352cfa3a73626227498b62c3c947e0356252723{“data”:“0xba3cb449bd2b4adddbc894d8697f5170800eadec”,“scheme”:0}2025-07-10T14:21:41.000Z0xd23caec3a9885f0bd20f385681b0994d77842215f47c992dd0848aaaf3cba87d
Query with partition filter
SELECT *
FROM `tt-contracts.cowswap_v1_arbitrum.CoWSwapEthFlow_OrderPlacement_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

GPv2AllowListAuthentication_SolverAdded_event

Event logs recording solver addresses being added to the CoW Protocol GPv2 (Gnosis Protocol v2) authentication allow list. Tracks authorization of solver accounts permitted to execute settlements on the protocol.
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_solverSTRINGAddress of the solver that executed the settlement or was added to the allow list. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_solverlog_indexblock_numberblock_timestamptransaction_hash
0x2c4c28ddbdac9c5e7055b4c863b72ea0149d8afefalse0xadf619eb586e7b3586ba5f45a6086d64b8f1dcaa73341722292025-05-07T11:17:44.000Z0xc61a388d4bd441930bc51ab061add4e49b54e86fb4a4dac0d6522b419391f9f3
0x2c4c28ddbdac9c5e7055b4c863b72ea0149d8afefalse0xcf6fda0b383ef980aacbc56d9d0be14931ffe57663341722292025-05-07T11:17:44.000Z0xc61a388d4bd441930bc51ab061add4e49b54e86fb4a4dac0d6522b419391f9f3
0x2c4c28ddbdac9c5e7055b4c863b72ea0149d8afefalse0x7199cf10cf16b85fb59170d5c83d114ac11d3afa12987956042025-01-24T13:31:46.000Z0x66b3627bf9c947faa3573d9e7897128f2da957c6c31c8ea397936477e3bfc1b7
Query with partition filter
SELECT *
FROM `tt-contracts.cowswap_v1_arbitrum.GPv2AllowListAuthentication_SolverAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

GPv2Settlement_settle_function

CoW Protocol GPv2Settlement contract settle function calls containing batched trade executions with tokens, clearing prices, and interaction sequences. Records complete settlement transactions for intent-based order matching and execution.
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.
trace_addressSTRINGHierarchical 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.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueSTRINGAmount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_tokensARRAY<STRING>Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
in_clearingPricesARRAY<STRING>Array of token prices used to settle the batch of trades. String-encoded integer values representing exchange rates between tokens in the settlement.
in_tradesARRAY<STRUCT<sellTokenIndex STRING, buyTokenIndex STRING, receiver STRING, sellAmount STRING, buyAmount STRING, validTo STRING, appData STRING, feeAmount STRING, flags STRING, executedAmount STRING, signature STRING>>Array of trade orders included in the settlement batch. Each struct contains sell and buy token indices referencing in_tokens array, receiver address, amounts, order validity timestamp, application data hash, fee amount, execution flags, actual executed amount, and cryptographic signature for order verification.
in_interactionsARRAY<STRING>Array of encoded contract interactions executed during trade settlement. Each element is a concatenated string containing target address, value, and calldata for contract calls made as part of the settlement process.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.cowswap_v1_arbitrum.GPv2Settlement_settle_function`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

GPv2Settlement_Settlement_event

Settlement execution events from the CoW Protocol GPv2Settlement contract recording solver addresses that successfully executed trade batches.
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_solverSTRINGAddress of the solver that executed the settlement or was added to the allow list. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_solverlog_indexblock_numberblock_timestamptransaction_hash
0x9008d19f58aabd9ed0d60971565aa8510560ab41false0x001088c88be46346ed99856dcfa3a00da7aaf212112653058522024-10-19T02:59:05.000Z0x9da885e78a7dd3dc3f99527c6aadf7507f8bffcb267a53f253dc9586735235ce
0x9008d19f58aabd9ed0d60971565aa8510560ab41false0x001088c88be46346ed99856dcfa3a00da7aaf212122655019452024-10-19T16:39:13.000Z0x18d7c223411e61cf492e305b049303a08b104cd36c1ee8a85fb3e617d4a0e6b9
0x9008d19f58aabd9ed0d60971565aa8510560ab41false0x001088c88be46346ed99856dcfa3a00da7aaf212122655424102024-10-19T19:29:10.000Z0x52f0f560506b8ebc456e4826fcfa34b60a40b523ba5257c5ae9b507c98075e3b
Query with partition filter
SELECT *
FROM `tt-contracts.cowswap_v1_arbitrum.GPv2Settlement_Settlement_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

GPv2Settlement_Trade_event

Trade execution events from CoW Protocol’s GPv2Settlement contract containing order details, token addresses, and executed amounts. Records completed swaps with owner address, unique order identifier, buy/sell token pairs, traded quantities, and associated fees for order settlement tracking.
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_ownerSTRINGAddress that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
in_sellTokenSTRINGContract address of the token being sold in the trade. Hex-encoded, 0x-prefixed, 42-character string.
in_buyTokenSTRINGContract address of the token being purchased in the trade. Hex-encoded, 0x-prefixed, 42-character string.
in_sellAmountSTRINGAmount of tokens sold in the trade. Numeric string representation of token quantity in smallest denomination.
in_buyAmountSTRINGAmount of tokens received in the trade. Numeric string representation of token quantity in smallest denomination.
in_feeAmountSTRINGFee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
in_orderUidSTRINGUnique identifier for the order being executed in the trade. Hex-encoded string containing order hash, owner address, and validity timestamp.
addressremovedin_ownerlog_indexin_buyTokenin_orderUidblock_numberin_buyAmountin_feeAmountin_sellTokenin_sellAmountblock_timestamptransaction_hash
0x9008d19f58aabd9ed0d60971565aa8510560ab41false0x73774ca9b668d3b3607810bd24d99a779fe5c2c620xba5ddd1f9d7f570dc94a51479a000e3bce9671960xa1ffc3bed87df7b46b7e82dab3ca067d45eb90892ead9ea692ce0062a3dc707173774ca9b668d3b3607810bd24d99a779fe5c2c6667ed0252266303468726137170984473600x82af49447d8a07e3bd95bd0d56f35241523fbab124500000000000002024-06-28T14:31:40.000Z0x286b20524017e99f08101d5e0e012a8c51d7f0ca7b06f348fb0d3e68aaebe866
0x9008d19f58aabd9ed0d60971565aa8510560ab41false0x1692bdc4f66514148b193677adcf1829ba48898b80x62d5a59e0d67c0381aad53b201b4a1b8dcd2c8330x26378a8f0a384de2fd12b4fb52a493a9b8268eb0d0fea2caf0dd13308c89ed841692bdc4f66514148b193677adcf1829ba48898b667e934a22656806924369408522092965416700x912ce59144191c1204e64559fe8253a0e49e6548868913036124785926512024-06-28T10:12:01.000Z0xff757d4c6b8dddaf12f8672f5e8d35ed610b7e31877667d9b5299751a75440a4
0x9008d19f58aabd9ed0d60971565aa8510560ab41false0xe53464166d9dab175e9c290209d5eab9cf98eec540xaaa6c1e32c55a7bfa8066a6fae9b42650f2624180x7d90663cbd45cdbaf546e7bde785482894a895d85f872980122781a68b4d159fe53464166d9dab175e9c290209d5eab9cf98eec5669fc6b32266629224334883113915227059088500xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb910000000002024-06-28T16:47:31.000Z0x8909598bd5deae577ad73529d645d60be0baa209fa6ee0803a4906c064703a48
Query with partition filter
SELECT *
FROM `tt-contracts.cowswap_v1_arbitrum.GPv2Settlement_Trade_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StandardArbERC20_Transfer_event

No description available.
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_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_dataSTRINGEncoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.cowswap_v1_arbitrum.StandardArbERC20_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100