cowswap_v1_base

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`	`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
62751	3000000000000000000	true	56240	{“appData”:“0x05fb36aed7ba01f92544e72888fb354cdeab68b6bbb0b9ea5e64edc364093b42”,“quoteId”:“13435155”,“validTo”:“1740509907”,“buyToken”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“receiver”:“0x6b2abb55f51b67e11edbdf7a005e74c1c62df3a8”,“buyAmount”:“7185690620”,“feeAmount”:“0”,“sellAmount”:“3000000000000000000”,“partiallyFillable”:false}	0x322bba21	0xba3cb449bd2b4adddbc894d8697f5170800eadec	26859386	0x6b2abb55f51b67e11edbdf7a005e74c1c62df3a8	0x14589d4a1cadb26c56ae8856867e116eb3f44d70bb995f12a09dcf99602dbf2c	2025-02-25T18:28:39.000Z	0x3d3009d0d6c31fc6cb99e4566e688fa9dd7bb49498772cb6c7e02ce857be2589
68426	55000000000000000	true	56216	{“appData”:“0x05fb36aed7ba01f92544e72888fb354cdeab68b6bbb0b9ea5e64edc364093b42”,“quoteId”:“13367787”,“validTo”:“1740473731”,“buyToken”:“0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf”,“receiver”:“0x123461542954fa4f99378cb4faad14977b1e577e”,“buyAmount”:“147322”,“feeAmount”:“0”,“sellAmount”:“55000000000000000”,“partiallyFillable”:false}	0x322bba21	0xba3cb449bd2b4adddbc894d8697f5170800eadec	26841310	0x123461542954fa4f99378cb4faad14977b1e577e	0xaa743fbddda1aec124630fa822fc71cf1378201b20e31b0dffebe1dedac1b1bc	2025-02-25T08:26:07.000Z	0xdbd56c6a7d4d9f9a657134c8bbd89a3d188ff54076bc4d6b70fdb280c6aa7cab
68426	644000000000000000	true	56216	{“appData”:“0x05fb36aed7ba01f92544e72888fb354cdeab68b6bbb0b9ea5e64edc364093b42”,“quoteId”:“13410720”,“validTo”:“1740496321”,“buyToken”:“0x833589fcd6edb6e08f4c7c32d4f71b54bda02913”,“receiver”:“0x37bc4bcd016acf705d90393d77fda603008d00b0”,“buyAmount”:“1553117522”,“feeAmount”:“0”,“sellAmount”:“644000000000000000”,“partiallyFillable”:false}	0x322bba21	0xba3cb449bd2b4adddbc894d8697f5170800eadec	26852596	0x37bc4bcd016acf705d90393d77fda603008d00b0	0xe11cdbb5f0eebce296811ded3cb2eec091cb93040542ec35ad3828685c4dbbea	2025-02-25T14:42:19.000Z	0x2c0fb4b6bf16eb4f4fe7c0814766862e989f3b4f6104b92d9a99a1f65327e1b7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cowswap_v1_base.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
0xba3cb449bd2b4adddbc894d8697f5170800eadec	0x0000000004c4fd0a690ccea1	false	{“kind”:“0xf3b277728b3fee749481eb3e0b3b48980dbbab78658fc419025cb16eee346775”,“appData”:“0x342f4ad017ad13c3df99cf00ad48ef6e38647c8d6bbf66e1b4266322cbb06637”,“validTo”:“4294967295”,“buyToken”:“0x04c0599ae5a44757c0af6f9ec3b93da8976c150a”,“receiver”:“0x500bea59133e20dc63b7e88913b30348494b84ba”,“buyAmount”:“8584777897495411600”,“feeAmount”:“0”,“sellToken”:“0x4200000000000000000000000000000000000006”,“sellAmount”:“9310000000000000000”,“buyTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“sellTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“partiallyFillable”:false}	0x500bea59133e20dc63b7e88913b30348494b84ba	1394	37827939	{“data”:“0xba3cb449bd2b4adddbc894d8697f5170800eadec”,“scheme”:0}	2025-11-06T16:07:05.000Z	0x0447863f7e921957f8784fe23518cfe41c46003ef96b280f26c942a6c36166f9
0xba3cb449bd2b4adddbc894d8697f5170800eadec	0x0000000004c50190690cd00d	false	{“kind”:“0xf3b277728b3fee749481eb3e0b3b48980dbbab78658fc419025cb16eee346775”,“appData”:“0x342f4ad017ad13c3df99cf00ad48ef6e38647c8d6bbf66e1b4266322cbb06637”,“validTo”:“4294967295”,“buyToken”:“0x04c0599ae5a44757c0af6f9ec3b93da8976c150a”,“receiver”:“0x500bea59133e20dc63b7e88913b30348494b84ba”,“buyAmount”:“5217817037344242771”,“feeAmount”:“0”,“sellToken”:“0x4200000000000000000000000000000000000006”,“sellAmount”:“5660000000000000000”,“buyTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“sellTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“partiallyFillable”:false}	0x500bea59133e20dc63b7e88913b30348494b84ba	407	37828120	{“data”:“0xba3cb449bd2b4adddbc894d8697f5170800eadec”,“scheme”:0}	2025-11-06T16:13:07.000Z	0x4ff5778d4aaa8dbb388caf2d871b5342becdab3658dea833e454ad35013ad77c
0xba3cb449bd2b4adddbc894d8697f5170800eadec	0x0000000004c50684690cd193	false	{“kind”:“0xf3b277728b3fee749481eb3e0b3b48980dbbab78658fc419025cb16eee346775”,“appData”:“0x342f4ad017ad13c3df99cf00ad48ef6e38647c8d6bbf66e1b4266322cbb06637”,“validTo”:“4294967295”,“buyToken”:“0x04c0599ae5a44757c0af6f9ec3b93da8976c150a”,“receiver”:“0x500bea59133e20dc63b7e88913b30348494b84ba”,“buyAmount”:“7374940003050692319”,“feeAmount”:“0”,“sellToken”:“0x4200000000000000000000000000000000000006”,“sellAmount”:“8000000000000000000”,“buyTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“sellTokenBalance”:“0x5a28e9363bb942b639270062aa6bb295f434bcdfc42c97267bf003f272060dc9”,“partiallyFillable”:false}	0x500bea59133e20dc63b7e88913b30348494b84ba	385	37828315	{“data”:“0xba3cb449bd2b4adddbc894d8697f5170800eadec”,“scheme”:0}	2025-11-06T16:19:37.000Z	0x9111ce5d95529f5d0e72bccfd0f25bc2847fe0ae4fec14af384cb17d7387abe0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cowswap_v1_base.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	0x914db7338acae3f3866b79dceffcfbcc554f18ed	890	30602374	2025-05-23T09:54:55.000Z	0x25b2412067338132e7ff6763088c19e3b5c2b691991078bc0c22e86b7a65de1d
0x2c4c28ddbdac9c5e7055b4c863b72ea0149d8afe	false	0xa370940c2024cc029a87a821ee775560ad39dfbe	461	30078552	2025-05-11T06:54:11.000Z	0x9f38ac5fb9baa7bb6f97fe59930f9f41a5e2c822fdf1b0229f22997d6d1d2155
0x2c4c28ddbdac9c5e7055b4c863b72ea0149d8afe	false	0xac73db8296f6be1836288da8a57c0f29379741e2	460	30078552	2025-05-11T06:54:11.000Z	0x9f38ac5fb9baa7bb6f97fe59930f9f41a5e2c822fdf1b0229f22997d6d1d2155

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cowswap_v1_base.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	0x09e5cdfeeac1866103e17e1debf4aad61c1904ef	422	28445831	2025-04-03T11:50:09.000Z	0x5bbac33fb1ef3605293807e1089a60be0f40f27724e278e33991c656419ec3ec
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0x09e5cdfeeac1866103e17e1debf4aad61c1904ef	367	28448639	2025-04-03T13:23:45.000Z	0x7fafb5c0c05e052f84cc41d8f8ad0db234dc7b76b34f228221bba85069961af2
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0x09e5cdfeeac1866103e17e1debf4aad61c1904ef	392	28434268	2025-04-03T05:24:43.000Z	0x8972c7b4c9465c7961969463af8b32e86660fa3a4c8c519de7f3ba95f0dfe14e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.cowswap_v1_base.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_sellToken	in_sellAmount	block_timestamp	transaction_hash
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0xe293dc11d4a4953957e3b06e7766cdb07fdb63e6	155	0x006935f88b4a6de3b43831ca8f342176a8c604b3	0x7d0159054239d900d759fc62e408a29b4d90b3dea045319a66518b288c441bf1e293dc11d4a4953957e3b06e7766cdb07fdb63e6677f3c51	24800366	1047580640568820981685836	0x833589fcd6edb6e08f4c7c32d4f71b54bda02913	100000000	2025-01-09T02:34:39.000Z	0x01b02232435d2b52c58a6b6a11e6c22723f64ba26c38680901c3d3067d10d095
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0x3d1b389f1707db3d4c5344d5669dbda6b5d6ab51	331	0x0388e6fd81150c6ff7fe6d2df956973f5f09a67b	0x864dfbf7a95d0251e65ae925e91f6744b0bca032d7ca0e8f91f916c36f56c0f13d1b389f1707db3d4c5344d5669dbda6b5d6ab51ffffffff	24830842	109616298595480445488372775	0x4200000000000000000000000000000000000006	16000000000000000	2025-01-09T19:30:31.000Z	0xe19664de92214a11728cbef422d23f0a6b82f2de974985ff38abef71de5ed0b0
0x9008d19f58aabd9ed0d60971565aa8510560ab41	false	0xf8bcfcff814d4461392147e15f047849de98e104	315	0x03ec6374bee663c3dedb3de3df99750c6f51727c	0x34e8b3c3728b857778f1be3137b3c881f2bec87989f991c6b44429d39f50a0aef8bcfcff814d4461392147e15f047849de98e10467804ba1	24835079	46394492859975803138675	0x4200000000000000000000000000000000000006	90000000000000000	2025-01-09T21:51:45.000Z	0xadf2109103bae144197531b6185fdc3d1ab9a7883414c476f2f5af0967adf3c2

