cowswap_v1_ethereum

Tables

CowProtocolToken_Transfer_event

Transfer events for the COW governance token (0xdef1ca1fb7fbcdc777520aa7f396b4e015f497ab) on Ethereum’s CoW Protocol. Tracks token movements between addresses with sender, recipient, and transfer amounts for analyzing token holder behavior and liquidity flows.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

in_to	address	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xba12222222228d8ba445958a75a0704d566bf2c8	0xdef1ca1fb7fbcdc777520aa7f396b4e015f497ab	0xf2f400c138f9fb900576263af0bc7fcde2b1b8a8	false	6289482039703670414069	48	15125649	2022-07-12T04:14:33.000Z	0xe8f4498f5db3d258bc97106eb482a1c70c13284170cd6eeb619581dc43071623
0xf2f400c138f9fb900576263af0bc7fcde2b1b8a8	0xdef1ca1fb7fbcdc777520aa7f396b4e015f497ab	0x1d8414b6a61e8a06b2902e3f3ebcca82e0a4810d	false	6289482039703670414069	44	15125649	2022-07-12T04:14:33.000Z	0xe8f4498f5db3d258bc97106eb482a1c70c13284170cd6eeb619581dc43071623
0xfb3c7eb936caa12b5a884d612393969a557d4307	0xdef1ca1fb7fbcdc777520aa7f396b4e015f497ab	0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	8518351185346112157	143	15125724	2022-07-12T04:29:55.000Z	0xf12cf01e745f82fccf9283a86bf672a28fa51b4e8361852f0c2deb25cabd9d04

Example Query

