cowswap_v1_gnosis

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.

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`	`NUMERIC`	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	1002084019066144962	false	23807		0x322bba21	0x40a50cf069e992aa4536211b23f286ef88752187	31218387	0x12d23991bd8a25333036cf41f44af6894f2ca61c		2023-12-01T05:50:10.000Z	0xf843ea2a82d8e15d69350e05655402d20a7755d1bc287f8e9fad06da1bf60c06
67603	189254172868545325	true	56336	{“appData”:“0x15f7794a143d0e5d3217190e3baeac63e6f76c816b10b9a6b89fcb915164d281”,“quoteId”:“54387122”,“validTo”:“1701462037”,“buyToken”:“0xddafbb505ad214d7b80b1f830fccc89b60fb7a83”,“receiver”:“0x4efa25f6f418ee9534039ed9448093f39f02f825”,“buyAmount”:“183357”,“feeAmount”:“2192846960009728”,“sellAmount”:“187061325908535597”,“partiallyFillable”:false}	0x322bba21	0x40a50cf069e992aa4536211b23f286ef88752187	31227960	0x4efa25f6f418ee9534039ed9448093f39f02f825	0xb7111770087440139e72f5d1321702f7b987881406e63c7ff6902944298aaa2e	2023-12-01T19:51:00.000Z	0xa7ff471c0cb3ba2db70e1a6f82f837326dd86dd0af5a06c38c78b64b2d983ff9
67617	300000000000000000	true	56348	{“appData”:“0x15f7794a143d0e5d3217190e3baeac63e6f76c816b10b9a6b89fcb915164d281”,“quoteId”:“54384350”,“validTo”:“1701444503”,“buyToken”:“0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1”,“receiver”:“0xc0f39623c2f961815219c42f2dff3786aa0ab54e”,“buyAmount”:“139546908897213”,“feeAmount”:“2480804656640000”,“sellAmount”:“297519195343360000”,“partiallyFillable”:false}	0x322bba21	0x40a50cf069e992aa4536211b23f286ef88752187	31224636	0xc0f39623c2f961815219c42f2dff3786aa0ab54e	0x72827de9fd4a41193378d83b9ef16033d86e6c8ecd68c0bbf80f57a5b485712e	2023-12-01T14:58:15.000Z	0x5cf5d027cc5e5453c9c4d0ffac2c8986c8f5f31ae525d0b1219f830c6879eb96

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cowswap_v1_gnosis.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	block_number	in_signature	block_timestamp	transaction_hash
0x40a50cf069e992aa4536211b23f286ef88752187	0x0000000001887c3d63dad31b	false	{“kind”:“0xf3b277728b3fee749481eb3e0b3b48980dbbab78658fc419025cb16eee346775”,“appData”:“0x3f1aabaf92e2f1cdd097c8712ef50a412c7e37e28ac7d08c63b9eba3d64f2b8d”,“validTo”:“4294967295”,“buyToken”:“0x4ecaba5870353805a9f068101a40e0f32ed605c6”,“receiver”:“0xe5928764b26b4dbd4f79a0d9c9441a3ba1c5fe10”,“buyAmount”:“129165030”,“feeAmount”:“517982329537827”,“sellToken”:“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”,“sellAmount”:“131866168982898753576”,“buyTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“sellTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“partiallyFillable”:false}	0xe5928764b26b4dbd4f79a0d9c9441a3ba1c5fe10	26262572	{“data”:“0x40a50cf069e992aa4536211b23f286ef88752187”,“scheme”:0}	2023-02-01T20:31:25.000Z	0xe589be1eedd2bb24051d9f62f221638d7fc1705a2d6d38a3c14f86c5da770be6
0x40a50cf069e992aa4536211b23f286ef88752187	0x000000000186a00a63da1653	false	{“kind”:“0xf3b277728b3fee749481eb3e0b3b48980dbbab78658fc419025cb16eee346775”,“appData”:“0x3f1aabaf92e2f1cdd097c8712ef50a412c7e37e28ac7d08c63b9eba3d64f2b8d”,“validTo”:“4294967295”,“buyToken”:“0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1”,“receiver”:“0x4e1ae89a46dd4c053a67365bcdc982e3b0eb847a”,“buyAmount”:“67445110954153411”,“feeAmount”:“742251385970520”,“sellToken”:“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”,“sellAmount”:“108750666536437954489”,“buyTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“sellTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“partiallyFillable”:false}	0x4e1ae89a46dd4c053a67365bcdc982e3b0eb847a	26253227	{“data”:“0x40a50cf069e992aa4536211b23f286ef88752187”,“scheme”:0}	2023-02-01T07:06:00.000Z	0x9c190ee4ba32b1997c8f6d0f87a8e4a241f67878b53aa5e7277d10f22a79905a
0x40a50cf069e992aa4536211b23f286ef88752187	0x000000000187fdbb63daa124	false	{“kind”:“0xf3b277728b3fee749481eb3e0b3b48980dbbab78658fc419025cb16eee346775”,“appData”:“0x3f1aabaf92e2f1cdd097c8712ef50a412c7e37e28ac7d08c63b9eba3d64f2b8d”,“validTo”:“4294967295”,“buyToken”:“0xd057604a14982fe8d88c5fc25aac3267ea142a08”,“receiver”:“0xde6f17794861e1e13104285cd2dabfc478bfb679”,“buyAmount”:“2037070384533839371157”,“feeAmount”:“626796991178832”,“sellToken”:“0xe91d153e0b41518a2ce8dd3d7944fa863463a97d”,“sellAmount”:“120499373203008821168”,“buyTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“sellTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“partiallyFillable”:false}	0xde6f17794861e1e13104285cd2dabfc478bfb679	26260097	{“data”:“0x40a50cf069e992aa4536211b23f286ef88752187”,“scheme”:0}	2023-02-01T16:58:25.000Z	0x6820b321d9ed4cd44f42e28c8911adf97d93df1199fa405ac3fd983a881bd339

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cowswap_v1_gnosis.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	0xad426eef53dd1c130edebecf7cb72fc88d9f4be9	15	17985876	2021-09-08T09:20:50.000Z	0xbf32b2f1514703f4f4c9f55e4f6ed07d3cf8abd56f9e1361cc2dac8c6a58af66
0x2c4c28ddbdac9c5e7055b4c863b72ea0149d8afe	false	0xe71d3324e17e99b56c294067370d45111bc968d6	2	27788516	2023-05-05T09:50:55.000Z	0x225a1541f93d1283015c8955f00a5cf5aa6737129a2f1f81c59969ef03c39a81
0x2c4c28ddbdac9c5e7055b4c863b72ea0149d8afe	false	0xa7c4c18106e92cea479627d02fab583d987f17d9	3	27788516	2023-05-05T09:50:55.000Z	0x225a1541f93d1283015c8955f00a5cf5aa6737129a2f1f81c59969ef03c39a81

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cowswap_v1_gnosis.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	0x26029b63c7dbd0c4c04d7226c3e7de5eab3db3d8	11	21889897	2022-04-29T19:15:25.000Z	0x07107a7183a47efdc70191afa513a92ce6fbcc6b03a3833f26e4fa2853f9e134
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0x26029b63c7dbd0c4c04d7226c3e7de5eab3db3d8	11	21886883	2022-04-29T14:49:20.000Z	0x68f3eb156510a31c2e487d94d8474ba290b4fcd1c43fddfb3bfce46e4fefe956
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0x26029b63c7dbd0c4c04d7226c3e7de5eab3db3d8	12	21881085	2022-04-29T06:09:40.000Z	0x4c6d0a7a3ab4fd0ddc51456c9b9e9703bb06716b9fc84dc76cb676aab733d684

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cowswap_v1_gnosis.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	0x36dde157980fea9946ee78231ea5c73409e31ab6	1	0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1	0xc200c194a19f24cf1a41a6a8e9634804b380c0616cd0c3d903893824f98255e636dde157980fea9946ee78231ea5c73409e31ab6638761c7	25231614	4255817845974069	6248668508804677	0x177127622c4a00f3d409b75571e12cb3c8973d3c	74374477021800252527	2022-11-30T13:30:25.000Z	0x5ae42f2ac63172c302df16fd7484be9b3a5e6abbdb461f658d01aaa32bf28371
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0xcc0333bcb5e0de0c14fc42a1bdc85efcd36612cc	2	0x9c58bacc331c9aa871afd802db6379a98e80cedb	0xa3038e37707d8d18bad30abb0476df4796b1ac1f3034f495f467b6925bf3ffa3cc0333bcb5e0de0c14fc42a1bdc85efcd36612cc63870a90	25227789	7895466726706121758	22071457673490928	0x177127622c4a00f3d409b75571e12cb3c8973d3c	9542056775512732763272	2022-11-30T07:18:30.000Z	0xb29ed1121b4561124a6d6611e84a360ac73535e8a184cc7bd0b9b9c696c30d55
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0xb4f642451dc4567e5fe7c22051e11a99dca2fdb6	2	0xddafbb505ad214d7b80b1f830fccc89b60fb7a83	0x5980295b6b5226759c8fb064df517b847af5779daebcf55068452781aabd9e1db4f642451dc4567e5fe7c22051e11a99dca2fdb663876134	25231578	56293975	8530513197812103	0x177127622c4a00f3d409b75571e12cb3c8973d3c	780629243867318208799	2022-11-30T13:26:55.000Z	0x93c37a400834d70687a3261bf00c3993bf79d2d2f99220d9f5cc7de55f7a1de6

Example Query

Query with partition filter

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

PermittableToken_Transfer_event

ERC-20 token transfer events from COW Protocol’s permittable token contract on Gnosis Chain. Tracks token movements with sender, recipient, and transfer amounts for analyzing trading flows through 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_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.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

in_to	address	in_data	in_from	removed	in_value	log_index	block_number	block_timestamp	transaction_hash
0xf6a78083ca3e2a662d6dd1703c939c8ace2e268d	0x177127622c4a00f3d409b75571e12cb3c8973d3c	0x7a6a59588b8106045303e1923227a2cefbec2b66	0x7a6a59588b8106045303e1923227a2cefbec2b66	false	39988422830990000000000	1	26719762	2023-03-01T06:54:35.000Z	0x1c8d4e1e953ce8a3bbd28f019a091291f789db5d9635b82f5da18dda4be10880
0xf6a78083ca3e2a662d6dd1703c939c8ace2e268d	0x177127622c4a00f3d409b75571e12cb3c8973d3c	0x77fb4fa1aba92576942ad34bc47834059b84e693	0x77fb4fa1aba92576942ad34bc47834059b84e693	false	494228938432118975715	2012	32709438	2024-03-01T11:21:10.000Z	0xc3a1a5367ca31d5ffb67e53dbfc4d934d147f468743874c7b21b368a273e2f23
0xf6a78083ca3e2a662d6dd1703c939c8ace2e268d	0x177127622c4a00f3d409b75571e12cb3c8973d3c	0x95c231ff84476aa15ce7e57aee153ba2446f7e82	0x95c231ff84476aa15ce7e57aee153ba2446f7e82	false	2342619012718342607281	1	35691777	2024-08-27T08:29:10.000Z	0x078cac262059b01cc5d4fadf5fde90e1ff1a5a543447ebb492c05a9753f92954

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

CoWSwapEthFlow_createOrder_function

CoWSwapEthFlow_OrderPlacement_event

GPv2AllowListAuthentication_SolverAdded_event

GPv2Settlement_settle_function

GPv2Settlement_Settlement_event

GPv2Settlement_Trade_event

PermittableToken_Transfer_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​CoWSwapEthFlow_createOrder_function

​CoWSwapEthFlow_OrderPlacement_event

​GPv2AllowListAuthentication_SolverAdded_event

​GPv2Settlement_settle_function

​GPv2Settlement_Settlement_event

​GPv2Settlement_Trade_event

​PermittableToken_Transfer_event

Tables

CoWSwapEthFlow_createOrder_function

CoWSwapEthFlow_OrderPlacement_event

GPv2AllowListAuthentication_SolverAdded_event

GPv2Settlement_settle_function

GPv2Settlement_Settlement_event

GPv2Settlement_Trade_event

PermittableToken_Transfer_event