opensea_v1_ethereum

Tables

SeaportV1_matchAdvancedOrders_function

OpenSea Seaport v1 protocol function calls for matching multiple advanced orders on Ethereum, enabling complex NFT trades with partial fills and bundled executions. Used for analyzing batch marketplace transactions and order fulfillment patterns.

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_advancedOrders`	ARRAY<STRUCT<parameters STRUCT<offerer STRING, zone STRING, offer ARRAY<STRUCT<itemType INT64, token STRING, identifierOrCriteria STRING, startAmount STRING, endAmount STRING>>, consideration ARRAY<STRUCT<itemType INT64, token STRING, identifierOrCriteria STRING, startAmount STRING, endAmount STRING, recipient STRING>>, orderType INT64, startTime STRING, endTime STRING, zoneHash STRING, salt STRING, conduitKey STRING, totalOriginalConsiderationItems STRING>, numerator STRING, denominator STRING, signature STRING, extraData STRING>>	Array of advanced order parameters including offer items, consideration items, partial fill fractions (numerator/denominator), signatures, zone addresses, and validity timestamps. Each order represents either an NFT listing or a bid with payment terms, fees, and fulfillment conditions.
`in_criteriaResolvers`	`ARRAY<STRUCT<orderIndex STRING, side INT64, index STRING, identifier STRING, criteriaProof ARRAY<STRING>>>`	Array of criteria resolvers used to fulfill partially-fillable criteria-based orders (ERC721/ERC1155 with trait-based matching). Empty when orders specify exact token IDs rather than criteria.
`in_fulfillments`	`ARRAY<STRUCT<offerComponents ARRAY<STRUCT<orderIndex STRING, itemIndex STRING>>, considerationComponents ARRAY<STRUCT<orderIndex STRING, itemIndex STRING>>>>`	Array of fulfillment groups matching offer and consideration items between multiple orders in a batch. Each fulfillment specifies which order and item index combinations should be paired to complete the trade.
`out_executions`	`ARRAY<STRUCT<item STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING, recipient STRING>, offerer STRING, conduitKey STRING>>`	Array of executed transfers resulting from the matched orders. Each execution record contains the token address, amount, item type (0=native, 3=ERC721/1155), recipient address, token identifier, offerer, and conduit key used for the transfer.

Sample Data

gas	value	status	gas_used	signature	to_address	block_number	from_address	out_executions	block_timestamp	in_fulfillments	transaction_hash	in_advancedOrders	in_criteriaResolvers
260695	1000000000000	true	252631	0x55944a42	0x00000000006c3852cbef3e08e8df289169ede581	15815009	0x046f1d6a402b4d0285538b3e998bd86497c3bb26	[{“item”:{“token”:“0xa604060890923ff400e8c6f5290461a83aedacec”,“amount”:“1”,“itemType”:3,“recipient”:“0x046f1d6a402b4d0285538b3e998bd86497c3bb26”,“identifier”:“102973510929536869296670012186838544649326170488801262871711520341674407494048”},“offerer”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”},{“item”:{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“875000000000”,“itemType”:0,“recipient”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“identifier”:“0”},“offerer”:“0x046f1d6a402b4d0285538b3e998bd86497c3bb26”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”},{“item”:{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“25000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”},“offerer”:“0x046f1d6a402b4d0285538b3e998bd86497c3bb26”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”},{“item”:{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“100000000000”,“itemType”:0,“recipient”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“identifier”:“0”},“offerer”:“0x046f1d6a402b4d0285538b3e998bd86497c3bb26”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”}]	2022-10-24T02:33:47.000Z	[{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“0”}],“considerationComponents”:[{“itemIndex”:“3”,“orderIndex”:“0”}]},{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“1”}],“considerationComponents”:[{“itemIndex”:“0”,“orderIndex”:“0”}]},{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“1”}],“considerationComponents”:[{“itemIndex”:“1”,“orderIndex”:“0”}]},{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“1”}],“considerationComponents”:[{“itemIndex”:“2”,“orderIndex”:“0”}]}]	0xb96c2725abf0d4ab4ec9612033eed119633ab36ee609b33ed4a99581c11c4ffe	[{“extraData”:“0x”,“numerator”:“1”,“signature”:“0xd0062b6bc0f067c1b1b97ea9fed66fa3593c4d7fabb2d99ddd2b92e0a2f0614746ea9c0f3ab1a1565146807d2a241be35d30c39e1947190c2d2c8ad80d1e54811b”,“parameters”:{“salt”:“24446860302761739304752683030156737591518664810215442929811506834546793379956”,“zone”:“0x004c00500000ad104d7dbd00e3ae0a5c00560c00”,“offer”:[{“token”:“0xa604060890923ff400e8c6f5290461a83aedacec”,“itemType”:3,“endAmount”:“20”,“startAmount”:“20”,“identifierOrCriteria”:“102973510929536869296670012186838544649326170488801262871711520341674407494048”}],“endTime”:“1666746750”,“offerer”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“zoneHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“orderType”:3,“startTime”:“1666141950”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”,“consideration”:[{“token”:“0x0000000000000000000000000000000000000000”,“itemType”:0,“endAmount”:“17500000000000”,“recipient”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“startAmount”:“17500000000000”,“identifierOrCriteria”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“itemType”:0,“endAmount”:“500000000000”,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“startAmount”:“500000000000”,“identifierOrCriteria”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“itemType”:0,“endAmount”:“2000000000000”,“recipient”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“startAmount”:“2000000000000”,“identifierOrCriteria”:“0”},{“token”:“0xa604060890923ff400e8c6f5290461a83aedacec”,“itemType”:3,“endAmount”:“20”,“recipient”:“0x046f1d6a402b4d0285538b3e998bd86497c3bb26”,“startAmount”:“20”,“identifierOrCriteria”:“102973510929536869296670012186838544649326170488801262871711520341674407494048”}],“totalOriginalConsiderationItems”:“4”},“denominator”:“20”},{“extraData”:“0x”,“numerator”:“1”,“signature”:“0x”,“parameters”:{“salt”:“24446860302761739304752683030156737591518664810215442929817021462963488062489”,“zone”:“0x004c00500000ad104d7dbd00e3ae0a5c00560c00”,“offer”:[{“token”:“0x0000000000000000000000000000000000000000”,“itemType”:0,“endAmount”:“20000000000000”,“startAmount”:“20000000000000”,“identifierOrCriteria”:“0”}],“endTime”:“1666746750”,“offerer”:“0x046f1d6a402b4d0285538b3e998bd86497c3bb26”,“zoneHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“orderType”:3,“startTime”:“1666141950”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”,“consideration”:[],“totalOriginalConsiderationItems”:“0”},“denominator”:“20”}]	[]
260671	1000000000000	true	252607	0x55944a42	0x00000000006c3852cbef3e08e8df289169ede581	15814986	0x24d94bf5568584fb0141dd861fb81593f6bb341f	[{“item”:{“token”:“0xa604060890923ff400e8c6f5290461a83aedacec”,“amount”:“1”,“itemType”:3,“recipient”:“0x24d94bf5568584fb0141dd861fb81593f6bb341f”,“identifier”:“102973510929536869296670012186838544649326170488801262871711520341674407494048”},“offerer”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”},{“item”:{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“875000000000”,“itemType”:0,“recipient”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“identifier”:“0”},“offerer”:“0x24d94bf5568584fb0141dd861fb81593f6bb341f”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”},{“item”:{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“25000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”},“offerer”:“0x24d94bf5568584fb0141dd861fb81593f6bb341f”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”},{“item”:{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“100000000000”,“itemType”:0,“recipient”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“identifier”:“0”},“offerer”:“0x24d94bf5568584fb0141dd861fb81593f6bb341f”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”}]	2022-10-24T02:29:11.000Z	[{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“0”}],“considerationComponents”:[{“itemIndex”:“3”,“orderIndex”:“0”}]},{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“1”}],“considerationComponents”:[{“itemIndex”:“0”,“orderIndex”:“0”}]},{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“1”}],“considerationComponents”:[{“itemIndex”:“1”,“orderIndex”:“0”}]},{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“1”}],“considerationComponents”:[{“itemIndex”:“2”,“orderIndex”:“0”}]}]	0x29ddc614e012c168201764b836425d817cf7e51e6db2eaa1004cce7de63591ab	[{“extraData”:“0x”,“numerator”:“1”,“signature”:“0x36444fe200ba8a2aa8ae9e29aab1563542bbc76f3f2055816bc81c77b32186f93ed411239a164a18a4222d511c62c9b412c0dbb5dd0200c32f088a592a13b8e61b”,“parameters”:{“salt”:“24446860302761739304752683030156737591518664810215442929804918363977628915203”,“zone”:“0x004c00500000ad104d7dbd00e3ae0a5c00560c00”,“offer”:[{“token”:“0xa604060890923ff400e8c6f5290461a83aedacec”,“itemType”:3,“endAmount”:“20”,“startAmount”:“20”,“identifierOrCriteria”:“102973510929536869296670012186838544649326170488801262871711520341674407494048”}],“endTime”:“1666746958”,“offerer”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“zoneHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“orderType”:3,“startTime”:“1666142158”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”,“consideration”:[{“token”:“0x0000000000000000000000000000000000000000”,“itemType”:0,“endAmount”:“17500000000000”,“recipient”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“startAmount”:“17500000000000”,“identifierOrCriteria”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“itemType”:0,“endAmount”:“500000000000”,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“startAmount”:“500000000000”,“identifierOrCriteria”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“itemType”:0,“endAmount”:“2000000000000”,“recipient”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“startAmount”:“2000000000000”,“identifierOrCriteria”:“0”},{“token”:“0xa604060890923ff400e8c6f5290461a83aedacec”,“itemType”:3,“endAmount”:“20”,“recipient”:“0x24d94bf5568584fb0141dd861fb81593f6bb341f”,“startAmount”:“20”,“identifierOrCriteria”:“102973510929536869296670012186838544649326170488801262871711520341674407494048”}],“totalOriginalConsiderationItems”:“4”},“denominator”:“20”},{“extraData”:“0x”,“numerator”:“1”,“signature”:“0x”,“parameters”:{“salt”:“24446860302761739304752683030156737591518664810215442929803068655458634264043”,“zone”:“0x004c00500000ad104d7dbd00e3ae0a5c00560c00”,“offer”:[{“token”:“0x0000000000000000000000000000000000000000”,“itemType”:0,“endAmount”:“20000000000000”,“startAmount”:“20000000000000”,“identifierOrCriteria”:“0”}],“endTime”:“1666746958”,“offerer”:“0x24d94bf5568584fb0141dd861fb81593f6bb341f”,“zoneHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“orderType”:3,“startTime”:“1666142158”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”,“consideration”:[],“totalOriginalConsiderationItems”:“0”},“denominator”:“20”}]	[]
260647	1000000000000	true	252583	0x55944a42	0x00000000006c3852cbef3e08e8df289169ede581	15820280	0x048914a24912004ecaa6a99b7a4fb99a9d3931a0	[{“item”:{“token”:“0xa604060890923ff400e8c6f5290461a83aedacec”,“amount”:“1”,“itemType”:3,“recipient”:“0x048914a24912004ecaa6a99b7a4fb99a9d3931a0”,“identifier”:“102973510929536869296670012186838544649326170488801262871711520341674407494048”},“offerer”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”},{“item”:{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“875000000000”,“itemType”:0,“recipient”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“identifier”:“0”},“offerer”:“0x048914a24912004ecaa6a99b7a4fb99a9d3931a0”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”},{“item”:{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“25000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”},“offerer”:“0x048914a24912004ecaa6a99b7a4fb99a9d3931a0”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”},{“item”:{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“100000000000”,“itemType”:0,“recipient”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“identifier”:“0”},“offerer”:“0x048914a24912004ecaa6a99b7a4fb99a9d3931a0”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”}]	2022-10-24T20:18:47.000Z	[{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“0”}],“considerationComponents”:[{“itemIndex”:“3”,“orderIndex”:“0”}]},{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“1”}],“considerationComponents”:[{“itemIndex”:“0”,“orderIndex”:“0”}]},{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“1”}],“considerationComponents”:[{“itemIndex”:“1”,“orderIndex”:“0”}]},{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“1”}],“considerationComponents”:[{“itemIndex”:“2”,“orderIndex”:“0”}]}]	0x00069fbf9a9028c63e8ca78e682f567fd4fa17faabe137d36545947d74e777c8	[{“extraData”:“0x”,“numerator”:“1”,“signature”:“0xc85c2a410630d703d370fb1928ff889dc7a47a2221e19797ca02115bf1f2a681255909438a1d986e46c1f031e70cb9b142e6e988446b82f1faf3e90b14bfd2ed1c”,“parameters”:{“salt”:“24446860302761739304752683030156737591518664810215442929818088225212706348764”,“zone”:“0x004c00500000ad104d7dbd00e3ae0a5c00560c00”,“offer”:[{“token”:“0xa604060890923ff400e8c6f5290461a83aedacec”,“itemType”:3,“endAmount”:“6”,“startAmount”:“6”,“identifierOrCriteria”:“102973510929536869296670012186838544649326170488801262871711520341674407494048”}],“endTime”:“1666746532”,“offerer”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“zoneHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“orderType”:3,“startTime”:“1666141732”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”,“consideration”:[{“token”:“0x0000000000000000000000000000000000000000”,“itemType”:0,“endAmount”:“5250000000000”,“recipient”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“startAmount”:“5250000000000”,“identifierOrCriteria”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“itemType”:0,“endAmount”:“150000000000”,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“startAmount”:“150000000000”,“identifierOrCriteria”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“itemType”:0,“endAmount”:“600000000000”,“recipient”:“0xe3a8f118fa278750e80e86ab8b85421c2722e692”,“startAmount”:“600000000000”,“identifierOrCriteria”:“0”},{“token”:“0xa604060890923ff400e8c6f5290461a83aedacec”,“itemType”:3,“endAmount”:“6”,“recipient”:“0x048914a24912004ecaa6a99b7a4fb99a9d3931a0”,“startAmount”:“6”,“identifierOrCriteria”:“102973510929536869296670012186838544649326170488801262871711520341674407494048”}],“totalOriginalConsiderationItems”:“4”},“denominator”:“6”},{“extraData”:“0x”,“numerator”:“1”,“signature”:“0x”,“parameters”:{“salt”:“24446860302761739304752683030156737591518664810215442929816877082423359362285”,“zone”:“0x004c00500000ad104d7dbd00e3ae0a5c00560c00”,“offer”:[{“token”:“0x0000000000000000000000000000000000000000”,“itemType”:0,“endAmount”:“6000000000000”,“startAmount”:“6000000000000”,“identifierOrCriteria”:“0”}],“endTime”:“1666746532”,“offerer”:“0x048914a24912004ecaa6a99b7a4fb99a9d3931a0”,“zoneHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“orderType”:3,“startTime”:“1666141732”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”,“consideration”:[],“totalOriginalConsiderationItems”:“0”},“denominator”:“6”}]	[]

Example Query

Query with partition filter

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

SeaportV1_matchOrders_function

OpenSea Seaport V1 matchOrders function call logs on Ethereum, capturing bulk order matching transactions with input order parameters, fulfillment components, and execution results. Used for analyzing batch NFT and token trades processed through the Seaport protocol’s advanced matching 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.
`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_orders`	`ARRAY<STRUCT<parameters STRUCT<offerer STRING, zone STRING, offer ARRAY<STRUCT<itemType INT64, token STRING, identifierOrCriteria STRING, startAmount STRING, endAmount STRING>>, consideration ARRAY<STRUCT<itemType INT64, token STRING, identifierOrCriteria STRING, startAmount STRING, endAmount STRING, recipient STRING>>, orderType INT64, startTime STRING, endTime STRING, zoneHash STRING, salt STRING, conduitKey STRING, totalOriginalConsiderationItems STRING>, signature STRING>>`	Array of order or liquidation instruction structures specifying the tokens and amounts involved in the transaction.
`in_fulfillments`	`ARRAY<STRUCT<offerComponents ARRAY<STRUCT<orderIndex STRING, itemIndex STRING>>, considerationComponents ARRAY<STRUCT<orderIndex STRING, itemIndex STRING>>>>`	Array of fulfillment components mapping which offer items satisfy which consideration items in the matched orders. Each fulfillment specifies order and item indices to execute atomic swaps between multiple orders.
`out_executions`	`ARRAY<STRUCT<item STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING, recipient STRING>, offerer STRING, conduitKey STRING>>`	Array of executed transfers resulting from the matched orders, containing token address, amount, recipient, and offerer details. Each execution record represents a completed asset transfer (NFT or token) that occurred as part of the order settlement.

Sample Data

gas	status	gas_used	in_orders	signature	to_address	block_number	from_address	out_executions	block_timestamp	in_fulfillments	transaction_hash
172057	true	167599	[{“signature”:“0xaad50b7eac1aec4019ff7444c40efa8bbde580035268d2884f1efc84201cd73c26bd0156c0a403c02ce1748a8b635fa06c8147e5353355bbe16bf564baffa0561b”,“parameters”:{“salt”:“2922644332729917822949034822353609366130320496636566121466278155072265”,“zone”:“0x004c00500000ad104d7dbd00e3ae0a5c00560c00”,“offer”:[{“token”:“0x282a7d13152b3f51a3e31d46a2ca563f8554d85d”,“itemType”:2,“endAmount”:“1”,“startAmount”:“1”,“identifierOrCriteria”:“7327”}],“endTime”:“1988064000”,“offerer”:“0xd1ace0992f7f4c9a88646c3973a8a75df2296b44”,“zoneHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“orderType”:2,“startTime”:“1654697296”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”,“consideration”:[{“token”:“0x282a7d13152b3f51a3e31d46a2ca563f8554d85d”,“itemType”:2,“endAmount”:“1”,“recipient”:“0xb0b5cd643f2a0c4d8f1a35a55f541fed7dbb3976”,“startAmount”:“1”,“identifierOrCriteria”:“7327”}],“totalOriginalConsiderationItems”:“1”}},{“signature”:“0x”,“parameters”:{“salt”:“7964085693362451630892969285290024593362543345332987060410628386230422”,“zone”:“0x004c00500000ad104d7dbd00e3ae0a5c00560c00”,“offer”:[],“endTime”:“1988064000”,“offerer”:“0xea8eac204838ea4da2aac95543a9773cb715d332”,“zoneHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“orderType”:2,“startTime”:“1654697296”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”,“consideration”:[],“totalOriginalConsiderationItems”:“0”}}]	0xa8174404	0x00000000006c3852cbef3e08e8df289169ede581	15955213	0xea8eac204838ea4da2aac95543a9773cb715d332	[{“item”:{“token”:“0x282a7d13152b3f51a3e31d46a2ca563f8554d85d”,“amount”:“1”,“itemType”:2,“recipient”:“0xb0b5cd643f2a0c4d8f1a35a55f541fed7dbb3976”,“identifier”:“7327”},“offerer”:“0xd1ace0992f7f4c9a88646c3973a8a75df2296b44”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”}]	2022-11-12T16:45:23.000Z	[{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“0”}],“considerationComponents”:[{“itemIndex”:“0”,“orderIndex”:“0”}]}]	0xa0354873b847ddaf192d437eda38bf10b2963212f2b3e39e2feeee6d177625fe
174678	true	165420	[{“signature”:“0xac806628752df45582c3995266bf8159523ef839e3783a66638f52a0831d7a6e1a6e66d99a7a2c78614e96a1516139b2ed3eba3f2e54fea495e5d258a93cc3b81b”,“parameters”:{“salt”:“4233811526897754221505723664938030141548646036989875386839448250244948”,“zone”:“0x004c00500000ad104d7dbd00e3ae0a5c00560c00”,“offer”:[{“token”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“itemType”:1,“endAmount”:“1000000000000000000”,“startAmount”:“1000000000000000000”,“identifierOrCriteria”:“0”}],“endTime”:“1988064000”,“offerer”:“0x9beb92d3d1f14d667973971150cd455e02303985”,“zoneHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“orderType”:2,“startTime”:“1654697296”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”,“consideration”:[{“token”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“itemType”:1,“endAmount”:“1000000000000000000”,“recipient”:“0xc0fdf4fa92f88b82ccbebfc80fbe4eb7e5a8e0ca”,“startAmount”:“1000000000000000000”,“identifierOrCriteria”:“0”}],“totalOriginalConsiderationItems”:“1”}},{“signature”:“0x”,“parameters”:{“salt”:“1888639395804374990543843331174582462176882559909090272515460019150855”,“zone”:“0x004c00500000ad104d7dbd00e3ae0a5c00560c00”,“offer”:[],“endTime”:“1988064000”,“offerer”:“0x4574043b6423953723356237042bf6df2304f297”,“zoneHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“orderType”:2,“startTime”:“1654697296”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”,“consideration”:[],“totalOriginalConsiderationItems”:“0”}}]	0xa8174404	0x00000000006c3852cbef3e08e8df289169ede581	15954245	0x4574043b6423953723356237042bf6df2304f297	[{“item”:{“token”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“amount”:“1000000000000000000”,“itemType”:1,“recipient”:“0xc0fdf4fa92f88b82ccbebfc80fbe4eb7e5a8e0ca”,“identifier”:“0”},“offerer”:“0x9beb92d3d1f14d667973971150cd455e02303985”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”}]	2022-11-12T13:30:59.000Z	[{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“0”}],“considerationComponents”:[{“itemIndex”:“0”,“orderIndex”:“0”}]}]	0x6513ac9b76316300255f09e7bc689ec27c03e4d7b870cca111822501eab45338
174690	true	165432	[{“signature”:“0x8da40c1ff8a3af377e6075847ad6196738f216b157d6ef0bbcc3e14d4075bab00d3d6656d7d3d2198a8190e2c87513b53a618ae85da506d36359ce9ed8300ab51c”,“parameters”:{“salt”:“2181137331161277573493759043491278171890702481697797298118198225108670”,“zone”:“0x004c00500000ad104d7dbd00e3ae0a5c00560c00”,“offer”:[{“token”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“itemType”:1,“endAmount”:“502000000000000000”,“startAmount”:“502000000000000000”,“identifierOrCriteria”:“0”}],“endTime”:“1988064000”,“offerer”:“0xffee7f61536eaf3331f6b5e94c45170ab393e8da”,“zoneHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“orderType”:2,“startTime”:“1654697296”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”,“consideration”:[{“token”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“itemType”:1,“endAmount”:“502000000000000000”,“recipient”:“0xb0b5cd643f2a0c4d8f1a35a55f541fed7dbb3976”,“startAmount”:“502000000000000000”,“identifierOrCriteria”:“0”}],“totalOriginalConsiderationItems”:“1”}},{“signature”:“0x”,“parameters”:{“salt”:“4518561062271738349228793255043488697723314368333408275672868204069879”,“zone”:“0x004c00500000ad104d7dbd00e3ae0a5c00560c00”,“offer”:[],“endTime”:“1988064000”,“offerer”:“0xea8eac204838ea4da2aac95543a9773cb715d332”,“zoneHash”:“0x0000000000000000000000000000000000000000000000000000000000000000”,“orderType”:2,“startTime”:“1654697296”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”,“consideration”:[],“totalOriginalConsiderationItems”:“0”}}]	0xa8174404	0x00000000006c3852cbef3e08e8df289169ede581	15954258	0xea8eac204838ea4da2aac95543a9773cb715d332	[{“item”:{“token”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“amount”:“502000000000000000”,“itemType”:1,“recipient”:“0xb0b5cd643f2a0c4d8f1a35a55f541fed7dbb3976”,“identifier”:“0”},“offerer”:“0xffee7f61536eaf3331f6b5e94c45170ab393e8da”,“conduitKey”:“0x0000007b02230091a7ed01230072f7006a004d60a8d4e71d599b8104250f0000”}]	2022-11-12T13:33:35.000Z	[{“offerComponents”:[{“itemIndex”:“0”,“orderIndex”:“0”}],“considerationComponents”:[{“itemIndex”:“0”,“orderIndex”:“0”}]}]	0x4271f6765e4c3e3360913d3fbcd2df2c0e4fb8cc201085306f455ef5af21a86a

Example Query

Query with partition filter

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

SeaportV1_OrderFulfilled_event

Event emitted when a Seaport protocol order is successfully executed, containing offered items, requested consideration items, order hash, offerer and recipient addresses, and zone contract for validation. Used for tracking NFT and token marketplace transactions across decentralized exchanges.

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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_offerer`	`STRING`	Address of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
`in_zone`	`STRING`	Contract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_offer`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING>>`	Array of items being offered by the seller in the order. Each item specifies the token type, contract address, token identifier, and quantity being sold.
`in_consideration`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING, recipient STRING>>`	Array of items requested by the seller in exchange for the offered items. Each item specifies the token type, contract address, token identifier, amount, and recipient address for payment distribution including seller proceeds and marketplace fees.

Sample Data

address	in_zone	removed	in_offer	log_index	in_offerer	block_number	in_orderHash	in_recipient	block_timestamp	in_consideration	transaction_hash
0x00000000006c3852cbef3e08e8df289169ede581	0x004c00500000ad104d7dbd00e3ae0a5c00560c00	false	[]	45	0xc189e353ae001a727b1cefecc9c43c68825a6c0f	16894734	0xfb8a11972e88185d914cdef31bb061f710471f3170e3b0ef5ab9fb9412e11c2d	0x0000000000000000000000000000000000000000	2023-03-24T03:38:11.000Z	[]	0x2461bf2c08cafa226e578c574dc42eab44adc4b16a71f086e94521c6ac8acacd
0x00000000006c3852cbef3e08e8df289169ede581	0x004c00500000ad104d7dbd00e3ae0a5c00560c00	false	[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“1000000000000000”,“itemType”:0,“identifier”:“0”}]	1	0x09155e8cbb30b34a0fdc65e8419d6c9d684dbe62	16897452	0x1184ed204a080eecdc0b64cf1094dcabf5e91221f382e62044a52de1a06a13e6	0x0000000000000000000000000000000000000000	2023-03-24T12:46:59.000Z	[]	0x34959abeec2622c123efe28693e49a30b6ba8a92e2e6a7f07a0169b05fcaf261
0x00000000006c3852cbef3e08e8df289169ede581	0x004c00500000ad104d7dbd00e3ae0a5c00560c00	false	[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“1000000000000000”,“itemType”:0,“identifier”:“0”}]	28	0x09155e8cbb30b34a0fdc65e8419d6c9d684dbe62	16895458	0xe4a295a5f23a11d15436fa4535dabbea2c06b0b2ab2b1b3478c59d33a70ec204	0x0000000000000000000000000000000000000000	2023-03-24T06:03:59.000Z	[]	0x4c14346d578ae74097e3d0d162e5a24dc3a4db3189a9cb1f86820db3cb6f8e9e

Example Query

Query with partition filter

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

SeaportV2_OrderFulfilled_event

Fulfilled order events from OpenSea’s Seaport V2 protocol on Ethereum, capturing NFT and token sales with offered items, consideration payments, and fee distributions. Used for analyzing trading volume, marketplace fees, and secondary market activity.

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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_offerer`	`STRING`	Address of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
`in_zone`	`STRING`	Contract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_offer`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING>>`	Array of items being offered by the seller in the order. Each item specifies the token type, contract address, token identifier, and quantity being sold.
`in_consideration`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING, recipient STRING>>`	Array of items requested by the seller in exchange for the offered items. Each item specifies the token type, contract address, token identifier, amount, and recipient address for payment distribution including seller proceeds and marketplace fees.

Sample Data

address	in_zone	removed	in_offer	log_index	in_offerer	block_number	in_orderHash	in_recipient	block_timestamp	in_consideration	transaction_hash
0x00000000000006c7676171937c444f6bde3d6282	0x0000000000000000000000000000000000000000	false	[{“token”:“0x1e196b7873b8456437309ba3fa748fa6f1602da8”,“amount”:“1”,“itemType”:3,“identifier”:“17”}]	301	0xfba662e1a8e91a350702cf3b87d0c2d2fb4ba57f	16644643	0x94183a896b55b2f4e8d260ae116502af0df3a64fc40480e89ed796027e6a7225	0x3b52ad533687ce908ba0485ac177c5fb42972962	2023-02-16T23:41:59.000Z	[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“9750000000”,“itemType”:0,“recipient”:“0xfba662e1a8e91a350702cf3b87d0c2d2fb4ba57f”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“250000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”}]	0xaa548ade536ee0dc1d54eb9d498cf92390406b9efb35bba14d8d91567994e714
0x00000000000006c7676171937c444f6bde3d6282	0x0000000000000000000000000000000000000000	false	[{“token”:“0x1e196b7873b8456437309ba3fa748fa6f1602da8”,“amount”:“1”,“itemType”:3,“identifier”:“17”}]	303	0xfba662e1a8e91a350702cf3b87d0c2d2fb4ba57f	16644643	0xcd29a52dbc7dc9071703cca9921454e8464186e294203d360cf84d56a8017ed1	0x3b52ad533687ce908ba0485ac177c5fb42972962	2023-02-16T23:41:59.000Z	[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“11405250000000000”,“itemType”:0,“recipient”:“0xfba662e1a8e91a350702cf3b87d0c2d2fb4ba57f”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“308250000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“616500000000000”,“itemType”:0,“recipient”:“0xfba662e1a8e91a350702cf3b87d0c2d2fb4ba57f”,“identifier”:“0”}]	0xaa548ade536ee0dc1d54eb9d498cf92390406b9efb35bba14d8d91567994e714
0x00000000000006c7676171937c444f6bde3d6282	0x0000000000000000000000000000000000000000	false	[{“token”:“0x1e196b7873b8456437309ba3fa748fa6f1602da8”,“amount”:“1”,“itemType”:3,“identifier”:“17”}]	302	0xfba662e1a8e91a350702cf3b87d0c2d2fb4ba57f	16644643	0xf040227f3e856f0a0138153294e940b01864205814645c1506039e09b61729c2	0x3b52ad533687ce908ba0485ac177c5fb42972962	2023-02-16T23:41:59.000Z	[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“9250000000000000”,“itemType”:0,“recipient”:“0xfba662e1a8e91a350702cf3b87d0c2d2fb4ba57f”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“250000000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“500000000000000”,“itemType”:0,“recipient”:“0xfba662e1a8e91a350702cf3b87d0c2d2fb4ba57f”,“identifier”:“0”}]	0xaa548ade536ee0dc1d54eb9d498cf92390406b9efb35bba14d8d91567994e714

Example Query

Query with partition filter

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

SeaportV2_OrdersMatched_event

OrdersMatched events from OpenSea’s Seaport V2 protocol on Ethereum, recording when NFT orders are successfully matched and filled with paired order hash identifiers. Used for analyzing OpenSea marketplace trading activity and order settlement patterns.

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_orderHashes`	`ARRAY<STRING>`	Array of order hash identifiers that were matched in the transaction. Each hash is a 66-character hex string including 0x prefix.