Query with partition filter

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

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.

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.
`trace_address`	`STRING`	Hierarchical 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.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_order`	`STRUCT<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_orderHash`	`STRING`	Unique identifier hash for the order being filled. 66-character hex string including 0x prefix.

Sample Data

gas	value	status	gas_used	in_order	signature	to_address	block_number	from_address	out_orderHash	block_timestamp	transaction_hash
180000	5347033301239623000	false	23783		0x322bba21	0x40a50cf069e992aa4536211b23f286ef88752187	18593941	0xa1a42572a597ff12ad1484a2bcdd784b3b9486e2		2023-11-17T20:20:35.000Z	0x1470d2c0df706be140d3ed77b10cc39ed5ba2a74acc862b048c83eea0ce4c912
67646	4000000000000000000	true	56372	{“appData”:“0x082dcda563084cf00f4a26e0df3560fa63559ef3cca15c8bb0ae122d0d689c49”,“quoteId”:“296965179”,“validTo”:“1700219671”,“buyToken”:“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“receiver”:“0x7817c4100e8e51c147c7b7eac1259abbdf47e7f0”,“buyAmount”:“7672393868”,“feeAmount”:“5962705645579740”,“sellAmount”:“3994037294354420260”,“partiallyFillable”:false}	0x322bba21	0x40a50cf069e992aa4536211b23f286ef88752187	18591083	0x7817c4100e8e51c147c7b7eac1259abbdf47e7f0	0x6e901cc1c133d48abab7a7ae25976a8ccf74babccb71777129622e18c88e46f5	2023-11-17T10:44:47.000Z	0x0ae9648c40bef77125a1b263cfb9f9ef0bda14d6e1c15fbd4605d26ad880e040
62088	170000000000000000	true	56444	{“appData”:“0x15f7794a143d0e5d3217190e3baeac63e6f76c816b10b9a6b89fcb915164d281”,“quoteId”:“297401468”,“validTo”:“1700259195”,“buyToken”:“0xc08e31eb3ab0c460e43bf746be25f78088d749d8”,“receiver”:“0x2845d9e1b6b312dc1d3380870a14eac474196f48”,“buyAmount”:“16015968349807525909265276”,“feeAmount”:“3691001128005495”,“sellAmount”:“166308998871994505”,“partiallyFillable”:false}	0x322bba21	0x40a50cf069e992aa4536211b23f286ef88752187	18594353	0x2845d9e1b6b312dc1d3380870a14eac474196f48	0x23d838846111b74c0ac80a62c0c039f2090814db5f6bca97c5aa74baa8547920	2023-11-17T21:43:35.000Z	0x126a2dc736a6243593687f93caadb42c37c5fa886cbc9cc568ff77de2731ed4f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cowswap_v1_ethereum.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.

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_order`	`STRUCT<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_signature`	`STRUCT<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_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

address	in_data	removed	in_order	in_sender	log_index	block_number	in_signature	block_timestamp	transaction_hash
0x40a50cf069e992aa4536211b23f286ef88752187	0x000000002ea5335e67f7a73a	false	{“kind”:“0xf3b277728b3fee749481eb3e0b3b48980dbbab78658fc419025cb16eee346775”,“appData”:“0x093487e9fc30d0ceecbf649e8aa3bec173c626fe854de12575628dc6b607ca09”,“validTo”:“4294967295”,“buyToken”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“receiver”:“0x24cfbfb2a9b85f2fe5dbf2318b5a12140becc8d5”,“buyAmount”:“1560583127”,“feeAmount”:“0”,“sellToken”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“sellAmount”:“1000411216979089048”,“buyTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“sellTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“partiallyFillable”:false}	0x24cfbfb2a9b85f2fe5dbf2318b5a12140becc8d5	306	22238119	{“data”:“0x40a50cf069e992aa4536211b23f286ef88752187”,“scheme”:0}	2025-04-10T11:06:23.000Z	0x3f07dbff7569cba385676d051131434440ecd5d6883e3cc44c246a39ca7a5673
0xba3cb449bd2b4adddbc894d8697f5170800eadec	0x000000002ea9f81867f81a29	false	{“kind”:“0xf3b277728b3fee749481eb3e0b3b48980dbbab78658fc419025cb16eee346775”,“appData”:“0x61988e9dbee77697be70e19fae6e44245ca12d7ddbec28179f50e2b440778c52”,“validTo”:“4294967295”,“buyToken”:“0xdac17f958d2ee523a2206206994597c13d831ec7”,“receiver”:“0xff408e9f479ea458aa794e7481c4c4d7c0686757”,“buyAmount”:“3426255268”,“feeAmount”:“0”,“sellToken”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“sellAmount”:“2300000000000000000”,“buyTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“sellTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“partiallyFillable”:false}	0xff408e9f479ea458aa794e7481c4c4d7c0686757	352	22240437	{“data”:“0xba3cb449bd2b4adddbc894d8697f5170800eadec”,“scheme”:0}	2025-04-10T18:51:35.000Z	0x9ec25532307277bf2f4f4102be04707ff0fd5edef9936a7d70e63d163f09fad6
0xba3cb449bd2b4adddbc894d8697f5170800eadec	0x000000002ea5c93e67f7bbb5	false	{“kind”:“0xf3b277728b3fee749481eb3e0b3b48980dbbab78658fc419025cb16eee346775”,“appData”:“0x1dcd77f7418a91c1689bac0ff28e1c7ecb412bcb36ac2f57a2ff3df3af1ad67f”,“validTo”:“4294967295”,“buyToken”:“0x8bbf486a9f2b535c4ef09c665a807859cfe92d83”,“receiver”:“0x8856dff15e34fd8fda28d3ea14cb2df02bf45b99”,“buyAmount”:“6338385867304635”,“feeAmount”:“0”,“sellToken”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“sellAmount”:“10000000000000000”,“buyTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“sellTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“partiallyFillable”:false}	0x8856dff15e34fd8fda28d3ea14cb2df02bf45b99	159	22238429	{“data”:“0xba3cb449bd2b4adddbc894d8697f5170800eadec”,“scheme”:0}	2025-04-10T12:08:23.000Z	0xff2e0826e8dbf38d0ca51fe7f8201355cbbcf97417b0c1b0833cf2e69cf105d1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cowswap_v1_ethereum.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.

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_solver`	`STRING`	Address of the solver that executed the settlement or was added to the allow list. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_solver	log_index	block_number	block_timestamp	transaction_hash
0x2c4c28ddbdac9c5e7055b4c863b72ea0149d8afe	false	0x8f70a86c1309d8b1f5befc58948e7386fd495875	289	19840083	2024-05-10T13:58:23.000Z	0x3f512c41cce652df53f3db213217930b9d5123a02cb278d4f025b5fc905b4ad1
0x2c4c28ddbdac9c5e7055b4c863b72ea0149d8afe	false	0xa432cea087311d7cd07925d70f799ee94e7893a4	290	19840083	2024-05-10T13:58:23.000Z	0x3f512c41cce652df53f3db213217930b9d5123a02cb278d4f025b5fc905b4ad1
0x2c4c28ddbdac9c5e7055b4c863b72ea0149d8afe	false	0x8419ff1bcbce6f0233cf3460b28c32b6951fc457	173	17194688	2023-05-05T13:19:35.000Z	0xd29d94b793a25393978cfd69e7ad439dfead2d7c3fa7b72c9ae34f1b954e7588

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cowswap_v1_ethereum.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.

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.
`trace_address`	`STRING`	Hierarchical 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.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_tokens`	`ARRAY<STRING>`	Array of token contract addresses involved in the operation. Hex-encoded, 0x-prefixed, 42-character strings.
`in_clearingPrices`	`ARRAY<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_trades`	`ARRAY<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_interactions`	`ARRAY<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.

