Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_advancedOrdersARRAY<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_criteriaResolversARRAY<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_fulfillmentsARRAY<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_executionsARRAY<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.
gasvaluestatusgas_usedsignatureto_addressblock_numberfrom_addresstrace_addressout_executionsblock_timestampin_fulfillmentstransaction_hashin_advancedOrdersin_criteriaResolvers
2606951000000000000true2526310x55944a420x00000000006c3852cbef3e08e8df289169ede581158150090x046f1d6a402b4d0285538b3e998bd86497c3bb26[{“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”}][]
2606711000000000000true2526070x55944a420x00000000006c3852cbef3e08e8df289169ede581158149860x24d94bf5568584fb0141dd861fb81593f6bb341f[{“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”}][]
2606471000000000000true2525830x55944a420x00000000006c3852cbef3e08e8df289169ede581158202800x048914a24912004ecaa6a99b7a4fb99a9d3931a0[{“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”}][]
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_ordersARRAY<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_fulfillmentsARRAY<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_executionsARRAY<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.
gasvaluestatusgas_usedin_orderssignatureto_addressblock_numberfrom_addresstrace_addressout_executionsblock_timestampin_fulfillmentstransaction_hash
1720570true167599[{“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”}}]0xa81744040x00000000006c3852cbef3e08e8df289169ede581159552130xea8eac204838ea4da2aac95543a9773cb715d332[{“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
1746780true165420[{“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”}}]0xa81744040x00000000006c3852cbef3e08e8df289169ede581159542450x4574043b6423953723356237042bf6df2304f297[{“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
1746900true165432[{“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”}}]0xa81744040x00000000006c3852cbef3e08e8df289169ede581159542580xea8eac204838ea4da2aac95543a9773cb715d332[{“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
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderHashSTRINGUnique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
in_offererSTRINGAddress of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
in_zoneSTRINGContract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_offerARRAY<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_considerationARRAY<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.
addressin_zoneremovedin_offerlog_indexin_offererblock_numberin_orderHashin_recipientblock_timestampin_considerationtransaction_hash
0x00000000006c3852cbef3e08e8df289169ede5810x004c00500000ad104d7dbd00e3ae0a5c00560c00false[]450xc189e353ae001a727b1cefecc9c43c68825a6c0f168947340xfb8a11972e88185d914cdef31bb061f710471f3170e3b0ef5ab9fb9412e11c2d0x00000000000000000000000000000000000000002023-03-24T03:38:11.000Z[]0x2461bf2c08cafa226e578c574dc42eab44adc4b16a71f086e94521c6ac8acacd
0x00000000006c3852cbef3e08e8df289169ede5810x004c00500000ad104d7dbd00e3ae0a5c00560c00false[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“1000000000000000”,“itemType”:0,“identifier”:“0”}]10x09155e8cbb30b34a0fdc65e8419d6c9d684dbe62168974520x1184ed204a080eecdc0b64cf1094dcabf5e91221f382e62044a52de1a06a13e60x00000000000000000000000000000000000000002023-03-24T12:46:59.000Z[]0x34959abeec2622c123efe28693e49a30b6ba8a92e2e6a7f07a0169b05fcaf261
0x00000000006c3852cbef3e08e8df289169ede5810x004c00500000ad104d7dbd00e3ae0a5c00560c00false[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“1000000000000000”,“itemType”:0,“identifier”:“0”}]280x09155e8cbb30b34a0fdc65e8419d6c9d684dbe62168954580xe4a295a5f23a11d15436fa4535dabbea2c06b0b2ab2b1b3478c59d33a70ec2040x00000000000000000000000000000000000000002023-03-24T06:03:59.000Z[]0x4c14346d578ae74097e3d0d162e5a24dc3a4db3189a9cb1f86820db3cb6f8e9e
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderHashSTRINGUnique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
in_offererSTRINGAddress of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
in_zoneSTRINGContract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_offerARRAY<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_considerationARRAY<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.
addressin_zoneremovedin_offerlog_indexin_offererblock_numberin_orderHashin_recipientblock_timestampin_considerationtransaction_hash
0x00000000000006c7676171937c444f6bde3d62820x0000000000000000000000000000000000000000false[{“token”:“0x1e196b7873b8456437309ba3fa748fa6f1602da8”,“amount”:“1”,“itemType”:3,“identifier”:“17”}]3010xfba662e1a8e91a350702cf3b87d0c2d2fb4ba57f166446430x94183a896b55b2f4e8d260ae116502af0df3a64fc40480e89ed796027e6a72250x3b52ad533687ce908ba0485ac177c5fb429729622023-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
0x00000000000006c7676171937c444f6bde3d62820x0000000000000000000000000000000000000000false[{“token”:“0x1e196b7873b8456437309ba3fa748fa6f1602da8”,“amount”:“1”,“itemType”:3,“identifier”:“17”}]3030xfba662e1a8e91a350702cf3b87d0c2d2fb4ba57f166446430xcd29a52dbc7dc9071703cca9921454e8464186e294203d360cf84d56a8017ed10x3b52ad533687ce908ba0485ac177c5fb429729622023-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
0x00000000000006c7676171937c444f6bde3d62820x0000000000000000000000000000000000000000false[{“token”:“0x1e196b7873b8456437309ba3fa748fa6f1602da8”,“amount”:“1”,“itemType”:3,“identifier”:“17”}]3020xfba662e1a8e91a350702cf3b87d0c2d2fb4ba57f166446430xf040227f3e856f0a0138153294e940b01864205814645c1506039e09b61729c20x3b52ad533687ce908ba0485ac177c5fb429729622023-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
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderHashesARRAY<STRING>Array of order hash identifiers that were matched in the transaction. Each hash is a 66-character hex string including 0x prefix.
addressremovedlog_indexblock_numberin_orderHashesblock_timestamptransaction_hash
0x00000000000006c7676171937c444f6bde3d6282false21216599965[“0x199ee111792388a5dd2fbc6636636c357f77671853442f154b4c2d1fa3c2bb2a”,“0x9418a22388cc9d1678f37c5aaf69da2179e42ce1da2ae98f257b5fbf5a4fee25”]2023-02-10T17:52:11.000Z0xcab9df9c497f514cbb16f2808a63f6224ee9d1d684c1473c50ea3a3aebeddf52
0x00000000000006c7676171937c444f6bde3d6282false16316599935[“0xc6608c35bc0e88e983744f225f030c32b20b23be06bf252530413ee2b358b7ce”,“0x2020ee4c181ebe80de86b0b83d4caed44458dcdbdf3e2a9c9e07e32f4f8e093a”]2023-02-10T17:46:11.000Z0xf697818140512aa5fe5a8476891a20661a089c044a782d641979695e92d74823
0x00000000000006c7676171937c444f6bde3d6282false33316594731[“0x6cbcb9de1a49e9d2bec1861ae587a70142cee90f0f2f4a6b938120b271c8d794”,“0xd8d8e5f0ee23eb7839030a8375a0695fc70267c7c7dbfce548c168217595302b”]2023-02-10T00:19:59.000Z0x3689e2929181302905dd10c6978543d249c9f498d71447f94340a1f60cc66c5b
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderHashSTRINGUnique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
in_offererSTRINGAddress of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
in_zoneSTRINGContract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_offerARRAY<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_considerationARRAY<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.
No sample data available.
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderHashesARRAY<STRING>Array of order hash identifiers that were matched in the transaction. Each hash is a 66-character hex string including 0x prefix.
No sample data available.
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderHashSTRINGUnique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
in_offererSTRINGAddress of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
in_zoneSTRINGContract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_offerARRAY<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_considerationARRAY<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.
addressin_zoneremovedin_offerlog_indexin_offererblock_numberin_orderHashin_recipientblock_timestampin_considerationtransaction_hash
0x00000000000001ad428e4906ae43d8f9852d0dd60x0000000000000000000000000000000000000000false[{“token”:“0x306b1ea3ecdf94ab739f1910bbda052ed4a9f949”,“amount”:“1”,“itemType”:2,“identifier”:“16693”}]1280x1130331b5aa08c56e932d5f9499cbef86cb67c3e175014810x65871447ee33e5e50018504364814db0d52552c6bb5b1307a3c816fd6b5c0a8f0xe909ff99b681f34fd224d2f89559e1ba0f8d502c2023-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
0x00000000000001ad428e4906ae43d8f9852d0dd60xf49c52948bb9b0764b495978da0b21941c63380bfalse[{“token”:“0xe3c783d9647d72f7f13ace64892630e7e33bc968”,“amount”:“1”,“itemType”:2,“identifier”:“1160”}]2480xb14dfbbe048699c229fedc4c5fc3dda7d9a9fdf2174966580x8d518156b8ba5fb87318094a8eb083f1f73cbab1c829e8149073cba9f89a2f5f0xb2f3e77c525e1ab297239a98cfaa2d397ea5575e2023-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
0x00000000000001ad428e4906ae43d8f9852d0dd60xf49c52948bb9b0764b495978da0b21941c63380bfalse[{“token”:“0xaebc5416d9d161f122582b083f2bbe0aba959d0d”,“amount”:“1”,“itemType”:2,“identifier”:“753”}]3940xbc2197b690d0e696ac76ed935ae55b3614b11191179883540x9d1ab2b8c3a1b57ab92c99ff4de9f80b816b477b76bbb3afbfb44e2787e0a5f40xc6e36ba08d02ffef5f09e1ee857be978b60835dc2023-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
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderHashesARRAY<STRING>Array of order hash identifiers that were matched in the transaction. Each hash is a 66-character hex string including 0x prefix.
addressremovedlog_indexblock_numberin_orderHashesblock_timestamptransaction_hash
0x00000000000001ad428e4906ae43d8f9852d0dd6false25616836345[“0x7b6098d738e859bf9f577ad8bb841281c7d821c5e631d4f8b3612355ef79fcb6”,“0x893daac728b7682ec6cf7a3521e3c6d404d2f421bc2e716749938a0c3336be83”]2023-03-15T22:45:47.000Z0x095f1ab593aab703ddf0915af831a028b55588225d341ed3eed0ddda2f883929
0x00000000000001ad428e4906ae43d8f9852d0dd6false25616836084[“0xec4e65ff326ce7f1481c3d167d8eeab6ec8b8503d87631a6bf2572e50d8ec8e1”,“0xd99f05d8adfe9b8ba5277247761e7e2e1954148f0d30a1c909c632791e0911b9”]2023-03-15T21:52:47.000Z0xf1bdcb05e71472f28ab7c5acbd9c8bb47031f0f0a6a7201afcf36f0676626e9e
0x00000000000001ad428e4906ae43d8f9852d0dd6false25616830500[“0x9b3f084ef13d097b60adc7d04b1e0284911806a04660dbd3156e31412c0c8095”,“0xdf54730474d68dc991ecea5e4ae42b7d6688067e52cdaa39e721447d497768dc”]2023-03-15T03:00:59.000Z0x74ebf2eeed4e90a1cc9378e22931fe91b5cea5d05c0a242c604cfa0d1a342ced
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderHashSTRINGUnique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
in_offererSTRINGAddress of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
in_zoneSTRINGContract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_offerARRAY<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_considerationARRAY<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.
addressin_zoneremovedin_offerlog_indexin_offererblock_numberin_orderHashin_recipientblock_timestampin_considerationtransaction_hash
0x00000000000000adc04c56bf30ac9d3c0aaf14dc0x0000000000000000000000000000000000000000false[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“9000000000000000”,“itemType”:0,“identifier”:“0”}]2360x35ae6a2ffddbf75b7fbfdb588452cbb40f9dc398172616400x12ff9d12c1371fef4dd708c98132ac8dc342e94c66b18da52add64041855079e0x35ae6a2ffddbf75b7fbfdb588452cbb40f9dc3982023-05-15T00:27:47.000Z[]0xcc48a124b41438c9cfaf5937f4a3b381f5f6ca94862774740a6f15065cae195b
0x00000000000000adc04c56bf30ac9d3c0aaf14dc0x0000000000000000000000000000000000000000false[{“token”:“0x0000000000000000000000000000000000000000”,“amount”:“29000000000000000”,“itemType”:0,“identifier”:“0”}]3830xc13e645952f7cf4185a263937d2b7ac44a374665172685290x4fcfb9b0aadb36f8e9595dd83810ab6beb71837b8a438d5fab9a78bb43a912940xc13e645952f7cf4185a263937d2b7ac44a3746652023-05-15T23:48:23.000Z[]0xf49a381d552e1ba5a257c603d09bd024fb13a82ca7aaf395a28b41f7f47411d1
0x00000000000000adc04c56bf30ac9d3c0aaf14dc0x004c00500000ad104d7dbd00e3ae0a5c00560c00false[{“token”:“0xa604060890923ff400e8c6f5290461a83aedacec”,“amount”:“1”,“itemType”:3,“identifier”:“33894880862743900359172695696681419588949962673387820040011709952924393144321”}]10450x4aefd29dbaa45cc3ab090be40ba904ee9027e035172619130xd4cfe61c6781bfce566a923883e9be35c096d6195a98d4e70739cab47c6ca5e10x003753524215842d8e369e1080fb139c8f39bf9c2023-05-15T01:23:35.000Z[]0x22cf1817b314fb5bb977df9009eabecbf85628677bb1dc2633b9c76763940867
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderHashesARRAY<STRING>Array of order hash identifiers that were matched in the transaction. Each hash is a 66-character hex string including 0x prefix.
addressremovedlog_indexblock_numberin_orderHashesblock_timestamptransaction_hash
0x00000000000000adc04c56bf30ac9d3c0aaf14dcfalse25617367376[“0xe0add6c82739d144a4d04cd14c1d667fdd2586579e8a2ac321fcf36902b7fa2d”,“0x73b603071802f58b5a7b5015062bd1096e9ed1799df7c85f56a6a802e761b17f”]2023-05-29T21:41:35.000Z0x548e6967c1e6fcf6d199e7c751ef774f76ca9c47bc5d61e8ad12de0bea2788e2
0x00000000000000adc04c56bf30ac9d3c0aaf14dcfalse25617367715[“0x1eb8ce9886e5e227af5ea4ea03ddd7153a173509ba3205e1f60d0ba5254a31b9”,“0x5422b5eb1608aeb3a8930bae6297103b187f4ba56012c7df442c6c7e44a7c82b”]2023-05-29T22:49:59.000Z0x43fbe025596a0c5b0252fb1a9e5275a4a0141636f2f44adde447e91096d85109
0x00000000000000adc04c56bf30ac9d3c0aaf14dcfalse25617367074[“0x2194667dd77ffef9932943ec821fd9e651af210f3581492dd13ba918c171b530”,“0xb2e63e9d55b76d97bee3bbe02a4615ea978a51579bee993a7d4cfc0e75ca0711”]2023-05-29T20:40:35.000Z0x1ba7522395f558a6a56efffc60972f5b44409bed7d87e221a995d7236ee14a8a
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderHashSTRINGUnique identifier for the order being filled or executed. 66-character hex string including 0x prefix.
in_offererSTRINGAddress of the party creating and offering the order for fulfillment. Hex-encoded, 0x-prefixed, 42-character string.
in_zoneSTRINGContract address of the zone enforcing additional order validation and restrictions in Seaport protocol. Hex-encoded, 0x-prefixed, 42-character string.
in_recipientSTRINGAddress designated to receive the output tokens from a swap or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_offerARRAY<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_considerationARRAY<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.
addressin_zoneremovedin_offerlog_indexin_offererblock_numberin_orderHashin_recipientblock_timestampin_considerationtransaction_hash
0x0000000000000068f116a894984e2db1123eb3950x0000000000000000000000000000000000000000false[{“token”:“0x379b5616a6afe6bc6baa490ef8fd98bf6d7db45c”,“amount”:“1”,“itemType”:2,“identifier”:“55”}]3580x7f67f35a25ed0e2c72d54dce89fdb6adf415284b195200860xc4f599bea54b3b784a24ae6a66932c7a835e0dacc3ee587cf170d2c45609fbb70x7f67f35a25ed0e2c72d54dce89fdb6adf415284b2024-03-26T17:28:59.000Z[]0x98ec40860ddfa0e4a067599a91ce9130b3e90e70a4a4fb351b9f84b66afa84bc
0x0000000000000068f116a894984e2db1123eb3950x0000000000000000000000000000000000000000false[{“token”:“0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2”,“amount”:“50000000000000000”,“itemType”:1,“identifier”:“0”},{“token”:“0xedb61f74b0d09b2558f1eeb79b247c1f363ae452”,“amount”:“1”,“itemType”:3,“identifier”:“1366”},{“token”:“0x6e9da81ce622fb65abf6a8d8040e460ff2543add”,“amount”:“1”,“itemType”:2,“identifier”:“1279”}]4650x87d411bb593218f43b1c76278769a0f5d1b740f4195215400x95aefb720755f36a48716b0dc13ae82e76e6852e12182d30558f7ea151681c2b0x87d411bb593218f43b1c76278769a0f5d1b740f42024-03-26T22:24:23.000Z[]0xa6b555f8e782bf0b8049bc33a0cb60fdc01e07ca426fa7aa5b87f9aff3cf5476
0x0000000000000068f116a894984e2db1123eb3950x0000000000000000000000000000000000000000false[{“token”:“0x1a92f7381b9f03921564a437210bb9396471050c”,“amount”:“1”,“itemType”:2,“identifier”:“8183”}]3320x74a611163e4197d97c3fb71a84ea5164783396e8195217620x6638f8996e21eeeb225a7408ce4af89884ecc4317d0c98798ae2a408439313bc0x74a611163e4197d97c3fb71a84ea5164783396e82024-03-26T23:10:23.000Z[]0x26850f43acdeaf7e2a9af84d826a2905c6c3918bf81fe5a89de4b39de7651ee3
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_orderHashesARRAY<STRING>Array of order hash identifiers that were matched in the transaction. Each hash is a 66-character hex string including 0x prefix.
addressremovedlog_indexblock_numberin_orderHashesblock_timestamptransaction_hash
0x0000000000000068f116a894984e2db1123eb395false25619530288[“0xd1af029fb91a70e1b8eb5a0c7837f102a77ff12d1052cce091677247d7be5b49”,“0x80bbaa9e0effb4474763f899c728bd0fca73fcf49ac4f7b94e9b490843d02811”]2024-03-28T04:40:11.000Z0xccbaceabcf2ca26f7bbc1eec7ecc028227f013f34edb7b1a59ba7cfaf6ccc9cc
0x0000000000000068f116a894984e2db1123eb395false25719529266[“0x0735e790692e8f379e64c4d504a385c0691ada49021a212329ebe222988a09fd”,“0x09167d84cb5e42d07559336572f1f19f6014fa716632bf07a4de4db15de6bd66”]2024-03-28T01:11:59.000Z0xcd652b8825ab0e8be45f011de21731eec6264c5cd2f6433e1d3667ed822767f9
0x0000000000000068f116a894984e2db1123eb395false25819535252[“0x669dc45fb2af6f76915a8eb02459b56f19c8939bd5916eac4dbcd783f7500b08”,“0x5614e04c5c902963714bedc8a8e3e6f23ed73a5418d8475c4ad0998e97078bcc”]2024-03-28T21:39:23.000Z0x594d61b641227394b9b0f8cc7d923c71a1e42920dace34da76adfdd1fcd5a647
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
trace_addressSTRINGHierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
statusBOOLTransaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
from_addressSTRINGAddress that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
to_addressSTRINGAddress receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
valueFLOAT64Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
gas_usedINT64Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
gasINT64Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
signatureSTRINGFunction selector identifying which contract function was called. 10-character hex string including 0x prefix.
in_addrsARRAY<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_uintsARRAY<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_feeMethodsSidesKindsHowToCallsARRAY<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_calldataBuySTRINGHex-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_calldataSellSTRINGEncoded 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_replacementPatternBuySTRINGHex-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_replacementPatternSellSTRINGByte 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_staticExtradataBuySTRINGStatic extra data field from the buy-side order in Wyvern Exchange atomicMatch function. Typically empty (0x) as seen in all sample transactions.
in_staticExtradataSellSTRINGStatic 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_vsARRAY<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_rssMetadataARRAY<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.
gasin_vsvaluestatusgas_usedin_addrsin_uintssignatureto_addressblock_numberfrom_addresstrace_addressin_calldataBuyin_rssMetadatablock_timestampin_calldataSelltransaction_hashin_staticExtradataBuyin_staticExtradataSellin_replacementPatternBuyin_replacementPatternSellin_feeMethodsSidesKindsHowToCalls
266733[28,28]140000000000000000true206843[“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”]0xab834bab0x7be8076f4ea4a4ad08075c2508e481d6c946d12b101134800x0008d343091ef8bd3efa730f6aae5a26a285c7a20x23b872dd00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008d343091ef8bd3efa730f6aae5a26a285c7a200000000000000000000000000000000000000000000000000000000000016f1[“0x26fd9a05ac2bf5af3c5781076d38cf81561c3f4960b2501649f5fffa463b79db”,“0x2c873e3c6c9a2586abab615610ffc9053487d8142c4fa5a75eb0b4e9931f6ec3”,“0x26fd9a05ac2bf5af3c5781076d38cf81561c3f4960b2501649f5fffa463b79db”,“0x2c873e3c6c9a2586abab615610ffc9053487d8142c4fa5a75eb0b4e9931f6ec3”,“0x0000000000000000000000000000000000000000000000000000000000000000”]2020-05-22T04:04:25.000Z0x23b872dd00000000000000000000000005f8e15d6d0ea924fc3c67d17d7cae4f8243c9ae000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016f10xeddc84a7894c54f7f47fd08a3a83dbcfef3f54ea4f58151c9166c84b9a16c1db0x0x0x00000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x000000000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000[1,0,0,0,1,1,0,0]
293777[27,27]2622547056931192true231429[“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”]0xab834bab0x7be8076f4ea4a4ad08075c2508e481d6c946d12b101178350x002c551f29a7849561c3748763512c69e1c6254c0x23b872dd0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c551f29a7849561c3748763512c69e1c6254c0000000000000000000000000000000000000000000000000000000000008179[“0x215c69df4a6fa85b7e9996bff7c8ed0dd3f8a296100b429f154c77dd4c482ab0”,“0x57747e6bcd231cc89b065774947812f26a711b4d698016bf031e88a2b0a21946”,“0x215c69df4a6fa85b7e9996bff7c8ed0dd3f8a296100b429f154c77dd4c482ab0”,“0x57747e6bcd231cc89b065774947812f26a711b4d698016bf031e88a2b0a21946”,“0x0000000000000000000000000000000000000000000000000000000000000000”]2020-05-22T20:42:18.000Z0x23b872dd0000000000000000000000001115de736e97a5cbd16aa74ac6cfb33dd967b0a4000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000081790xbb544dc96b053683de63e30d198bad881884db9afd1330f08102f66cf3d1b19a0x0x0x00000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x000000000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000[1,0,0,0,1,1,1,0]
251727[28,28]50000000000000000true208201[“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”]0xab834bab0x7be8076f4ea4a4ad08075c2508e481d6c946d12b101137060x002c551f29a7849561c3748763512c69e1c6254c0x23b872dd0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002c551f29a7849561c3748763512c69e1c6254c0000000000000000000000000000000000000000000000000000000000009b30[“0x464ebbad95320e186f79503f916785e1e0fa6e0e621ad56af08c683dafac15c8”,“0x134cd39da0222be3a1957191e5ae4307e734fd130f9c51b255f2c9ee3fd2e08b”,“0x464ebbad95320e186f79503f916785e1e0fa6e0e621ad56af08c683dafac15c8”,“0x134cd39da0222be3a1957191e5ae4307e734fd130f9c51b255f2c9ee3fd2e08b”,“0x0000000000000000000000000000000000000000000000000000000000000000”]2020-05-22T04:54:42.000Z0x23b872dd000000000000000000000000bc95fa5a2ecb38a5f7e8904623cc941e17b6e79f00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000009b300x6f8eabb0d7ec598d7001f9fe5c4eaf3b0ad46d08651493eb3227d1aa496653590x0x0x00000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x000000000000000000000000000000000000000000000000000000000000000000000000ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000000[1,0,0,0,1,1,0,0]
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_buyHashSTRINGHash 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_sellHashSTRINGHash 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_makerSTRINGAddress of the order maker who created the original order. Hex-encoded, 0x-prefixed, 42-character string.
in_takerSTRINGAddress of the order taker who filled or executed the order. Hex-encoded, 0x-prefixed, 42-character string.
in_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
in_metadataSTRINGMetadata payload associated with the operation. Hex-encoded bytes containing protocol-specific auxiliary data such as action identifiers, addresses, amounts, and configuration parameters.
addressremovedin_makerin_pricein_takerlog_indexin_buyHashin_metadatain_sellHashblock_numberblock_timestamptransaction_hash
0x7f268357a8c2552623316e2562d90e642bb538e5false0x09f38485d3599b9afe533f37a6bdfcc0217ac3c511900000000000000000xd29f5424b51add589cba775972ec0ad2f302e3c81420x00000000000000000000000000000000000000000000000000000000000000000x00000000000000000000000000000000000000000000000000000000000000000xc31ce0e53114a85495dbf5275c171b0dd8bb62044188119e385eca4d3c7a64e7146887682022-05-01T00:33:35.000Z0xc81dab0f90d75f9f089ca57836bf28d34d423c32fb31f1af34a612584242890d
0x7f268357a8c2552623316e2562d90e642bb538e5false0x1fce1a6557324d061f7d1360d56f770a5bcf02f21390000000000000000x6b96ce879c69fc7b61220d78faa09e735c4339cc1800x00000000000000000000000000000000000000000000000000000000000000000x00000000000000000000000000000000000000000000000000000000000000000x2ac2ee8c891f06670c20037416ff7f07d4bc70b073da76d5674d9424a15933b5146887682022-05-01T00:33:35.000Z0xeeadc939c1296cc7232283a49ab59537937b8582e77f0fcb19c05ec6e14e1243
0x7f268357a8c2552623316e2562d90e642bb538e5false0x5b3877cf766a447d0de44415bf78dd330e86d1468400000000000000000x3a6a38469b1e469ae19c91dbf2d54465ef20838f660x00000000000000000000000000000000000000000000000000000000000000000x00000000000000000000000000000000000000000000000000000000000000000x1af9385f6a03411345547b3ba9747e47f67dd881fa782e8bc7acd284f0f78d54146887682022-05-01T00:33:35.000Z0xc6a9c436a7fdb6d5d4e30956120f03c98569db9fe313aef36bf92e0b49ce92e3
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