Sample Data

address	removed	log_index	block_number	in_orderHashes	block_timestamp	transaction_hash
0x00000000000006c7676171937c444f6bde3d6282	false	212	16599965	[“0x199ee111792388a5dd2fbc6636636c357f77671853442f154b4c2d1fa3c2bb2a”,“0x9418a22388cc9d1678f37c5aaf69da2179e42ce1da2ae98f257b5fbf5a4fee25”]	2023-02-10T17:52:11.000Z	0xcab9df9c497f514cbb16f2808a63f6224ee9d1d684c1473c50ea3a3aebeddf52
0x00000000000006c7676171937c444f6bde3d6282	false	163	16599935	[“0xc6608c35bc0e88e983744f225f030c32b20b23be06bf252530413ee2b358b7ce”,“0x2020ee4c181ebe80de86b0b83d4caed44458dcdbdf3e2a9c9e07e32f4f8e093a”]	2023-02-10T17:46:11.000Z	0xf697818140512aa5fe5a8476891a20661a089c044a782d641979695e92d74823
0x00000000000006c7676171937c444f6bde3d6282	false	333	16594731	[“0x6cbcb9de1a49e9d2bec1861ae587a70142cee90f0f2f4a6b938120b271c8d794”,“0xd8d8e5f0ee23eb7839030a8375a0695fc70267c7c7dbfce548c168217595302b”]	2023-02-10T00:19:59.000Z	0x3689e2929181302905dd10c6978543d249c9f498d71447f94340a1f60cc66c5b