Sample Data

gas	status	gas_used	in_tokens	in_trades	signature	to_address	block_number	from_address	block_timestamp	in_interactions	transaction_hash	in_clearingPrices
1234725	true	720194	[“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“0xdac17f958d2ee523a2206206994597c13d831ec7”]	[{“flags”:“0”,“appData”:“0x8d089016c4260cd70a06e0f93d195342c99a06ac521a229c41788d3ac7203ad4”,“validTo”:“1686034425”,“receiver”:“0x590d79b3d1e913819d0ea2f997b22cd22ba2ddc6”,“buyAmount”:“54772320463236237889”,“feeAmount”:“20199264”,“signature”:“0x8ec8728809bfa580885f9b2131b099a6e867bab5f7351cb15fb33bc83f078bf01ef67225a8b57b69dc09be86301f9d489a4c2d03c752dfdbf8a86d2bffde03041b”,“sellAmount”:“99979800736”,“buyTokenIndex”:“0”,“executedAmount”:“99979800736”,“sellTokenIndex”:“1”}]	0x13d79a0b	0x9008d19f58aabd9ed0d60971565aa8510560ab41	17419618	0x0c60276beadc5ba35007661a89e0d5e7476523f8	2023-06-06T06:24:47.000Z	["",“0x4932D5ff00A91B725Ed89514FB5999BBe8a6A0b6,[object Object],0xb87b27380000000000000000000000006c77ac51c3b5dc5fa09fdee21acd83ff3a7c4436000000000000000000000000000000000000000000000000000000174742b0a0000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000000000000000000000000002fb652859dedbea480000000000000000000000009008d19f58aabd9ed0d60971565aa8510560ab4100000000000000000000000000000000000000000000000000000000647ed19900000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000540000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000200000000000000000000000000dac17f958d2ee523a2206206994597c13d831ec70000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000de0b6b3a7640000000000000000000000000000c9f93163c99695c6526b799ebca2207fdf7d61ad0000000000000000000000000000000000000000000000000000000000000080000200000024000000000000c9f93163c99695c6526b799ebca2207fdf7d61ad00000000000000000000000000000000000000000000000000000000000000848dae7333000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb480000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000de0b6b3a7640000000000000000000000000000d17b3c9784510e33cd5b87b490e79253bcd81e2e0000000000000000000000000000000000000000000000000000000000000080000200000064000000000000d17b3c9784510e33cd5b87b490e79253bcd81e2e00000000000000000000000000000000000000000000000000000000000000e458d30ac9000000000000000000000000a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc20000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000006c77ac51c3b5dc5fa09fdee21acd83ff3a7c443600000000000000000000000000000000000000000000000000000000ffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,""]	0x17ad9ec181e233e52509433281bb435d8fa3f3ca7884131ec19b2eb5f9a3e440	[“99979800736”,“55041925724736576470”]
238575	true	170529	[“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“0xdf801468a808a32656d2ed2d2d80b72a129739f4”]	[{“flags”:“96”,“appData”:“0x4348644eebbe1bafbc6edfc22577520f945a564f3cfd3bd9d5178a13ffe8e5f7”,“validTo”:“1686061619”,“receiver”:“0x7e5013302dc94c1efa6632aaf6f542251e146a81”,“buyAmount”:“779186736136”,“feeAmount”:“4514268217256262”,“signature”:“0x7e5013302dc94c1efa6632aaf6f542251e146a81”,“sellAmount”:“5679799596431447824”,“buyTokenIndex”:“1”,“executedAmount”:“5679799596431447824”,“sellTokenIndex”:“0”}]	0x13d79a0b	0x9008d19f58aabd9ed0d60971565aa8510560ab41	17421857	0x0c60276beadc5ba35007661a89e0d5e7476523f8	2023-06-06T13:59:59.000Z	["",“0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2,[object Object],0xa9059cbb000000000000000000000000f6c3595cbd6858b47e93c83312cef89750cea3a40000000000000000000000000000000000000000000000004ed2b3a3dcb41710,0xF6C3595cBd6858B47E93c83312CEF89750cEA3A4,[object Object],0x022c0d9f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b655be31e20000000000000000000000009008d19f58aabd9ed0d60971565aa8510560ab4100000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000000”,""]	0x63e38d43686b1a80f0fa94bfb0773e3b34dd533f24ed06da2ad42f7400966eb7	[“783122575842”,“5679799596431447824”]
772392	true	553181	[“0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0”,“0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48”,“0xdac17f958d2ee523a2206206994597c13d831ec7”,“0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee”]	[{“flags”:“96”,“appData”:“0x2d0f5a23abdd204234746dbab1a86041425d2ea69bbc8a3bec1aa58dba81fcfa”,“validTo”:“1686066057”,“receiver”:“0x3dfc49e5112005179da613bde5973229082dac35”,“buyAmount”:“112905492544892148”,“feeAmount”:“1381085539299124992”,“signature”:“0x3dfc49e5112005179da613bde5973229082dac35”,“sellAmount”:“33798011745637775171”,“buyTokenIndex”:“3”,“executedAmount”:“33798011745637775171”,“sellTokenIndex”:“0”},{“flags”:“96”,“appData”:“0xb144a4e057efc1bc497e61502d38db84e5321a0aa8a7d0ae08360c9c92fdfb9b”,“validTo”:“1686069549”,“receiver”:“0xb91ef9a2c37c20803efd33d98f09296d2468403b”,“buyAmount”:“1987380407433”,“feeAmount”:“43989820”,“signature”:“0xb91ef9a2c37c20803efd33d98f09296d2468403b”,“sellAmount”:“2006956010180”,“buyTokenIndex”:“1”,“executedAmount”:“2006956010180”,“sellTokenIndex”:“2”}]	0x13d79a0b	0x9008d19f58aabd9ed0d60971565aa8510560ab41	17421772	0x0c60276beadc5ba35007661a89e0d5e7476523f8	2023-06-06T13:42:23.000Z	["",“0xdAC17F958D2ee523a2206206994597C13D831ec7,[object Object],0x095ea7b3000000000000000000000000c9f93163c99695c6526b799ebca2207fdf7d61ad000000000000000000000000000000000000000000000000000001d347e66ac4,0xC9f93163c99695c6526b799EbcA2207Fdf7D61aD,[object Object],0x8dae7333000000000000000000000000000000000000000000000000000001d347e66ac4000000000000000000000000000000000000000000000000000001d3640daad600000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000000,0x2FbB05d206c2E8A50B2959EEE7d8C5f0F64e40e9,[object Object],0x4379435e00000000000000000000000039c9e3128b8736e02a30b2b9b7e50ff522b935c500000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000104128acb080000000000000000000000009008d19f58aabd9ed0d60971565aa8510560ab410000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000001d50aa89cf538374300000000000000000000000000000000000000000000000000000001000276a400000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000001719b12c44a85bd0000000000000000000000009008d19f58aabd9ed0d60971565aa8510560ab4100000000000000000000000000000000000000000000000000000000,0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2,[object Object],0x2e1a7d4d000000000000000000000000000000000000000000000000019951885d4dd6ed”,""]	0xef49bc042ead4864dda38ebaba5d5de0fa8d524ac7bab8bdcf675ef3c52d14dd	[“3411118085400946”,“550311533338470578193664576”,“550441048405706587642519725”,“1000660494710538195”]

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cowswap_v1_ethereum.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.

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_solver`	`STRING`	Address of the solver that executed the settlement or was added to the allow list. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_solver	log_index	block_number	block_timestamp	transaction_hash
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0x158261d17d2983b2cbaecc1ae71a34617ae4cb16	19	13674893	2021-11-24T03:42:34.000Z	0xcaee423495f2a397fc313a6abb4d9d2f3e9c1b92897a4046fdef83835750af34
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0x158261d17d2983b2cbaecc1ae71a34617ae4cb16	22	13674822	2021-11-24T03:29:39.000Z	0x6a630ad1fdfbeff0436fb34771bd277c7ea057d3a178095c81c2059c9a54c693
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0x158261d17d2983b2cbaecc1ae71a34617ae4cb16	37	13679535	2021-11-24T21:21:27.000Z	0xad89975cd83411cf666b847e984919bcce2bccbdf319effcb4fde2e7b0dfdb5b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cowswap_v1_ethereum.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.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_sellToken`	`STRING`	Contract address of the token being sold in the trade. Hex-encoded, 0x-prefixed, 42-character string.
`in_buyToken`	`STRING`	Contract address of the token being purchased in the trade. Hex-encoded, 0x-prefixed, 42-character string.
`in_sellAmount`	`STRING`	Amount of tokens sold in the trade. Numeric string representation of token quantity in smallest denomination.
`in_buyAmount`	`STRING`	Amount of tokens received in the trade. Numeric string representation of token quantity in smallest denomination.
`in_feeAmount`	`STRING`	Fee amount charged for the flash loan or transaction. Numeric string representation of fee quantity in smallest denomination.
`in_orderUid`	`STRING`	Unique identifier for the order being executed in the trade. Hex-encoded string containing order hash, owner address, and validity timestamp.