Example Query

Query with partition filter

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

OptimismMintableERC20_Transfer_event

ERC20 token transfer events for Optimism-bridgeable tokens on Base, tracking sender, recipient, and transfer amounts with transaction context. Used for analyzing cross-chain token flows and wallet activity for bridged assets.

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
0x4c5f6ad6628d205259443ebcf6cc4cdd7d6cbf81	0xc694a91e6b071bf030a18bd3053a7fe09b6dae69	0x155e0971a2392c446be02373a4f4c8dc4266f015	false	57738260630777861929	42	29808501	2025-05-05T00:52:29.000Z	0xaa6fe85b2d6fce226be8242eff0a93d67a10686f437bdf19b074e4c8b02e0e9f
0x4c5f6ad6628d205259443ebcf6cc4cdd7d6cbf81	0xc694a91e6b071bf030a18bd3053a7fe09b6dae69	0x155e0971a2392c446be02373a4f4c8dc4266f015	false	66180988721998353747	181	29810698	2025-05-05T02:05:43.000Z	0x6fe6422c792e52cacf3dae76c1f3b843397329206e378439be0e210aa5afc65d
0x4c5f6ad6628d205259443ebcf6cc4cdd7d6cbf81	0xc694a91e6b071bf030a18bd3053a7fe09b6dae69	0x155e0971a2392c446be02373a4f4c8dc4266f015	false	74451998711320597889	275	29811009	2025-05-05T02:16:05.000Z	0x5f13cd4da6985dd18287a78ebfaf1e100cec1d1a7d54c1ac5f7fc9cbb794abaf

Example Query

Query with partition filter

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

OptimismMintableERC20_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

​OptimismMintableERC20_Transfer_event

Tables

CoWSwapEthFlow_createOrder_function

CoWSwapEthFlow_OrderPlacement_event

GPv2AllowListAuthentication_SolverAdded_event

GPv2Settlement_settle_function

GPv2Settlement_Settlement_event

GPv2Settlement_Trade_event

OptimismMintableERC20_Transfer_event