Example Query

Query with partition filter

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

SeaportV3_OrderFulfilled_event

No description available.

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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_offerer`	`STRING`	Address of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
`in_zone`	`STRING`	Contract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_offer`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING>>`	Array of items being offered by the seller in the order. Each item specifies the token type, contract address, token identifier, and quantity being sold.
`in_consideration`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING, recipient STRING>>`	Array of items requested by the seller in exchange for the offered items. Each item specifies the token type, contract address, token identifier, amount, and recipient address for payment distribution including seller proceeds and marketplace fees.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SeaportV3_OrdersMatched_event

No description available.

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_orderHashes`	`ARRAY<STRING>`	Array of order hash identifiers that were matched in the transaction. Each hash is a 66-character hex string including 0x prefix.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SeaportV4_OrderFulfilled_event

Event emitted when an order is successfully fulfilled in the Seaport v1.4 protocol, containing offer items, consideration items, offerer address, order hash, and recipient. Used for tracking NFT and token marketplace transactions including sales proceeds and fee distributions.

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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_offerer`	`STRING`	Address of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
`in_zone`	`STRING`	Contract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_offer`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING>>`	Array of items being offered by the seller in the order. Each item specifies the token type, contract address, token identifier, and quantity being sold.
`in_consideration`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING, recipient STRING>>`	Array of items requested by the seller in exchange for the offered items. Each item specifies the token type, contract address, token identifier, amount, and recipient address for payment distribution including seller proceeds and marketplace fees.

Sample Data

address	in_zone	removed	in_offer	log_index	in_offerer	block_number	in_orderHash	in_recipient	block_timestamp	in_consideration	transaction_hash
0x00000000000001ad428e4906ae43d8f9852d0dd6	0x0000000000000000000000000000000000000000	false	[{“token”:“0x306b1ea3ecdf94ab739f1910bbda052ed4a9f949”,“amount”:“1”,“itemType”:2,“identifier”:“16693”}]	128	0x1130331b5aa08c56e932d5f9499cbef86cb67c3e	17501481	0x65871447ee33e5e50018504364814db0d52552c6bb5b1307a3c816fd6b5c0a8f	0xe909ff99b681f34fd224d2f89559e1ba0f8d502c	2023-06-17T19:02:11.000Z	[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“1248750000000000000”,“itemType”:0,“recipient”:“0x1130331b5aa08c56e932d5f9499cbef86cb67c3e”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“33750000000000000”,“itemType”:0,“recipient”:“0x0000a26b00c1f0df003000390027140000faa719”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“67500000000000000”,“itemType”:0,“recipient”:“0xb4d24dacbdffa1bbf9a624044484b3feeb7fdf74”,“identifier”:“0”}]	0x4923e2d3d7281c8abb4c9ee4dcf64026c215287443aa592690012c482f408f24
0x00000000000001ad428e4906ae43d8f9852d0dd6	0xf49c52948bb9b0764b495978da0b21941c63380b	false	[{“token”:“0xe3c783d9647d72f7f13ace64892630e7e33bc968”,“amount”:“1”,“itemType”:2,“identifier”:“1160”}]	248	0xb14dfbbe048699c229fedc4c5fc3dda7d9a9fdf2	17496658	0x8d518156b8ba5fb87318094a8eb083f1f73cbab1c829e8149073cba9f89a2f5f	0xb2f3e77c525e1ab297239a98cfaa2d397ea5575e	2023-06-17T02:49:23.000Z	[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“102300000000000000”,“itemType”:0,“recipient”:“0xb14dfbbe048699c229fedc4c5fc3dda7d9a9fdf2”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“5500000000000000”,“itemType”:0,“recipient”:“0xc0301e31c9540b1f006a403c969267e73db2ad2d”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“2200000000000000”,“itemType”:0,“recipient”:“0xca9337244b5f04cb946391bc8b8a980e988f9a6a”,“identifier”:“0”}]	0x98eb63fedee6da9dc9ccb22d87bf7705ce70e718267b97a34366354e0016d03c
0x00000000000001ad428e4906ae43d8f9852d0dd6	0xf49c52948bb9b0764b495978da0b21941c63380b	false	[{“token”:“0xaebc5416d9d161f122582b083f2bbe0aba959d0d”,“amount”:“1”,“itemType”:2,“identifier”:“753”}]	394	0xbc2197b690d0e696ac76ed935ae55b3614b11191	17988354	0x9d1ab2b8c3a1b57ab92c99ff4de9f80b816b477b76bbb3afbfb44e2787e0a5f4	0xc6e36ba08d02ffef5f09e1ee857be978b60835dc	2023-08-25T01:11:59.000Z	[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“744000000000000”,“itemType”:0,“recipient”:“0xbc2197b690d0e696ac76ed935ae55b3614b11191”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“38000000000000”,“itemType”:0,“recipient”:“0xe7efa0106bb8be8c34e5ffd763e5574500b052d5”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“2000000000000”,“itemType”:0,“recipient”:“0x8ba0e9539a92913ea981aeadd3c0e537eced55fc”,“identifier”:“0”},{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“16000000000000”,“itemType”:0,“recipient”:“0xca9337244b5f04cb946391bc8b8a980e988f9a6a”,“identifier”:“0”}]	0xdc8416f3daafc2c5ec3c4b51bad61e4024813c7f7e329e7416f3c559240c8749

Example Query

Query with partition filter

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

SeaportV4_OrdersMatched_event

OrdersMatched event logs from OpenSea’s Seaport v1.4 protocol on Ethereum, capturing paired order hashes when buy and sell orders are matched and executed. Enables analysis of NFT marketplace trade matching patterns and order fulfillment relationships.

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_orderHashes`	`ARRAY<STRING>`	Array of order hash identifiers that were matched in the transaction. Each hash is a 66-character hex string including 0x prefix.