Sample Data

address	removed	in_owner	log_index	in_buyToken	in_orderUid	block_number	in_buyAmount	in_feeAmount	in_sellToken	in_sellAmount	block_timestamp	transaction_hash
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0xd63ff70c84c1292085234126eac87fad714af17b	131	0x025c9f1146d4d94f8f369b9d98104300a3c8ca23	0xdd0ac68a834eda194ea109659cac43318988abca183fb43ca95392c6ce13322dd63ff70c84c1292085234126eac87fad714af17b61747acf	13476052	152315997081917780050475	209643967394518663168	0xc86817249634ac209bc73fca1712bbd75e37407d	8000000000000000000000	2021-10-23T20:45:09.000Z	0xa9340c73424dd9b9932e277691f9f072e54e407e3696578cf8157660c57dc55a
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0xae653682dee958914a82c9628de794dcbbee3d04	29	0x090185f2135308bad17527004364ebcc2d37e5f6	0x3c3cc290d6e15d172b411c3315819050f97178410a38581f8e2e7fe053c54aefae653682dee958914a82c9628de794dcbbee3d0461745664	13475405	1747480327478524737102809	1350093173969732352	0x77777feddddffc19ff86db637967013e6c6a116c	550588872332815028833	2021-10-23T18:24:51.000Z	0x2bbd221372869fa4a204a616cf4642cf96dab81b58cdbee37a8d928a94c16c8c
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0xae653682dee958914a82c9628de794dcbbee3d04	431	0x090185f2135308bad17527004364ebcc2d37e5f6	0xe72c60c6c709d43168aa5cdd5f5f39236d69015834c86ac9d6aa098a331d676eae653682dee958914a82c9628de794dcbbee3d0461745484	13475329	1290466325504085076249022	1121952164598868480	0x77777feddddffc19ff86db637967013e6c6a116c	400000000000000000000	2021-10-23T18:09:54.000Z	0x1cb45e846e8b799b8641fd8c35b2b1d7be5f3c45df372263f903358da12259e6