Sample Data

address	removed	log_index	block_number	in_orderHashes	block_timestamp	transaction_hash
0x00000000000001ad428e4906ae43d8f9852d0dd6	false	256	16836345	[“0x7b6098d738e859bf9f577ad8bb841281c7d821c5e631d4f8b3612355ef79fcb6”,“0x893daac728b7682ec6cf7a3521e3c6d404d2f421bc2e716749938a0c3336be83”]	2023-03-15T22:45:47.000Z	0x095f1ab593aab703ddf0915af831a028b55588225d341ed3eed0ddda2f883929
0x00000000000001ad428e4906ae43d8f9852d0dd6	false	256	16836084	[“0xec4e65ff326ce7f1481c3d167d8eeab6ec8b8503d87631a6bf2572e50d8ec8e1”,“0xd99f05d8adfe9b8ba5277247761e7e2e1954148f0d30a1c909c632791e0911b9”]	2023-03-15T21:52:47.000Z	0xf1bdcb05e71472f28ab7c5acbd9c8bb47031f0f0a6a7201afcf36f0676626e9e
0x00000000000001ad428e4906ae43d8f9852d0dd6	false	256	16830500	[“0x9b3f084ef13d097b60adc7d04b1e0284911806a04660dbd3156e31412c0c8095”,“0xdf54730474d68dc991ecea5e4ae42b7d6688067e52cdaa39e721447d497768dc”]	2023-03-15T03:00:59.000Z	0x74ebf2eeed4e90a1cc9378e22931fe91b5cea5d05c0a242c604cfa0d1a342ced