Example Query

Query with partition filter

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

MevBlockerFeeTill_bill_function

MEV Blocker fee billing function calls that update prices and settle amounts due for multiple account IDs on Ethereum. Records settlement transactions with updated price parameters and arrays of addresses with corresponding fee amounts.

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.
`trace_address`	`STRING`	Hierarchical 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.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_ids`	`ARRAY<STRING>`	Array of token identifiers involved in the batch operation. Numeric strings representing token IDs, which may be sequential integers for fungible positions or large integers for ERC-1155 token types.
`in_due`	`ARRAY<STRING>`	Array of amounts owed per billing identifier, denominated in wei-scale integer strings. Each value corresponds positionally to an entry in the in_ids array representing outstanding fees for that account.
`in_newPrice`	`STRING`	Updated price denominated in wei-equivalent units for billing calculations. Typically ranges from hundreds of trillions to low quadrillions per sample data.

Sample Data

gas	in_due	in_ids	status	gas_used	signature	to_address	in_newPrice	block_number	from_address	block_timestamp	transaction_hash
131450	[“16597164781659678720”,“10537925544891639808”,“3070730302899491840”,“524585924726357120”]	[“0x816e4a1589e363720c15c54dfd2efd16f6377070”,“0xcf7c69c7acf62179d29fa3f47de62226b58ad992”,“0xb02bdb9ca42122f44ee72b7a55acaad7938c6b8d”,“0xfd39bc23d356a762cf80f60b7bc8d2a4b9bcfe67”]	true	130416	0xed267ac9	0x08cd77feb3fb28cc1606a91e0ea2f5e3eaba1a9a	645871775661675	20476291	0x756ab804133217774275295b29ca6cf35ec33214	2024-08-07T11:07:11.000Z	0x45d8f7aa147bfe158353c235e44e43af6775f86decebf7185de7fd064ad67c47
153695	[“13625939209827203072”,“8515450337954349056”,“4694313374139556864”,“554494440610980864”,“274828162141506272”]	[“0x816e4a1589e363720c15c54dfd2efd16f6377070”,“0xcf7c69c7acf62179d29fa3f47de62226b58ad992”,“0xb02bdb9ca42122f44ee72b7a55acaad7938c6b8d”,“0xfd39bc23d356a762cf80f60b7bc8d2a4b9bcfe67”,“0xb100d6f4fc91c8c666f615e3efe4c4c90584a610”]	true	152486	0xed267ac9	0x08cd77feb3fb28cc1606a91e0ea2f5e3eaba1a9a	609334550121957	20125985	0x756ab804133217774275295b29ca6cf35ec33214	2024-06-19T13:08:23.000Z	0x932d43f09cf3996e05d30ffd3c6ac313529eec5e13adbffa3610d1f6ecbef260
128741	[“8610788233821490740”,“677850363720897948”,“12073141562239018494”,“218829844310457951”]	[“0xcf7c69c7acf62179d29fa3f47de62226b58ad992”,“0xb02bdb9ca42122f44ee72b7a55acaad7938c6b8d”,“0x816e4a1589e363720c15c54dfd2efd16f6377070”,“0xfd39bc23d356a762cf80f60b7bc8d2a4b9bcfe67”]	true	127652	0xed267ac9	0x08cd77feb3fb28cc1606a91e0ea2f5e3eaba1a9a	474685128656091	20777051	0x756ab804133217774275295b29ca6cf35ec33214	2024-09-18T11:01:59.000Z	0xdcf2d0a55546b84730e40781ae8570b269f8439e44db65f73f977ef3a3941d19

Example Query

Query with partition filter

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

VouchRegister_Vouch_event

Vouch registration events from CoW Swap protocol on Ethereum tracking solver endorsements with bonding pool and COW token reward target addresses. Used for analyzing solver network participation and vouching relationships in the CoW Protocol’s solver competition mechanism.

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_solver`	`STRING`	Address of the solver that executed the settlement or was added to the allow list. Hex-encoded, 0x-prefixed, 42-character string.
`in_bondingPool`	`STRING`	Ethereum address of the bonding pool contract associated with the vouched solver. Used to track security deposits and slashing mechanisms for CoW Swap solver performance.
`in_cowRewardTarget`	`STRING`	Address designated to receive COW token rewards for the vouched solver. Typically differs from the solver address, representing the beneficiary account for protocol incentives.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_sender	in_solver	log_index	block_number	in_bondingPool	block_timestamp	transaction_hash	in_cowRewardTarget
0xb422f2520b0b7fd86f7da61b32cc631a59ed7e8f	false	0x423cec87f19f0778f549846e0801ee267a917935	0x5131590ca2e9d3edc182581352b289dcae83430c	293	21029279	0x5d4020b9261f01b6f8a45db929704b0ad6f5e9e6	2024-10-23T15:47:11.000Z	0x8646b5e73cab9d9c8516ac7063edf58d4d094dc28e7ba0503e2c35a0e614d93c	0x0587d465fcd4a8212b66b96d99b41a8c16d4bd9b
0xb422f2520b0b7fd86f7da61b32cc631a59ed7e8f	false	0x423cec87f19f0778f549846e0801ee267a917935	0xd2e90778ee3f480d305ff535be88f5af9f2ac85c	199	21637224	0x5d4020b9261f01b6f8a45db929704b0ad6f5e9e6	2025-01-16T13:04:23.000Z	0x6cefed5332fc031147c818359b39d2d2b6d07b61b877b330c2d72feae88ec7dc	0xd7bec97d0d286c2eb0b21f8a74de87a3a2fb37b7
0xb422f2520b0b7fd86f7da61b32cc631a59ed7e8f	false	0x423cec87f19f0778f549846e0801ee267a917935	0xdce5b9574c9a18b4f1713c80bfc53623c007e7e1	200	21637224	0x5d4020b9261f01b6f8a45db929704b0ad6f5e9e6	2025-01-16T13:04:23.000Z	0x6cefed5332fc031147c818359b39d2d2b6d07b61b877b330c2d72feae88ec7dc	0xd7bec97d0d286c2eb0b21f8a74de87a3a2fb37b7

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

CowProtocolToken_Transfer_event

CoWSwapEthFlow_createOrder_function

CoWSwapEthFlow_OrderPlacement_event

GPv2AllowListAuthentication_SolverAdded_event

GPv2Settlement_settle_function

GPv2Settlement_Settlement_event

GPv2Settlement_Trade_event

MevBlockerFeeTill_bill_function

VouchRegister_Vouch_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​CowProtocolToken_Transfer_event

​CoWSwapEthFlow_createOrder_function

​CoWSwapEthFlow_OrderPlacement_event

​GPv2AllowListAuthentication_SolverAdded_event

​GPv2Settlement_settle_function

​GPv2Settlement_Settlement_event

​GPv2Settlement_Trade_event

​MevBlockerFeeTill_bill_function

​VouchRegister_Vouch_event

Tables

CowProtocolToken_Transfer_event

CoWSwapEthFlow_createOrder_function

CoWSwapEthFlow_OrderPlacement_event

GPv2AllowListAuthentication_SolverAdded_event

GPv2Settlement_settle_function

GPv2Settlement_Settlement_event

GPv2Settlement_Trade_event

MevBlockerFeeTill_bill_function

VouchRegister_Vouch_event