Example Query

Query with partition filter

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

SeaportV5_OrderFulfilled_event

Event logs recording successful order executions on the Seaport v1.5 decentralized exchange protocol. Contains offer items, consideration items (payments and fees), order participants (offerer, recipient, zone), and order hash for tracking marketplace trades across NFTs (ERC-721/ERC-1155) and fungible tokens.

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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_offerer`	`STRING`	Address of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
`in_zone`	`STRING`	Contract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_offer`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING>>`	Array of items being offered by the seller in the order. Each item specifies the token type, contract address, token identifier, and quantity being sold.
`in_consideration`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING, recipient STRING>>`	Array of items requested by the seller in exchange for the offered items. Each item specifies the token type, contract address, token identifier, amount, and recipient address for payment distribution including seller proceeds and marketplace fees.

Sample Data

address	in_zone	removed	in_offer	log_index	in_offerer	block_number	in_orderHash	in_recipient	block_timestamp	in_consideration	transaction_hash
0x00000000000000adc04c56bf30ac9d3c0aaf14dc	0x0000000000000000000000000000000000000000	false	[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“9000000000000000”,“itemType”:0,“identifier”:“0”}]	236	0x35ae6a2ffddbf75b7fbfdb588452cbb40f9dc398	17261640	0x12ff9d12c1371fef4dd708c98132ac8dc342e94c66b18da52add64041855079e	0x35ae6a2ffddbf75b7fbfdb588452cbb40f9dc398	2023-05-15T00:27:47.000Z	[]	0xcc48a124b41438c9cfaf5937f4a3b381f5f6ca94862774740a6f15065cae195b
0x00000000000000adc04c56bf30ac9d3c0aaf14dc	0x0000000000000000000000000000000000000000	false	[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“29000000000000000”,“itemType”:0,“identifier”:“0”}]	383	0xc13e645952f7cf4185a263937d2b7ac44a374665	17268529	0x4fcfb9b0aadb36f8e9595dd83810ab6beb71837b8a438d5fab9a78bb43a91294	0xc13e645952f7cf4185a263937d2b7ac44a374665	2023-05-15T23:48:23.000Z	[]	0xf49a381d552e1ba5a257c603d09bd024fb13a82ca7aaf395a28b41f7f47411d1
0x00000000000000adc04c56bf30ac9d3c0aaf14dc	0x004c00500000ad104d7dbd00e3ae0a5c00560c00	false	[{“token”:“0xa604060890923ff400e8c6f5290461a83aedacec”,“amount”:“1”,“itemType”:3,“identifier”:“33894880862743900359172695696681419588949962673387820040011709952924393144321”}]	1045	0x4aefd29dbaa45cc3ab090be40ba904ee9027e035	17261913	0xd4cfe61c6781bfce566a923883e9be35c096d6195a98d4e70739cab47c6ca5e1	0x003753524215842d8e369e1080fb139c8f39bf9c	2023-05-15T01:23:35.000Z	[]	0x22cf1817b314fb5bb977df9009eabecbf85628677bb1dc2633b9c76763940867

Example Query

Query with partition filter

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

SeaportV5_OrdersMatched_event

Order matching events from OpenSea’s Seaport v1.5 protocol on Ethereum, capturing pairs of order hashes when buy and sell orders are successfully matched and executed. Used for analyzing NFT trading activity, market liquidity, and order fulfillment patterns on OpenSea.

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_orderHashes`	`ARRAY<STRING>`	Array of order hash identifiers that were matched in the transaction. Each hash is a 66-character hex string including 0x prefix.

Sample Data

address	removed	log_index	block_number	in_orderHashes	block_timestamp	transaction_hash
0x00000000000000adc04c56bf30ac9d3c0aaf14dc	false	256	17367376	[“0xe0add6c82739d144a4d04cd14c1d667fdd2586579e8a2ac321fcf36902b7fa2d”,“0x73b603071802f58b5a7b5015062bd1096e9ed1799df7c85f56a6a802e761b17f”]	2023-05-29T21:41:35.000Z	0x548e6967c1e6fcf6d199e7c751ef774f76ca9c47bc5d61e8ad12de0bea2788e2
0x00000000000000adc04c56bf30ac9d3c0aaf14dc	false	256	17367715	[“0x1eb8ce9886e5e227af5ea4ea03ddd7153a173509ba3205e1f60d0ba5254a31b9”,“0x5422b5eb1608aeb3a8930bae6297103b187f4ba56012c7df442c6c7e44a7c82b”]	2023-05-29T22:49:59.000Z	0x43fbe025596a0c5b0252fb1a9e5275a4a0141636f2f44adde447e91096d85109
0x00000000000000adc04c56bf30ac9d3c0aaf14dc	false	256	17367074	[“0x2194667dd77ffef9932943ec821fd9e651af210f3581492dd13ba918c171b530”,“0xb2e63e9d55b76d97bee3bbe02a4615ea978a51579bee993a7d4cfc0e75ca0711”]	2023-05-29T20:40:35.000Z	0x1ba7522395f558a6a56efffc60972f5b44409bed7d87e221a995d7236ee14a8a

Example Query

Query with partition filter

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

SeaportV6_OrderFulfilled_event

Order fulfillment events from OpenSea’s Seaport v1.6 protocol on Ethereum, capturing NFT (ERC-721/ERC-1155) and token (ERC-20) transfers with offer and consideration details. Used for analyzing OpenSea marketplace trades, including multi-asset bundles and payment distributions.

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_orderHash`	`STRING`	Unique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
`in_offerer`	`STRING`	Address of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
`in_zone`	`STRING`	Contract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_recipient`	`STRING`	Address designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_offer`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING>>`	Array of items being offered by the seller in the order. Each item specifies the token type, contract address, token identifier, and quantity being sold.
`in_consideration`	`ARRAY<STRUCT<itemType INT64, token STRING, identifier STRING, amount STRING, recipient STRING>>`	Array of items requested by the seller in exchange for the offered items. Each item specifies the token type, contract address, token identifier, amount, and recipient address for payment distribution including seller proceeds and marketplace fees.

Sample Data

address	in_zone	removed	in_offer	log_index	in_offerer	block_number	in_orderHash	in_recipient	block_timestamp	in_consideration	transaction_hash
0x0000000000000068f116a894984e2db1123eb395	0x0000000000000000000000000000000000000000	false	[{“token”:“0x379b5616a6afe6bc6baa490ef8fd98bf6d7db45c”,“amount”:“1”,“itemType”:2,“identifier”:“55”}]	358	0x7f67f35a25ed0e2c72d54dce89fdb6adf415284b	19520086	0xc4f599bea54b3b784a24ae6a66932c7a835e0dacc3ee587cf170d2c45609fbb7	0x7f67f35a25ed0e2c72d54dce89fdb6adf415284b	2024-03-26T17:28:59.000Z	[]	0x98ec40860ddfa0e4a067599a91ce9130b3e90e70a4a4fb351b9f84b66afa84bc
0x0000000000000068f116a894984e2db1123eb395	0x0000000000000000000000000000000000000000	false	[{“token”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“amount”:“50000000000000000”,“itemType”:1,“identifier”:“0”},{“token”:“0xedb61f74b0d09b2558f1eeb79b247c1f363ae452”,“amount”:“1”,“itemType”:3,“identifier”:“1366”},{“token”:“0x6e9da81ce622fb65abf6a8d8040e460ff2543add”,“amount”:“1”,“itemType”:2,“identifier”:“1279”}]	465	0x87d411bb593218f43b1c76278769a0f5d1b740f4	19521540	0x95aefb720755f36a48716b0dc13ae82e76e6852e12182d30558f7ea151681c2b	0x87d411bb593218f43b1c76278769a0f5d1b740f4	2024-03-26T22:24:23.000Z	[]	0xa6b555f8e782bf0b8049bc33a0cb60fdc01e07ca426fa7aa5b87f9aff3cf5476
0x0000000000000068f116a894984e2db1123eb395	0x0000000000000000000000000000000000000000	false	[{“token”:“0x1a92f7381b9f03921564a437210bb9396471050c”,“amount”:“1”,“itemType”:2,“identifier”:“8183”}]	332	0x74a611163e4197d97c3fb71a84ea5164783396e8	19521762	0x6638f8996e21eeeb225a7408ce4af89884ecc4317d0c98798ae2a408439313bc	0x74a611163e4197d97c3fb71a84ea5164783396e8	2024-03-26T23:10:23.000Z	[]	0x26850f43acdeaf7e2a9af84d826a2905c6c3918bf81fe5a89de4b39de7651ee3

Example Query

Query with partition filter

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

SeaportV6_OrdersMatched_event

Order matching events from OpenSea’s Seaport v1.6 protocol on Ethereum, recording pairs of order hashes when NFT trades are executed. Used for tracking completed marketplace transactions and analyzing order fulfillment patterns.

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_orderHashes`	`ARRAY<STRING>`	Array of order hash identifiers that were matched in the transaction. Each hash is a 66-character hex string including 0x prefix.

Sample Data

address	removed	log_index	block_number	in_orderHashes	block_timestamp	transaction_hash
0x0000000000000068f116a894984e2db1123eb395	false	256	19530288	[“0xd1af029fb91a70e1b8eb5a0c7837f102a77ff12d1052cce091677247d7be5b49”,“0x80bbaa9e0effb4474763f899c728bd0fca73fcf49ac4f7b94e9b490843d02811”]	2024-03-28T04:40:11.000Z	0xccbaceabcf2ca26f7bbc1eec7ecc028227f013f34edb7b1a59ba7cfaf6ccc9cc
0x0000000000000068f116a894984e2db1123eb395	false	257	19529266	[“0x0735e790692e8f379e64c4d504a385c0691ada49021a212329ebe222988a09fd”,“0x09167d84cb5e42d07559336572f1f19f6014fa716632bf07a4de4db15de6bd66”]	2024-03-28T01:11:59.000Z	0xcd652b8825ab0e8be45f011de21731eec6264c5cd2f6433e1d3667ed822767f9
0x0000000000000068f116a894984e2db1123eb395	false	258	19535252	[“0x669dc45fb2af6f76915a8eb02459b56f19c8939bd5916eac4dbcd783f7500b08”,“0x5614e04c5c902963714bedc8a8e3e6f23ed73a5418d8475c4ad0998e97078bcc”]	2024-03-28T21:39:23.000Z	0x594d61b641227394b9b0f8cc7d923c71a1e42920dace34da76adfdd1fcd5a647

Example Query

Query with partition filter

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

WyvernExchange_atomicMatch__function

NFT trade executions from OpenSea’s Wyvern Exchange protocol (v1) on Ethereum, containing matched buy and sell orders with signatures, addresses, calldata, and settlement details for analyzing historical marketplace activity.

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_addrs`	`ARRAY<STRING>`	Array of Ethereum addresses involved in the buy and sell orders being matched, including maker, taker, fee recipients, and token contract addresses. Typically contains 14 addresses representing both sides of the trade in OpenSea’s Wyvern Exchange protocol.
`in_uints`	`ARRAY<STRING>`	Array of unsigned integer parameters for both buy and sell orders in the OpenSea Wyvern Exchange atomicMatch function, including maker/taker fees, prices, timestamps, and order salts. Typically contains 18 values per match (9 for buy order, 9 for sell order) encoded as strings to handle large numbers.
`in_feeMethodsSidesKindsHowToCalls`	`ARRAY<INT64>`	Array encoding trade execution parameters: fee calculation method, order side (buy/sell), asset kind (fungible/non-fungible), and call type for the Wyvern Exchange atomicMatch function. Values appear as arrays of 8 integers representing packed configuration flags.
`in_calldataBuy`	`STRING`	Hex-encoded calldata for the buy-side order in the atomicMatch function, specifying transfer parameters like recipient and token ID. Typically represents an ERC721 or ERC1155 transfer function call from the buyer’s perspective.
`in_calldataSell`	`STRING`	Encoded function call data for the sell-side order in the NFT trade match. This hexadecimal string typically represents an ERC721 or ERC1155 transfer function with seller address, token ID, and transfer parameters.
`in_replacementPatternBuy`	`STRING`	Hex-encoded pattern used to mask variable portions of the buy-side calldata in OpenSea’s Wyvern protocol order matching. Pattern contains `0x00` for exact-match bytes and `0xff` for wildcard positions that can vary between orders.
`in_replacementPatternSell`	`STRING`	Byte mask defining which parts of the sell order calldata can be replaced during order matching in OpenSea’s Wyvern Exchange protocol. Typically contains alternating sequences of zeros and 0xff values to indicate fixed versus variable parameters.
`in_staticExtradataBuy`	`STRING`	Static extra data field from the buy-side order in Wyvern Exchange atomicMatch function. Typically empty (0x) as seen in all sample transactions.
`in_staticExtradataSell`	`STRING`	Static extra data for the sell order in OpenSea’s Wyvern Exchange protocol. This field is typically empty (0x) as shown in sample data, used only for specific advanced matching scenarios.
`in_vs`	`ARRAY<INT64>`	ECDSA signature component vs, which combines the recovery identifier v with the signature component s for compact signature representation. 66-character hex string including 0x prefix.
`in_rssMetadata`	`ARRAY<STRING>`	Metadata array containing order hashes and signatures for both buy and sell orders in the atomicMatch transaction. Typically contains five 32-byte hex values including matching order identifiers and a trailing zero hash.

Sample Data

gas	in_vs	value	status	gas_used	in_addrs	in_uints	signature	to_address	block_number	from_address	in_calldataBuy	in_rssMetadata	block_timestamp	in_calldataSell	transaction_hash	in_staticExtradataBuy	in_staticExtradataSell	in_replacementPatternBuy	in_replacementPatternSell	in_feeMethodsSidesKindsHowToCalls
266733	[28,28]	140000000000000000	true	206843	[“0x7be8076f4ea4a4ad08075c2508e481d6c946d12b”,“0x0008d343091ef8bd3efa730f6aae5a26a285c7a2”,“0x05f8e15d6d0ea924fc3c67d17d7cae4f8243c9ae”,“0x0000000000000000000000000000000000000000”,“0x5c1749bc5734b8f9ea7cda7e38b47432c6cffb66”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x7be8076f4ea4a4ad08075c2508e481d6c946d12b”,“0x05f8e15d6d0ea924fc3c67d17d7cae4f8243c9ae”,“0x0000000000000000000000000000000000000000”,“0x5b3256965e7c3cf26e11fcaf296dfc8807c01073”,“0x5c1749bc5734b8f9ea7cda7e38b47432c6cffb66”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	[“250”,“0”,“0”,“0”,“140000000000000000”,“0”,“1590119833”,“0”,“82293800229120399680987670060058222123861471395305243124197909399888028841791”,“250”,“0”,“0”,“0”,“140000000000000000”,“0”,“1590119373”,“0”,“29117400081854896597703099286614069163424497568550723620862580179845460320072”]	0xab834bab	0x7be8076f4ea4a4ad08075c2508e481d6c946d12b	10113480	0x0008d343091ef8bd3efa730f6aae5a26a285c7a2	0x23b872dd00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008d343091ef8bd3efa730f6aae5a26a285c7a200000000000000000000000000000000000000000000000000000000000016f1	[“0x26fd9a05ac2bf5af3c5781076d38cf81561c3f4960b2501649f5fffa463b79db”,“0x2c873e3c6c9a2586abab615610ffc9053487d8142c4fa5a75eb0b4e9931f6ec3”,“0x26fd9a05ac2bf5af3c5781076d38cf81561c3f4960b2501649f5fffa463b79db”,“0x2c873e3c6c9a2586abab615610ffc9053487d8142c4fa5a75eb0b4e9931f6ec3”,“0x0000000000000000000000000000000000000000000000000000000000000000”]	2020-05-22T04:04:25.000Z	0x23b872dd00000000000000000000000005f8e15d6d0ea924fc3c67d17d7cae4f8243c9ae000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016f1	0xeddc84a7894c54f7f47fd08a3a83dbcfef3f54ea4f58151c9166c84b9a16c1db	0x	0x	0x00000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x000000000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000	[1,0,0,0,1,1,0,0]
293777	[27,27]	2622547056931192	true	231429	[“0x7be8076f4ea4a4ad08075c2508e481d6c946d12b”,“0x002c551f29a7849561c3748763512c69e1c6254c”,“0x1115de736e97a5cbd16aa74ac6cfb33dd967b0a4”,“0x0000000000000000000000000000000000000000”,“0x2fb5d7dda4f1f20f974a0fdd547c38674e8d940c”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x7be8076f4ea4a4ad08075c2508e481d6c946d12b”,“0x1115de736e97a5cbd16aa74ac6cfb33dd967b0a4”,“0x0000000000000000000000000000000000000000”,“0x5b3256965e7c3cf26e11fcaf296dfc8807c01073”,“0x2fb5d7dda4f1f20f974a0fdd547c38674e8d940c”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	[“250”,“0”,“0”,“0”,“10000000000000000”,“0”,“1590179997”,“0”,“95867484356696183222414415289205799021052498177013363896524811110228965950964”,“250”,“0”,“0”,“0”,“10000000000000000”,“8000000000000000”,“1589781571”,“1590213654”,“28191317252142338448986217088591083220677432803773344718125357940942269833066”]	0xab834bab	0x7be8076f4ea4a4ad08075c2508e481d6c946d12b	10117835	0x002c551f29a7849561c3748763512c69e1c6254c	0x23b872dd0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c551f29a7849561c3748763512c69e1c6254c0000000000000000000000000000000000000000000000000000000000008179	[“0x215c69df4a6fa85b7e9996bff7c8ed0dd3f8a296100b429f154c77dd4c482ab0”,“0x57747e6bcd231cc89b065774947812f26a711b4d698016bf031e88a2b0a21946”,“0x215c69df4a6fa85b7e9996bff7c8ed0dd3f8a296100b429f154c77dd4c482ab0”,“0x57747e6bcd231cc89b065774947812f26a711b4d698016bf031e88a2b0a21946”,“0x0000000000000000000000000000000000000000000000000000000000000000”]	2020-05-22T20:42:18.000Z	0x23b872dd0000000000000000000000001115de736e97a5cbd16aa74ac6cfb33dd967b0a400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008179	0xbb544dc96b053683de63e30d198bad881884db9afd1330f08102f66cf3d1b19a	0x	0x	0x00000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x000000000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000	[1,0,0,0,1,1,1,0]
251727	[28,28]	50000000000000000	true	208201	[“0x7be8076f4ea4a4ad08075c2508e481d6c946d12b”,“0x002c551f29a7849561c3748763512c69e1c6254c”,“0xbc95fa5a2ecb38a5f7e8904623cc941e17b6e79f”,“0x0000000000000000000000000000000000000000”,“0x2fb5d7dda4f1f20f974a0fdd547c38674e8d940c”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”,“0x7be8076f4ea4a4ad08075c2508e481d6c946d12b”,“0xbc95fa5a2ecb38a5f7e8904623cc941e17b6e79f”,“0x0000000000000000000000000000000000000000”,“0x5b3256965e7c3cf26e11fcaf296dfc8807c01073”,“0x2fb5d7dda4f1f20f974a0fdd547c38674e8d940c”,“0x0000000000000000000000000000000000000000”,“0x0000000000000000000000000000000000000000”]	[“250”,“0”,“0”,“0”,“50000000000000000”,“0”,“1590123152”,“0”,“98793867197450407422648979283284217594607991093931360181487495980215752894682”,“250”,“0”,“0”,“0”,“50000000000000000”,“0”,“1589449621”,“0”,“52517408999260993846556770245143710074100618279201533952588174921085869796274”]	0xab834bab	0x7be8076f4ea4a4ad08075c2508e481d6c946d12b	10113706	0x002c551f29a7849561c3748763512c69e1c6254c	0x23b872dd0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c551f29a7849561c3748763512c69e1c6254c0000000000000000000000000000000000000000000000000000000000009b30	[“0x464ebbad95320e186f79503f916785e1e0fa6e0e621ad56af08c683dafac15c8”,“0x134cd39da0222be3a1957191e5ae4307e734fd130f9c51b255f2c9ee3fd2e08b”,“0x464ebbad95320e186f79503f916785e1e0fa6e0e621ad56af08c683dafac15c8”,“0x134cd39da0222be3a1957191e5ae4307e734fd130f9c51b255f2c9ee3fd2e08b”,“0x0000000000000000000000000000000000000000000000000000000000000000”]	2020-05-22T04:54:42.000Z	0x23b872dd000000000000000000000000bc95fa5a2ecb38a5f7e8904623cc941e17b6e79f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009b30	0x6f8eabb0d7ec598d7001f9fe5c4eaf3b0ad46d08651493eb3227d1aa49665359	0x	0x	0x00000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x000000000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000	[1,0,0,0,1,1,0,0]

Example Query

Query with partition filter

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

WyvernExchange_OrdersMatched_event

NFT order matching events from OpenSea’s legacy Wyvern Exchange protocol on Ethereum, recording maker/taker addresses, sale prices in wei, and order hashes. Used for analyzing historical NFT trading activity and marketplace liquidity before OpenSea’s Seaport upgrade.

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_buyHash`	`STRING`	Hash of the buy order matched in this OpenSea WyvernExchange transaction. Zero hash (0x000…000) indicates the transaction was a seller-accepted offer rather than a buyer-accepted listing.
`in_sellHash`	`STRING`	Hash of the sell order in the matched NFT trade on OpenSea’s Wyvern Exchange protocol. Zero-filled (0x000…000) when the transaction represents a buy-side order execution.
`in_maker`	`STRING`	Address of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
`in_taker`	`STRING`	Address of the order taker who filled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
`in_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_metadata`	`STRING`	Metadata payload associated with the operation. Hex-encoded bytes containing protocol-specific auxiliary data such as action identifiers, addresses, amounts, and configuration parameters.

Sample Data

address	removed	in_maker	in_price	in_taker	log_index	in_buyHash	in_metadata	in_sellHash	block_number	block_timestamp	transaction_hash
0x7f268357a8c2552623316e2562d90e642bb538e5	false	0x09f38485d3599b9afe533f37a6bdfcc0217ac3c5	1190000000000000000	0xd29f5424b51add589cba775972ec0ad2f302e3c8	142	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0xc31ce0e53114a85495dbf5275c171b0dd8bb62044188119e385eca4d3c7a64e7	14688768	2022-05-01T00:33:35.000Z	0xc81dab0f90d75f9f089ca57836bf28d34d423c32fb31f1af34a612584242890d
0x7f268357a8c2552623316e2562d90e642bb538e5	false	0x1fce1a6557324d061f7d1360d56f770a5bcf02f2	139000000000000000	0x6b96ce879c69fc7b61220d78faa09e735c4339cc	180	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x2ac2ee8c891f06670c20037416ff7f07d4bc70b073da76d5674d9424a15933b5	14688768	2022-05-01T00:33:35.000Z	0xeeadc939c1296cc7232283a49ab59537937b8582e77f0fcb19c05ec6e14e1243
0x7f268357a8c2552623316e2562d90e642bb538e5	false	0x5b3877cf766a447d0de44415bf78dd330e86d146	840000000000000000	0x3a6a38469b1e469ae19c91dbf2d54465ef20838f	66	0x0000000000000000000000000000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000000000000000000000000000	0x1af9385f6a03411345547b3ba9747e47f67dd881fa782e8bc7acd284f0f78d54	14688768	2022-05-01T00:33:35.000Z	0xc6a9c436a7fdb6d5d4e30956120f03c98569db9fe313aef36bf92e0b49ce92e3

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

SeaportV1_matchAdvancedOrders_function

SeaportV1_matchOrders_function

SeaportV1_OrderFulfilled_event

SeaportV2_OrderFulfilled_event

SeaportV2_OrdersMatched_event

SeaportV3_OrderFulfilled_event

SeaportV3_OrdersMatched_event

SeaportV4_OrderFulfilled_event

SeaportV4_OrdersMatched_event

SeaportV5_OrderFulfilled_event

SeaportV5_OrdersMatched_event

SeaportV6_OrderFulfilled_event

SeaportV6_OrdersMatched_event

WyvernExchange_atomicMatch__function

WyvernExchange_OrdersMatched_event

​Tables

​SeaportV1_matchAdvancedOrders_function

​SeaportV1_matchOrders_function

​SeaportV1_OrderFulfilled_event

​SeaportV2_OrderFulfilled_event

​SeaportV2_OrdersMatched_event

​SeaportV3_OrderFulfilled_event

​SeaportV3_OrdersMatched_event

​SeaportV4_OrderFulfilled_event

​SeaportV4_OrdersMatched_event

​SeaportV5_OrderFulfilled_event

​SeaportV5_OrdersMatched_event

​SeaportV6_OrderFulfilled_event

​SeaportV6_OrdersMatched_event

​WyvernExchange_atomicMatch__function

​WyvernExchange_OrdersMatched_event

Tables

SeaportV1_matchAdvancedOrders_function

SeaportV1_matchOrders_function

SeaportV1_OrderFulfilled_event

SeaportV2_OrderFulfilled_event

SeaportV2_OrdersMatched_event

SeaportV3_OrderFulfilled_event

SeaportV3_OrdersMatched_event

SeaportV4_OrderFulfilled_event

SeaportV4_OrdersMatched_event

SeaportV5_OrderFulfilled_event

SeaportV5_OrdersMatched_event

SeaportV6_OrderFulfilled_event

SeaportV6_OrdersMatched_event

WyvernExchange_atomicMatch__function

WyvernExchange_OrdersMatched_event